I have the following backup strategy set up:
My understanding so far, was:
Differential backups do not truncate the transaction log, so, there’s no relation between Diff and Log Backups and both could co-exist in parallel without affecting each other.
Based on this understanding, I thought that I would have two alternatives to perform a complete restore to the most recent state.
This alternative #1 works as expected with no issues.
This alternative #2 shows the following error.
Msg 4305, Level 16, State 1, Line 53 The log in this backup set begins
at LSN 144000000122400001, which is too recent to apply to the
database. An earlier log backup that includes LSN 73000000188800001
can be restored.
After analyzing the backup history, I can conclude that if there are Differential backups prior to Log Backups, the latest Differential backup MUST be restored before restoring backups.
So far, I have always thought that since Full/Diff backups do not affect the chain log, Differential backups were mostly meant to shorten recovery time by reducing the number of log backups to be restored.
If my understanding is correct, there’s indeed a strong dependency between transaction logs and differential backups. In fact, I wouldn’t be able to restore everything If I had lost the latest Differential backup, hence, the Alternative #2 is NOT valid.
Is my understanding correct?