I've had a report of missing data (restore from full was done, diff wasn't applied) in a db that has the following backup schedule:
daily full @10pm
6 hourly diffs (12/6/12/6)
I now have to restore the db as at 4 days ago, then restore all data added/changed since then.
In testing, have found i can no longer restore the last diff from day 2, ie:
restored full from day 1 (norecovery), restored last diff from before next full backup (norecovery), and now trying to restore last diff from day2 (taken after 2nd full), and getting the well documented error:
"This differential backup cannot be restored because the database has not been restored to the correct earlier state"
I understand the reason for the error, but what is the procedure for recovering in this situation? must I restore each subsequent full db as well? (overwrite/no overwrite, norecovery?)
thanks in advance