Yesterday I posted about how repair_allow_data_loss should never be used with CHECKDB or CHECKTABLE. Today I want to share the difference between repair_rebuild vs repair_allow_data_loss.… Read More »repair_rebuild vs repair_allow_data_loss
So often I get the call from someone needing help with repairing a corrupt database, and then they tell me that they ran CHECKDB with… Read More »Do Not Run REPAIR_ALLOW_DATA_LOSS
When running DBCC CHECKDB, you will often times get screens of information back stating that the database is all okay, and that it checked every… Read More »CHECKDB WITH NO_INFOMSGS
Recently we had a new customer contact from someone with a corrupt database. They were getting corruption error #824, which usually indicates there is some… Read More »Another Successful Corrupt Database Repair
In 2015, around the time I started Stedman Solutions LLC, I created the Database Corruption Challenge as a way to share knowledge of how to… Read More »Database Corruption Challenge
When working with clients on fixing their corrupt SQL Server databases we run into some common beliefs about corruption that are not quite true, such… Read More »Confusion with Database Corruption
I received a contact message from the “Contact us” form, asking about how to go about repairing corruption in TempDB. The error message was something… Read More »Corruption in TempDB
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:
Read More »Another Successful Database Corruption RepairPlease join me on Saturday March 16 in Victoria BC Canada for my SQL Saturday presentation on the Basics of Database Corruption Repair. Here is… Read More »Basics of Database Corruption Repair
Recently Derrick and I had a chance to help with a corruption repair in Thailand, just to clarify, the client was in Thailand, not us.… Read More »Fixed Corruption in Thailand