Tell me more ×
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.
up vote 3 down vote favorite
2

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
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 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 at 17:12

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.

1 Answer

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

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