hesela.devFull backup
A full backup captures every data object within a defined backup scope, whether or not it has changed since an earlier backup.
Full describes coverage of the selected scope, not necessarily an entire server. [1] SQL Server includes enough transaction log in a full database backup to recover it to backup completion; a later recovery point needs subsequent log backups. [2]
Relations
- related
- backup, incremental-backup, differential-backup, synthetic-full-backup, restore-test, point-in-time-recovery
Advantages
- Can provide the complete data baseline for later differential or incremental backups. [1]
Limitations
- Complete scope does not mean coverage of changes made after backup completion. [2]