Week 3 – Corruption Challenge – The Winning Solution
Find out more about the Week 3 Challenge on the overview blog post.
The winning solution, was submitted by Randolph West with the following steps:
I created a dummy database with the same name, set it offline, deleted the files, dropped in your LDF, brought it back online, and did a tail of the log backup with NO_TRUNCATE to bypass the error.
Then I followed a standard full restore with NORECOVERY, the three transaction logs you supplied, plus my tail, and set WITH RECOVERY to bring it into my shiny 2008 R2 instance.
Read More »Week 3 – Corruption Challenge – The Winning Solution