Copy-only full backups (all recovery models)
A copy-only full backup cannot serve as a differential base or differential backup and does not affect the differential base.
Copy-only log backups (full recovery model and bulk-logged recovery model only)
A copy-only log backup preserves the existing log archive point and, therefore, does not affect the sequencing of regular log backups. Copy-only log backups are typically unnecessary. Instead, you can create another routine, current log backup (using WITH NORECOVERY), and then use that backup together with all other previous log backups that are required for the restore sequence. However, a copy-only log backup can be created for performing an online restore.
To create a copy-only backup (Transact-SQL)
-------------------------------------------
Beginning in SQL Server 2008, SQL Server Management Studio supports copy-only backups.
How to: Back Up a Database (SQL Server Management Studio)
How to: Back Up a Transaction Log (SQL Server Management Studio)
The essential Transact-SQL syntax for a copy-only full backup is:
BACKUP DATABASE database_name TO
COPY_ONLY has no effect when it is specified with the DIFFERENTIAL option.
The essential Transact-SQL syntax for a copy-only log backup is:
BACKUP LOG database_name TO
No comments:
Post a Comment