Previous in Forum: paper presentation   Next in Forum: Sharing Folder with XP using a Crossover Cable
Close

Comments Format:






Change Mode
Close

Subscribe to Discussion:

CR4 allows you to "subscribe" to a discussion
so that you can be notified of new comments to
the discussion via email.

Close

Rating Vote:







Add Vote
Rate Comments: Nested
eskew98
Participant

Join Date: Jul 2008
Posts: 3

anybody professional at sql server

09/08/2008 9:59 AM

i want to use backup and restore database using visual basic 6 code. i use sql server 2005 as a database engine. i was using sqldmo but it only works for sql server 2000 and sqlsmo works only for .NET codes.

anybody who can tell me the way to backup and restore sql server 2005 database using visual basic 6 code.
Register to Reply
Pathfinder Tags: sql server professionals
Interested in this topic? By joining CR4 you can "subscribe" to
this discussion and receive notification when new comments are added.
Anonymous Poster
#1

Re: anybody professional at sql server

09/09/2008 9:27 PM

Why do you want to use external programming VB6 or otherwise?

MS SQL server is quite capable of scheduling and executing its own backup.

If your problem is connecting VB6 to SQL server engine then check Microsoft ActiveX Data Objects in the VB6 reference section. This feature gives Command as well as Record Set access to the database. Command would include Backup and restore.
Register to Reply
Register to Reply
Have a Different Question?

Previous in Forum: paper presentation   Next in Forum: Sharing Folder with XP using a Crossover Cable

Advertisement

Got Something to Say?
Ask a Question
Start a Discussion

Search this Forum
Software & Programming:
Go

CR4 Sections
Aerospace
BioMech & BioMed
Chemical & Material Science
Civil Engineering
Communications & Electronics
Education and Engineering Careers
Electrical Engineering
General Discussion
Instrumentation
Manufacturing
Mechanical Engineering
New Technologies & Research
Software & Programming
Sustainable Engineering
Transportation

Site Directories
Forum Directory
Blog Directory
User Group Directory
RSS Feeds

CR4 Rules of Conduct
CR4 FAQ
Site Glossary

Who's Online (79 right now)
Show Members
Advertisement