November 9, 2003 at 3:41 am
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!
November 11, 2003 at 11:10 am
Did you try rebuild the indexes on the table? I had something "similar" here and that did the trick.
Terry
Terry
November 12, 2003 at 2:32 am
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
November 12, 2003 at 5:25 am
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