August 3, 2012 at 3:58 pm
Thank you to all who are willing to help.
I was running DBCC CheckDB on one of my databases and got this in the results:
Msg 2511, Level 16, State 2, Line 1
Table error: Object ID 436964683, index ID 1, partition ID 72057606754271232, alloc unit ID 72057616624517120 (type In-row data). Keys out of order on page (213:1248520), slots 35 and 36.
There are 344227425 rows in 3615883 pages for object "theSchema.theTable".
CHECKDB found 0 allocation errors and 1 consistency errors in table 'theSchema.theTable' (object ID 436964683).
Running DBCC PAGE spits out the data and those slots look good (with the exception that I cannot read the contents of the LOB, which is a varbinary(MAX) - developers, not my decision).
Regardless, rebuilding the specific partition in question did not fix the problem, it just changed the partition ID and moved the slots (as you would expect).
Any help on next steps would be greatly appreciated.
August 3, 2012 at 4:05 pm
Do you have backups sufficent to perform a page-only restore? You'll need a full and log backups.
August 3, 2012 at 4:08 pm
Robert Davis (8/3/2012)
Do you have backups sufficent to perform a page-only restore? You'll need a full and log backups.
Yes, I have sufficient backups, IF the corruption happened within a proper time-frame (which I would have to say that it did, because I know this database had a clean bill of health 2 weeks ago).
August 3, 2012 at 4:11 pm
If you can do it, that's the option I would go with.
Of that won't work, there's full restore or run checkdb with repair (last option) and reinsert lost data.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply