VB backup and restore program

Help please!!!! Is there anyone has a sample code on how to call the backup and restore of SLQ server using VB6. I already have it but, unfortunately the backend of my program is Ms access and I want it to use as SQL server. Any help is highly appreciated....

Thanks,

Jacsme

jacsme

Newbie Poster

4 posts since May 2007

Reputation Points: 10

Solved Threads: 0

5 Years Ago

0

You would be better off using SQL server utilities for backup and restore, You could probably build a DTS package to perform the operation for you.

davidcairns

Junior Poster

114 posts since Feb 2007

Reputation Points: 12

Solved Threads: 8

5 Years Ago

0

what is a DTS package anyway..??? i have a project that we're using sql server. and that project has a menu to backup the database. and it should automatically backup the database same with restore. but manually, the sql server has its own backup menu, but the thing is we dont want the user to do it manually that is why we need it to put a code for that back up.

Jacsme

jacsme

Newbie Poster

4 posts since May 2007

Reputation Points: 10

Solved Threads: 0

5 Years Ago

0

DTS - Data Transformation Services
It ships with SQL Server since version 7, it can be used for a number of tasks including moving large volumes of data around and backing up databases. You can also schedule DTS packages from within SQL Server Enterprise Manager.

Have a look here for some more info

http://www.sqldts.com/

davidcairns

Junior Poster

114 posts since Feb 2007

Reputation Points: 12

Solved Threads: 8

2 Years Ago

0

plz check it.

Attachments back_up_and_restore.txt (2.14KB)

abu taher