Consistency Errors in Table

Question

Consistency Errors in Table

MostInterestingMan

SSCertifiable

Points: 6291
More actions
February 19, 2010 at 8:22 am

#216996

Hi,
I ran into consistency errors in one of my databases that needs to be resolve. I do not have a backup therefore I'm in a corner. Please find below DBCC CHECKDB results.
CHECKDB found 0 allocation errors and 15 consistency errors in table 'mytable' (object ID 2032882459).
CHECKDB found 0 allocation errors and 15 consistency errors in database 'mydatabase'.
repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKDB (mydatabase).
...and the results for DBCC CHECKTABLE (mytable, REPAIR_REBUILD)
Repairing this error requires other errors to be corrected first.
There are 1071522027 rows in 31180658 pages for object "mytable".
CHECKTABLE found 0 allocation errors and 15 consistency errors in table 'mytable' (object ID 2032882459).
repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKTABLE (mydatabase.dbo.mytable, repair_rebuild).
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
MCTS: BI 2008, MCITP: BI 2008
Stay Thirsty My Friends

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 1

As the checkDB output says, REPAIR_ALLOW_DATA_LOSS is the minimum level needed to repair. Hence REPAIR_REBUILD will do nothing.

Since you have no backup (why not?) you have little choice other than to run repair and accept the data loss. It looks like 3 pages are damaged, you will lose all the data on those pages. I can't tell how many rows that will be, depends on the size of the rows.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

MostInterestingMan SSCertifiable Points: 6291 More actions · Answer 2

Thanks Gail.

MCTS: BI 2008, MCITP: BI 2008
Stay Thirsty My Friends