FULL BACKUP FULL1Then tlog4 can be restored in following sequences
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
1. FULL1 > TLOG1 > TLOG2 > TLOG3 > TLOG4
2. FULL2 > TLOG2 > TLOG3 > TLOG4
3. FULL2 > DIFF1 > TLOG3 > TLOG4
4. FULL2 > DIFF2 > TLOG4
No comments:
Post a Comment