DBCC CHECKTABLE ERROR !!!

  • HI,

    I received an error message as below, when running the "dbcc checktable ( repair)"

    Result :

    Server: Msg 8951, Level 16, State 1, Line 1

    Table error: Table 'Repair' (ID 1586104691). Missing or invalid key in index 'PK_Repair' (ID 2) for the row:

    Server: Msg 8955, Level 16, State 1, Line 1

    Data row (1:1704:102) identified by (RID = (1:1704:102) ) has index values (ID = 199).

    DBCC results for 'Repair'.

    There are 154 rows in 7 pages for object 'Repair'.

    CHECKTABLE found 0 allocation errors and 1 consistency errors in table 'Repair' (object ID 1586104691).

    repair_fast is the minimum repair level for the errors found by DBCC CHECKTABLE (NV.dbo.Repair ).

    I try to repair the table by using

    DBCC checktable (repair , REPAIR_ALLOW_DATA_LOSS ) but doesn't work! Someone please advise!

    Thank in advance!

  • Did you try rebuild the indexes on the table? I had something "similar" here and that did the trick.

    Terry


    Terry

  • we had a similar error. We somehow had a duplicate row in the table. we had to remove the duplicate and then the DBCC ran clean.

    HTH

    Paul

  • This seems to be an index problem. Rebuild the index.

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

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