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

Compresses, encrypts, secures and monitors SQL Server backups.

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

Postby jasolution » Fri May 09, 2014 12:00 am

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!
jasolution
 
Posts: 8
Joined: Tue Oct 07, 2008 4:52 am

Postby eddie davis » Mon May 12, 2014 10:09 am

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
eddie davis
 
Posts: 995
Joined: Wed Jun 14, 2006 3:47 pm
Location: Red Gate Software


Return to SQL Backup 7

Who is online

Users browsing this forum: No registered users and 0 guests