Beware – REPAIR_ALLOW_DATA_LOSS Vs REPAIR_REBUILD
So, you have discovered CheckDB is reporting errors on your SQL Server database or on a table in your database.
What do you do?
REPAIR_ALLOW_DATA_LOSS seems like and quick and easy fix right? But do you actually know what you’re doing?
Well, if you read the error messages you might see that repair_allow_data_loss is the minimum repair level for the errors found.
BEWARE!
This doesn’t mean it will fix your data. It just means it will throw away any pages with corruption on them.
If you were to run checkdb or check table with repair_allow_data_loss the SQL Server lies to you. It tells you “The error has been repaired”. With a statement like that I’d assume the corruption was repaired. But that’s not the case. The repair in this case means that SQL Server threw away the page with the corruption on it. It didn’t repair anything it just threw out the data. Don’t make the mistake many others have! Or contact us before you run it.
More details here: https://stedmansolutions.com/2020/06/09/repair_allow_data_loss-example/
Contact us before running repair_allow_data_loss!
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!
Leave a Reply