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, see the FAQ.
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.