Another Successful Corruption Repair

This week I completed another successful corruption repair. Here is what the client had to say when the database was repaired:

Stedman Solutions were no less than amazing!

We were in a major bind; we had corruption in a SQL Database and all kinds of finger pointing from my software and hardware vendors. From one of my vendors “ …here is a Microsoft paper on how to fix this error”. I was at the end of the rope.

The corruption had been occurring for an unknown period of time, then it completely died! (all the backups were corrupt for who knows how long). Steve and team went to work immediately and worked virtually non-stop until the problem was resolved.

We had no data loss and very little business time down.

GREAT JOB, and highly recommended!

Dudley Jones

I personally want to thank Patrick Flynn for his awesome solution that he submitted to the Database Corruption Challenge back in 2015. It took some modification and a few hours of work, but I was able to use his solution to pull all of the data out of a table that was totally inaccessible when we tried to query it. Here is the basic outline of what was needed, and if you take a look at the solution from Patrick it is very similar.

Using DBCC IND dump a list of all the data pages in the table into a temp table.
For all of those data pages, dump the content from the page into another temp table.
Then with some amazing CTE’s (thanks Patrick) extract all of the column data out of the binary data from the data page.
Convert the data into the right format and insert it into a copy of the table.
Compare the table to what it looked like before corruption was encountered to confirm that it looks right for all the pre-corruption records.
Build a new database and move all the the data into that new database.

This is the 10th corrupt database that I have repaired for a client this year.

Another Successful Corruption Repair

Leave a Reply Cancel reply