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 »

Congratulations to Randolph West who won the corruption challenge this week with the following solution which restored all of the data. First he restored the database to get started. Note some of his code and comments have been reformatted to better fit in the blog format. Restore database. I use KEEP_CDC and KEEP_REPLICATION because of the hints you dropped in …

Corruption Challenge Week 4 – The Winning Solution Read more »

Welcome to the DataBase Corruption Challenge, this is an about weekly blog challenge where I will post a corrupt SQL Server database with some details on what happened to it. If at this point you are already a bit irked by my use of capitalization in the DataBase Corruption Challenge, and the acronym of DBCC that I have used to …

Introducing the DataBase Corruption Challenge (DBCC) – Week 1 Challenge Read more »