SQL Server Major Backup Types

we have many types of backups but in this article i just discuses 3 types of backups

1. Full Backup:- Backup all data and database objects
2. Differential Backup:- Backup all data and database objects from last full backup
3. 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

Advertisements

 

SQLHero Nov Session – Microsoft Egypt

SQLHero delivered June Session in SQL Enterprise Reporting (SQL2008)

Topic	SQL Enterprise Reporting (SQL2008)
Date	Nov 19, 2009
Time	10:00 – 3:00
Location	Microsoft, Smart Village
Presenter	Ahmed Mosa
Presentation	download