Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

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?

share|improve this question

closed as too localized by Mark Storey-Smith, Mike Walsh, RolandoMySQLDBA, Marian, Max Vernon Mar 27 '13 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.

3  
What exactly is corrupted on your table? Is it the clustered index (or heap) or a nonclustered index? Are you able to put the DBCC CHECKDB output in your question? –  Thomas Stringer Jan 28 '13 at 15:37
3  
Paul Randal recently updated his corruption demos, you might check those scripts. Good way to test before doing in production too: sqlskills.com/blogs/paul/corruption-demo-databases-and-scripts –  Shawn Melton Jan 28 '13 at 17:12

1 Answer 1

up vote 0 down vote accepted

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.

share|improve this answer

protected by Mark Storey-Smith Sep 20 '13 at 14:41

Thank you for your interest in this question. Because it has attracted low-quality answers, posting an answer now requires 10 reputation on this site.

Would you like to answer one of these unanswered questions instead?

Not the answer you're looking for? Browse other questions tagged or ask your own question.