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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2000-09-18 : 23:09:36
|
Lionel writes "We currently run an SQL Server database on a 'production' server. Part of that process includes a daily backup of the data. We (Me) then take a copy of the backup and place it on my local machine, which has a local SQL server running. I then Restore those DB's I am interested in through the Enterprise Manager GUI. From these restored DB's we then execute some SAS processes, using ODBC to connect in to the information.
My primary knowledge set is based in SAS, and my experience in SQL Server is very limited. However, I have noted that SQL Server does have the capacity to perform some batch operations. I was hoping I could create a basic 'Restore' operation which I could use to restore the data in a batch mode.
Any direction?
SQL Version 7.0
Windows NT 4.0"
|
|
|
|
|
|
Restoring Backups on a different machine