DBCC REPAIR ALLOW DATA LOSS

The REPAIR_ALLOW_DATA_LOSS option for DBCC CHECKDB and DBCC CHECKTABLE can be one of the most misleading and possibly catastrophic options.

What the REPAIR_ALLOW_DATA_LOSS option does for DBCC CHECKDB and DBCC CHECKTABLE is to simply just throw away any pages (8k blocks of data) that contain rows. This may mean it is throwing away a couple of rows, or dozens to hundreds of rows when REPAIR_ALLOW_DATA_LOSS is being used.

Recommendation, contact us first so we can help recover your data without throwing it away.

At Stedman Solutions, LLC we can help repair your corrupt database.

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!