Friday, January 29, 2010

All possible RESTORE sequence

If for a database the backup sequence is as below:
FULL BACKUP FULL1
         TRAN LOG BACKUP TLOG1
FULL BACKUP FULL2
         TRAN LOG BACKUP TLOG2
DIFFERENTIAL BACKUP DIFF1
         TRAN LOG BACKUP TLOG3
DIFFERENTIAL BACKUP DIFF2
         TRAN LOG BACKUP TLOG4
Then tlog4 can be restored in following sequences
1. FULL1 > TLOG1 > TLOG2 > TLOG3 > TLOG4
2. FULL2 > TLOG2 > TLOG3 > TLOG4
3. FULL2 > DIFF1 > TLOG3 > TLOG4
4. FULL2 > DIFF2 > TLOG4

No comments: