Wednesday, May 25, 2011

Copy-Only Backups

Copy-Only Backups are useful as special or one-off backups between scheduled full/differential/transaction log backups.   They are useful when doing backups for special purposes for client DBA databases where you don’t have to keep the backup as part of the continuous LSN for recovery purposes.

Syntax:   BACKUP DATABASE database_name TO <backup_device> … WITH COPY_ONLY

No comments:

Post a Comment