Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
DavidBull
Starting Member
1 Post |
 Posted - 2005-08-15 : 07:11:20
|
| Hi,I am trying to write a VBS to allow end users to automatically restore a SQL database which is used in a demo environment. The aim is to make it as simple as possible for the sales teams so they do not need to go into Enterprise Manager but can just click on the script on demand as and when required.Does anyone have an script which they have sed for something similar which they could share?Thanks |
|
|
Thrasymachus
Constraint Violating Yak Guru
483 Posts |
Posted - 2005-08-15 : 08:31:18
|
| I am extremely presimmistic about giving sales users any such abilities since a lot of them still struggle with email and data entry but I would simply write .bat file that contains the restore operation written to execute from the osql command line.The details about using osql can be found at SQL Server Books Online--> Contents-->Using the SQL Server Tools-->Command Prompt Utilities-->osql utility.If you want to fire this from VB, you should be able to do this using the Shell command.====================================================Regards,Sean RoussyThank you, drive through |
 |
|
|
|
|
|
VBS for database restore