Welcome to the fourth of 10 weeks of the Database Corruption Challenge (DBCC), this is the fourth 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 data loss. This week it is possible with no data loss.
I then post the challenge including the database download and announce it. Those who subscribe to my newsletter will get advance notice to know when it is going to be posted.
For those who competed in any of the previous events, you won’t recognize this database, it’s all new. You may notice that it is a bit larger than previous challenges.
The challenge will be to download the corrupt database and attempt to recover it. If you can recover it, please send me the steps you used to recover the database, along with some proof that the database has been recovered. The goal each week will be the following:
• Recover the database to your best ability.
• You need to be able to bring the database online and run queries against it.
• For any corruption that causes data loss, you need to figure out how to restore as much of the missing data with what you have been given.
Mail your results to before Monday 4th, 2015 at 8:00am pacific time. Results will be posted soon after that.
Good luck, let the games begin…
This week the first winning solution that included the steps to solve the problem, with all the details was submitted by Randolph West. Great work Randolph. The solution took 2 hours and 40 minutes for Randolph to complete. Nice work sticking with it!
Winner #1 – Randolph West
- #2 Patrick Flynn
- #3 Raul Gonzalez
- #4 Neil Abrahams
- #5 Nicolette Boddie
- Subhro Saha
- Seann Alexander
- Rob Farley
- Pasquale Ceglie
- André Kamman
- Herman Atmadja
- Bogdan Sahlean
- Rui Bastos
- Michael Docherty
- David Patterson
- Arthur Baan
- Lucas Kartawidjaja
- Henrik Bo Hansen
- Current Scores
- Newsletter Sign up
- Database Corruption Challenge T-Shirt
- Week 1, Week 2, Week 3, Week 4, Week 5, Week 6, Week 7, Week 8, Week 9, Week 10
- Slow DBCC CheckDB
- Database Corruption Worksheet