The seventh week of ten in the Database Corruption Challenge went well. There were a few new participants, and many of those who have competed week over week. The first to submit a correct answer this week was Raul Gonzalez. What was interesting about this challenge was that it was not your typical corruption where you could just run DBCC CheckDB and …
Challenge 7 Details On to the Week 7 Corruption Challenge. For this challenge, any version of SQL Server from 2005 or newer will work, however I don’t know on Azure, and I haven’t tried it on SQL Server 2016 CTP2 yet. I did test it on SQL Server 2005 and on SQL Server 2014. Not all missing data is caused …
Welcome to the seventh 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 in order to prove that it is possible to fix, without data loss. New …
Welcome to the seventh 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 in order to prove that it is possible to fix, without data loss. New …
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 »
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 …