At Stedman Solutions, LLC, we recently had the opportunity to help out another client with a corrupt database, to completely recover all their data and remove all the corruption. In this specific scenario Microsoft had told them that their only options was to restore from a backup, but because the corruption had been there for a while before they noticed they didn’t have any recent backups that were corruption free.
In this specific scenario there were 51 tables with corruption, and some other corruption that was in the data file, but not associated with any tables or objects.
Here is how the process went:
Phase 1 – Experimentation and discovery. Learning where the issues were and what options we had for repair. Documenting the status of each table.
Phase 2 – Eliminating corruption in the objects that would not cause data loss. For instance, dropping and re-creating non clustered indexes.
Phase 3 – Detailed investigation into each remaining table, determining what could be recovered directly, and what would be missing and would need to be recovered another way. Then determining for each of those tables how to replace the missing rows.
Phase 4 – Find all the missing data and replace it.
Phase 5 – Removing the corruption in the data file not associated with any object. This phase took approximately 50% of time of the entire repair process.
Phase 6 – Verification, confirming that the database is corruption free, and that there is no data missing, and that the database is reliable and sound.
Phase 7 – Verification that all applications work in the database as they did prior to the corruption. This phase is performed by the client as they know their application far better than we do.
In this example the entire repair process was completed just under 48 hours from when an agreement was signed and payment was made. For most of the corrupt databases that we have repaired we have been able to complete the repair process in 48 hours or less. Only a few times has it gone beyond 48 hours.
Every corruption repair is different depending on what is corrupt and how bad the corruption is, and how long that corruption had been there, and what backups are available to use in the recovery process. My hope is that nobody ever encounters a corrupt database, but if you do, give us a call or fill out the contact us form, at Stedman Solutions we can help.
- Stedman Solutions – Corruption Repair
- Database Corruption Challenge
More from Stedman Solutions:
Steve and the team at Stedman Solutions are here for all your SQL Server needs.
Contact us today for your free 30 minute consultation..
We are ready to help!