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 |
|
sand-lakes1
Starting Member
29 Posts |
 Posted - 2001-04-17 : 05:23:27
|
Hello,Right now I do the following on my production system: - Backups are made on an external server for each seperate database
- backups are done with a sql server agent account which has got relevant rights on the backup server
- test server sql server agent account has relevant right on backup server as well (is other nt-account)
When I rebuild the master database on the test server all previously created database come up. This is fine. But when I restore more user-databases on this test server I have to update device-direcories manually. After this I have to 'force a restore over the existing database'.This is a hell of a job when there are about 30 database.  There should be a way which covers my current live database via a script which gives me the possibility to create the right devices and restore the databases without a force command over the existing databases ?Please help me out.John |
|
|
|
|
|
Script which covers total recovery