Consider the following scenario:
Suday: full backup
Monday: delta incremental
Tuesday: incremental
Wednesday: delta incremental
Thursday: system crashed
Which of the following options contains the correct restore order so that the database can be
restored to the last stable moment before the crash?
A.
Restore the incremental backup from Tuesday and the incremental backup from Wednesday,
then roll forward the database using the transaction log files.
B.
Restore only the delta incremental backup from Wednesday.
C.
Restore the full backup from Sunday, the incremental cumulative backup from Tuesday, the
incremental delta from Wednesday, then roll forward the database using the transaction log files.
D.
Restore the full backup from Sunday, the delta incremental from Wednesday, then roll forward
the transaction log files.
Explanation: