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 |
|
ladiaocb
Yak Posting Veteran
57 Posts |
 Posted - 2013-10-30 : 13:11:21
|
| Hello I need help with 2 tasks that I'd like to automate.I have 30 databases that are all in standby mode (log shipping) and I want to be able to automate restoring them all. After testing the failover, I need to reinstate the databases to standby mode. In order to reinstate the standby mode, I do understand I need to use a current backup of the production databases, and I already have a script to disable the logshipping tasks. With that said, does anyone have a handy script to:1. Restore all databases2. Reinstate the databases to standby mode.Thanks in advance! |
|
|
|
|
|
Script to Restore Multiple Databases