Msg 8964, Leve 16, Line 1
-
There,
I got a the following message at My SQL 2000 server with Sp3. I rearch the Microsoft web site and found the following URL information http://support.microsoft.com/kb/281287/EN-US/. I do not know this is a bug or my table is real corrupted. Some body can help??
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 405628538. The text, ntext, or image node at page (1:1001056), slot 10, text ID 1595707686912 is not referenced.
DBCC results for 'audit_record'.
There are 1958345 rows in 42549 pages for object 'audit_record'.
CHECKTABLE found 0 allocation errors and 1 consistency errors in table 'audit_record' (object ID 405628538).
repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKTABLE (PowerPath_NYU.dbo.audit_record ).
Thanks,
KT
-
Have you checked if your situation fulfills everything that the kb speaks about? If you suspect that it may be that bug, seems like the only way to verify that for sure is to apply the fix mentioned in the kb.
If that is not the case, then corruption like the message says, is likely.
In any case, I can only guess - what is sure is that DBCC thinks it has found an inconsistency. For the most parts, these situations (if proven to be irreparable) is what your backups are ment for.
What step to take next really depends on what you can do.
The options are either to apply the fix, and check again. If the error is gone, all is well, and it was the bug. or... run DBCC again with the option mentioned in the error. This will probably lead to loss of data - if that data aren't already lost. If you suspect this, then you probably need to restore to the last known good backup anyway, in order to get the missing data back.
/Kenneth
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply