• Koen Verbeeck (2/17/2011)


    Great, thanks for the demo code!

    No problem. I originally wrote it to show how if a database was using Full recovery, you could always recover to a point in time by taking a tail log backup as long as you had taken a full backup at some point. It followed a minor incident where someone deleted some data and then in the ensuing panic someone else restored the most recent full backup over the top, resulting in unrecoverable data loss! (Fortunately it wasn't terribly important data).

    I just adapted the script in order to test the scenario before writing the question.

    Duncan