All about SQL database restore in vb6.

Asked By Marie Philips 30 points N/A Posted on - 12/14/2012

 

 

Hello,

All about sql database restore in vb6. Is it possible for this visual basic 6 programming language to restore sql database files or data? There are some instances that we have to open a data to another application for some important reason. Share with me your idea regarding this matter. I need to study sql database and vb6 for our programming team.

Waiting for your support, thank you.

• Status: Open
• Question Views: 812
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: Visual basic

Answered By Herring Thatr 0 points N/A #165231

All about SQL database restore in vb6.

If you have a backup of the database, there is a way to restore it.  First, you need to open the SQL Server Enterprise Manager (make sure you’re connected to the server where the database will be restored).  Right click the database.  Select “All Tasks”, then “Restore Database.”  A window will appear with the title “Restore Database.”  Under the “General” tab, there is a dropdown menu labeled “Restore as database.”  Select the database the backup will be restoring as from the list.  In a box near the bottom labeled “Parameters”, all the backups of the database will be listed.  Select which backup you want from the list, then click “Properties.”  A dialog box will appear.  Click “OK.”  Back in the “Restore Database” window, switch to the “Options” tab.  Here you can change the settings for the restore.  When you’re ready to start the restore, click the “OK” button.  A dialog box will appear that shows the progress.  Once it’s done restoring, a dialog box will appear to let you know it was successful.

Good luck!

About Herring Thatr

Questions
3

Answers
12

Best Answers
4

• Vote Up 0 Vote Down

• Posted on - 12/14/2012
• Question Category: Visual basic