Week 6 Challenge Details
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 …
Search results for: REPAIR_ALLOW_DATA_LOSS
Week 5 – Alternate Solution
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 …
Week 5 – Winning Solution – Database Corruption Challenge
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 …
Week 5 – Winning Solution – Database Corruption Challenge Read more »
Corruption Challenge 4 – Alternate Solution
Here is the solution provided by Patrick Flynn. Congratulations Patrick for being one of this weeks winners. I really liked this solution for a number of reasons, first it showed how to pull data from DBCC Page and actually convert …
Corruption Challenge Week 4 – The Winning Solution
Congratulations to Randolph West who won the corruption challenge this week with the following solution which restored all of the data. First he restored the database to get started. Note some of his code and comments have been reformatted to …
Corruption Challenge Week 4 – The Winning Solution Read more »
Database Corruption Challenge Week 4 Results
It is my pleasure to announce the winners in the Week 4 Database Corruption Challenge. But first how about a rundown of challenge. In order to make up for the difficult time that Challenge #3 was issued, Challenge #4 was …
Week 4 Extra Clue
SPOILER ALERT…. Page down, if you would like to read the clue, however if you want to proceed without the clue stop reading here. Page down, if you would like to read the clue, however if you want to proceed …
Database Corruption Challenge #2 – Alternate Solution
With week two of the Database Corruption Challenge being just as interesting as week one, and after seeing yesterdays blog posting showing the solution by Rob Farley, you might be thinking you are ready to take on corruption. If you …
Database Corruption Challenge #2 – Alternate Solution Read more »
Corruption Challenge 1 – An alternative solution
After posting the winning solution for Corruption Challenge 1 from Brent Ozar, I realized that he and I both solved the corruption by using the REPAIR_ALLOW_DATA_LOSS option on CheckDb. A very nasty move, however it did repair the corruption. …
Corruption Challenge 1 – An alternative solution Read more »
Corruption Challenge 1 – how I corrupted the database
Since the corruption challenge completed yesterday, I have had several request asking how I created the corrupt database. So here is the script that I used to create the Database Corruption Challenge 1. First the initial setup. Most of this …
Corruption Challenge 1 – how I corrupted the database Read more »