1 One
2 Two
3 Three
4 Before full backup
<FULL BACKUP>
5 After full backup
6 Before LOG backup 1
<LOG BACKUP 1>
7 After LOG backup 1
8 Before DIFF backup
<DIFF BACKUP>
9 After DIFF backup
10 Before LOG backup 2
<LOG BACKUP 2>
11 After LOG backup 2
12 Before LOG backup 3
<LOG BACKUP 3>
13 After LOG backup 3
Restore Options
| Backup Files Included in Restore | Data | Note |
|---|---|---|
| FULL | 4 Before full backup | Missing DIFF and LOGS |
| FULL + DIFF | 8 Before DIFF backup | Missing LOGS |
| FULL + DIFF + LOG2 + LOG3 | 12 Before LOG backup 3 | Full data |
| FULL + LOG1 + LOG2 + LOG3 | 12 Before LOG backup 3 | Full data |
| FULL + LOG1 + LOG2 | 10 Before LOG backup 2 | Missing Log 3 |
| FULL + LOG1 | 6 Before LOG backup 1 | Missing Log 2 and Log 3 |
Note:
- For the logs, you have to get all the logs, if you are missing a log, then you will not be able to restore the whole database, only to the point where the last log was applied.
- You can not apply FULL + LOG 3 because you are missing LOG 1 and LOG 2.
Comments