• Lynn, very good question - I got it right mostly because I have been harping on the same thing that you have 🙂

    For those interested, the other option for restoring to a point in time would be:

    1) Restore full backup from Monday with norecovery

    2) Restore all transaction log backups from Monday to 9am Wednesday with norecovery

    3) Restore tail log backup with recovery

    Or, restore any differential taken before the Tuesday night full and after the Monday night full, and then restore all transaction log backups to the point in time you want.

    The important thing here is that you have an unbroken log chain (transaction log backups). As long as you have that, you can restore from any full backup.

    Jeffrey Williams
    “We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

    ― Charles R. Swindoll

    How to post questions to get better answers faster
    Managing Transaction Logs