Database Corruption Overview: Database corruption is one of those things that you can only plan for by practicing your response plan. Out of all of the things that can happen to your SQL Server this is the one that you are most likely going to want to ask for help when you encounter it. What is Corruption? Database corruption refers …

Database Corruption Overview for Beginners Read more »

Here is how I solved Week 5 of the Database Corruption Challenge. The following steps were tested and confirmed working on SQL Server 2008R2, SQL Server 2012, and SQL Server 2014.   To oversimplify, here are the steps: Restore the last known good database. Shut down the database, and copy off the last good database files. Replace some files and …

Week 5 – Alternate Solution Read more »

Welcome to the Week 5 Corruption Challenge.  If you have seen the t-shirt that I designed for the winner at the end of the 10 week period, please take a look. We are currently at the 5 week midpoint of the 10 week challenge. This challenge requires that you use the exact matching version of SQL Server for the challenge. …

Week 5 – Corruption Challenge Read more »