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.
Now, let’s get started with the Week 4 Corruption Challenge Details.
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…
Winners:
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!
- #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
Week 4 Solutions:
Related Links
- 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
Database Corruption Challenge Sponsored by
Getting Help from Steve and the Team
Contact us for your Free 30 minute consultation ORschedule your appointment now.
Please I couldnt find the solution attached here. Am I missing something pls
Thanks for pointing this out. The links to the solution were from a different page. I have updated the post above to include the solution links.