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

jasolutionjasolution Posts: 14 Bronze 2
edited May 12, 2014 5:09AM in SQL Backup Previous Versions
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!
· Share on Twitter

Comments

  • Eddie DEddie D Posts: 1,803 Rose Gold 5
    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
    Senior Product Support Engineer
    Redgate Software Ltd
    Email: support@red-gate.com
    · Share on Twitter
Sign In or Register to comment.