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. A mismatched version may prevent the database from being restored. The versions or SQL Server supported in this challenge are the following:
- Microsoft SQL Server 2014 – 12.0.2000.8
- Microsoft SQL Server 2012 (SP1) – 11.0.3128.0
- Microsoft SQL Server 2008 R2 (RTM) – 10.50.1600.1
It took me a fair amount of time to set up the challenge on each of these versions. As you get into the challenge, you may recognize why the exact version match is so important, but for now, trust me, you will need the right version.
One you get your database ready to start recovering, it should look something like this:
On to week 5, it is difficult for me to judge how long this will take, as I was the one who corrupted the database, and I know exactly what is broken.
To get started, check out the details here, and be sure you read all the details on what you need to submit to be considered a winner.
Don’t forget to take a look at the current standing of the scores.
- Current Scores
- Newsletter Sign up
- Database Corruption Challenge T-Shirt
- Week 1, Week 2, Week 3, Week 4
- Database Corruption Worksheet