What are the challenges you face when working across database platforms? Take the survey

Backup Log Shipped Destination Database

RTaylor2208RTaylor2208 Posts: 2
edited September 30, 2011 8:54AM in SQL Backup Previous Versions
Hi, does anyone know if SQL Backups supports taking a backup of a destination log shipped database? We need the database to be online during the backup.

It is possible natively in SQL Server whilst the database is offline but not when online.


  • Options
    Eddie DEddie D Posts: 1,792 Rose Gold 5
    Thank you for your post into the forum.

    SQL Backup does not you allow users to backup the destination or secondary database whilst it is off-line (in NORECOVERY or STANDBY/READONLY).

    To be able to backup the destination database, the database will need to become operational.

    Many Thanks
    Eddie Davis
    Senior Product Support Engineer
    Redgate Software Ltd
    Email: support@red-gate.com
Sign In or Register to comment.