Difference between Full backup and Copy-only full backup

3.5K    Asked by KeikoKanda in Salesforce , Asked on Aug 23, 2021

How SQL Server Central thread does a full backup truncate the log? that full backup does not truncate the log:

No. Neither Full or Differential backups truncate the transaction log. - Lynn Pettis

No - a full backup does not truncate the log. - Chad Crawford

So what is the difference between SQL server copy only backup?

For the log backup, there is a copy-only backup which prevents the log chain from breaking without truncating the log. So what is copy-only full backup?

Answered by Mason Lee

A copy-only backup is a special type of full backup, which is independent of the conventional sequence of backups. The difference between copy-only and a full backup is that a copy-only backup doesn't become a base for the next differential backup. A full backup works on all database recovery models.


At the very least you need to consider differential backups. Unless copy-only on the full is used, your next diff backup will be off. Copy-Only Backups:

Copy-only full backups (all recovery models) A copy-only backup cannot serve as a differential base or differential backup and does not affect the differential base.

The only difference between full and full-copy is that full-copy does not break the differential chain. Neither of them breaks the log chain nor truncates the log file.



Your Answer

Interviews

Parent Categories