Database Corruption Repair Presentation
I discovered this recording from a Database corruption repair presentation that I did a few years ago: Related Links Corruption Repair by Stedman Solutions Corruption Challenge
Tag: Corruption Challenge
Corruption Challenge #8
Welcome to the eighth 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. There is …
Week 6 – Database Corruption Challenge
Welcome to the Week 6 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. For this challenge, any version of SQL Server 2005 or newer will work, however I don’t know on Azure.
Corruption Challenge Solutions So Far
Lately several people have asked me for the solutions to the corruption challenge, so I thought it would be a good time to recap the last 5 weeks. Week 1 of the Database Corruption Challenge was won by Brent Ozar, his solution is posted here. Also there is an alternate solution provided by Andre Kamman. Week 2 of the Database Corruption …
Corruption Challenge 4 – Second Alternate Solution.
The following is a solution to Corruption Challenge #4 that uses DBCC WritePage to fix the corruption. Before proceeding, be sure to read this warning. WARNING: DBCC WritePage is a dangerous command, that should never be used on any production database. It may invalidate your ability to get support from Microsoft on issues that arise with that database going forward. …
Corruption Challenge 4 – Second Alternate Solution. 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 it into rows and columns that could then be inserted back into a table. Secondly due to its use of …