I have noticed that copy only backups does not allow for differential backups.
What is the reason the copy-only backup option is disabled for differential backups?
SQL Server Backup – Why Differential Backup Cannot Be Copy-Only
backupsql server
Related Question
- Sql-server – SQL Server differential backup LSN values
- SQL Server Backup – Full Backup Plus Differential/Copy-Only
- SQL Server – Setting Default Backup to Copy-Only
- SQL Server Backup – Why Differential Backup Can’t Specify Its Base
- Compression Setting Ineffective for Differential Backup Maintenance Plan
- SQL Server – How to Create a Differential Backup Considering the Previous Differential Backup?
- Sql-server – Trouble with differential backup – full backup not being recognized
Best Answer
It can be specified in TSQL but the documentation states
There's no need for copy only differential backups because you can just take a normal differential backup.
Taking a differential backup doesn't break anything as each such backup is cumulative and contains all changes since the last full backup.
If you were to take a full backup without
copy_only
that would potentially be problematic as it resets the differential base (clears the bitmaps containing information about which extents have changed).