Competition: What’s your favorite Redgate tool? Enter now.

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.

Comments

  • Eddie DEddie D Posts: 1,688 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
    Eddie Davis
    Product Support Engineer
    Redgate Software Ltd
    Email: [email protected]
Sign In or Register to comment.