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 » Thu May 08, 2014 11:00 pm

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?

Posts: 8
Joined: Tue Oct 07, 2008 3:52 am

Postby eddie davis » Mon May 12, 2014 9: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 Davis
Technical Support Engineer
Red Gate Software Ltd
eddie davis
Posts: 1024
Joined: Wed Jun 14, 2006 2:47 pm
Location: Red Gate Software

Return to SQL Backup 7

Who is online

Users browsing this forum: No registered users and 0 guests