I have a SQL Server database with some corrupted data unrepairable via DBCC CHECKDB in a table. I can get many of the rows before the corruption out - but how do I get the rows after the corruption out?
closed as too localized by Mark Storey-Smith, Mike Walsh, RolandoMySQLDBA, Marian, Max Vernon Mar 27 at 21:23
This question is unlikely to help any future visitors; it is only relevant to a small geographic area, a specific moment in time, or an extraordinarily narrow situation that is not generally applicable to the worldwide audience of the internet. For help making this question more broadly applicable, visit the help center.If this question can be reworded to fit the rules in the help center, please edit the question.
In the end, I truncated the table as the data wasn't essential and this cleared out the corruption. I know this won't be a solution for most folks - usually you need the data.
protected by Mark Storey-Smith Sep 20 at 14:41
This question is protected to prevent "thanks!", "me too!", or spam answers by new users. To answer it, you must have earned at least 10 reputation on this site.