Red Gate forums :: View topic - Can I setup multiple databases for log shipping at one time?
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Backup 7
SQL Backup 7 forum

Can I setup multiple databases for log shipping at one time?

Search in SQL Backup 7 forum
Post new topic   Reply to topic
Jump to:  
Author Message
jasolution



Joined: 07 Oct 2008
Posts: 8

PostPosted: Fri May 09, 2014 12:00 am    Post subject: Can I setup multiple databases for log shipping at one time? Reply with quote

For SQL Servers with many databases (20+), is there a way to quickly setup multiple databases for log shipping at one time where they would all share the same settings (except destination database, of course) rather than having to do this one database at a time?

Thanks!
Back to top
View user's profile Send private message
eddie davis



Joined: 14 Jun 2006
Posts: 924
Location: Red Gate Software

PostPosted: Mon May 12, 2014 10:09 am    Post subject: Reply with quote

Thank you for your forum post.

The Log Shipping Wizard will only allow you to configure log shipping for one database at a time.

On the source side of the log shipping process, you can use the Backup Wizard and generate the Full Backups of each database that you wish to configure Log Shipping for. Next configure a Scheduled backup job to backup the transaction logs of each database.

On the destination side restore each of the full backups with norecovery or with standby using the restore wizard. Followed creating a scheduled restore job for each log restore.

Either way, there is no quick setup of log shipping for multiple databases.

Many Thanks
Eddie
_________________
Eddie Davis
Technical Support Engineer
Red Gate Software Ltd
E-mail: support@red-gate.com
Back to top
View user's profile Send private message Send e-mail
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group