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 |
|
AgaK
Yak Posting Veteran
86 Posts |
 Posted - 2009-12-29 : 16:37:12
|
| Hi,I would like to hear from you about your periodical backup restore tests strategy. In an environment with over 150 databases what would be the best strategy to test the backups (restore on another server).. How after the backup restore should be tested?Thank youAK |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
AgaK
Yak Posting Veteran
86 Posts |
Posted - 2009-12-29 : 16:45:16
|
| Thank you for your reply. How after should be restore a backup and run DBCC CHECKDB?Should bigger database be tested more often?AK |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
AgaK
Yak Posting Veteran
86 Posts |
Posted - 2009-12-31 : 14:05:27
|
| Thank you! I created a script that creates a job with all the steps (restore and checkdb) based on backups in a folder. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
behrman
Yak Posting Veteran
76 Posts |
Posted - 2010-01-09 : 11:38:33
|
| Hi.Please refer to the url below:http://msdn.microsoft.com/en-us/library/aa173660(SQL.80).aspxRegards,behrman.RAQ Report: Web-based Excel-like Java reporting tool |
|
|
|
|
|
|
backup restore strategy