we have many types of backups but in this article i just discuses 3 types of backups
- Full Backup:- Backup all data and database objects
- Differential Backup:- Backup all data and database objects from last full backup
- Transaction Log Backup:- Backup all transaction from Transaction log file from last official backup official backup can be(Full backup or differential backup or transaction log backup)
let’s discuss fig bellow
F1 is full backup from database
T1 is Transaction Log backup with difference from F1
D1 is differential backup with difference from F1
T2 is Transaction Log backup with difference from D2
D2 is differential backup with difference from F1
T3 is Transaction Log backup with difference from D2
D3 is differential backup with difference from F1
T4 is Transaction Log backup with difference from D3
D4 is differential backup with difference from F1
T5 is Transaction Log backup with difference from D4
D5 is differential backup with difference from F1