question

sean876 avatar image
sean876 asked

DBCC "not referenced" table error

Greetings, I get the following error when I run "DBCC checkdb with no_infomsgs" against my database: Msg 8964, Level 16, State 1, Line 1 Table error: Object ID 85575343. The text, ntext, or image node at page (1:869), slot 34, text ID 2778726400 is not referenced. Msg 8964, Level 16, State 1, Line 1 Table error: Object ID 85575343. The text, ntext, or image node at page (1:869), slot 36, text ID 2779250688 is not referenced. CHECKDB found 0 allocation errors and 2 consistency errors in table 'EventLog' (object ID 85575343). CHECKDB found 0 allocation errors and 2 consistency errors in database '<[dbname]>'. repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKDB (<[dbname]>). Any ideas?
sql-server-2000error-messagedbccreference
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
KenJ avatar image
KenJ answered
Take a backup. Restore from a good backup if you can't lose data, or run `DBCC CHECKDB('<[DBNAME]>', REPAIR_ALLOW_DATA_LOSS)` if the loss is okay. [DBCC in Books Online][1] [1]: http://msdn.microsoft.com/en-us/library/aa258278(v=sql.80).aspx
1 comment
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

sean876 avatar image sean876 commented ·
Thanks much KenJ. Will try this.
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.