Backup Log Shipped Destination Database
RTaylor2208
Posts: 2
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.
It is possible natively in SQL Server whilst the database is offline but not when online.
Comments
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
Senior Product Support Engineer
Redgate Software Ltd
Email: support@red-gate.com