Lynn Pettis (4/29/2010)

---

Comments posted to this topic are about the item <A HREF="/questions/Backup/69903/">Backups</A>

java56p (4/29/2010)

---

I think the answer is wrong, in my opinion the right one is:

Restore Tuesday nights full backup with norecovery.
Restore the latest differential backup, Wednesday @ 8:00 AM, with norecovery.
Restore all transaction log backups taken since the latest differential backup restored with norecovery.
Restore the tail-log backup with recovery.

awoodhouse (4/29/2010)

---

The question threw me off. Tuesday @ 4pm is not the 'latest differential backup'. Wednesday 8am is.

Lynn Pettis (4/29/2010)

---

Comments posted to this topic are about the item <A HREF="/questions/Backup/69903/">Backups</A>

awoodhouse (4/29/2010)

---

Depends on your point of view. If i were selecting from a list of files on the file system sorted by date created, the most recent one would be Wednesday 8am.

Edit:
Since we are restoring backup files, the file system would be the point of view considered.

CirquedeSQLeil (4/29/2010)

---

Thanks Lynn.


The part that gets me with these questions is if the hardware failure was enough to corrupt the database and the full backup - it would seem to me that you would be unable to perform a tail log backup. After all the failure had to be severe enough that it was able to corrupt files on different drives / luns. Thus I always have to step back and think a little more about it. It must not have been too severe of a hardware failure because the database was able to be brought back online.