Those who are subscribed to my newsletter will receive the exact time of the next corruption challenge. For those who have not subscribed, just keep checking back to find out when the next Database Corruption Challenge begins. Here is the latest update on how the challenge has gone so far: Week 1 was just a wild idea that I had to …
If you are looking for more info on the corrupt database with Week 6 of the Database Corruption Challenge, you can take a look at the original post. Week 6 was won by Raul Gonzalez who submitted his winning solution just 45 minutes after the challenge began. Raul has solved 4 of the 6 challenges so far, and has scored …
Week 6 – The Winning Solution – Database Corruption Challenge Read more »
Welcome to the Week 6 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. For this challenge, any version of SQL Server 2005 or newer will work, however I don’t know on Azure.
File Download The zip file contains a single full backup. See the challenge details for a description. CorruptionChallenge6.zip Related Links Current Scores Newsletter Sign up Database Corruption Challenge T-Shirt Week 1, Week 2, Week 3, Week 4, Week 5, Week 6 Slow DBCC CheckDB Database Corruption Worksheet Database Corruption Challenge Sponsored by
You can download a zip file with a single full backup file created SQL Server 2005 that can be restored and used on SQL 2008, SQL Server 2008R2, SQL Server 2012 or SQL Server 2014. I have confirmed it on SQL Server 2005, and SQL Server 2014. The story, corruption was encountered running DBCC CheckDB that looked like this: …
Welcome to the sixth week of 10 in the Database Corruption Challenge (DBCC), this is an about weekly competition. Here is how it works; I have created a corrupt database, hopefully more corrupt or more interesting than the previous week. I then solved the corruption myself, this time I solved it 2 different ways in order to prove that it …
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 …
Find out more about the Week 5 Challenge on the overview blog post. The winning solution, was submitted by Patrick Flynn, just 3 hours and 18 minutes after the challenge was posted. Patrick provided me with the following steps, and TSQL code to back up the steps: The process was (a) Restore two copies from backup (Old backup has 400 Customers …
Week 5 – Winning Solution – Database Corruption Challenge Read more »
The database name is [CorruptionChallenge5], it was created and backed up on one of the specific versions of SQL Server listed here. Be sure that you get a version to match your SQL Server. Sorry I don’t have any 2005 or 2008 support this time, and there isn’t support for every minor version. Microsoft SQL Server 2014 – 12.0.2000.8 Microsoft …
Welcome to the fifth of 10 weeks of the Database Corruption Challenge (DBCC), this is the fifth in an about weekly competition. Here is how it works; I have created a corrupt database, hopefully more corrupt or more challenging than the previous week. I then solved the corruption myself, in order to prove that it is possible to fix, without …