Please start any new threads on our new site at We've got lots of great SQL Server experts to answer whatever question you can come up with.

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | Active Topics | Members | Search | Forum FAQ
Save Password
Forgot your Password?

 All Forums
 SQL Server 2012 Forums
 Transact-SQL (2012)
 Script to Restore Multiple Databases
 Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Yak Posting Veteran

57 Posts

Posted - 10/30/2013 :  13:11:21  Show Profile  Reply with Quote
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 databases
2. Reinstate the databases to standby mode.

Thanks in advance!
  Previous Topic Topic Next Topic  
 Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.02 seconds. Powered By: Snitz Forums 2000