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

jasolution

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!

Eddie D

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