DBCC CHECKDB Concistency error

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

Data Corruption Issues

DBCC CHECKDB Concistency error

Author

Topic

SergeAube
Starting Member

1 Post

Posted - 2005-12-12 : 09:49:56

When running DBCC CHECKDB with Repair_Rebuild option in sigle use mode I get 16 consistency error. the error message is always on object ID 2. Can someone tell what is Object ID 2 and what can be done to re-reference what is not referenced? The log follow!

Thanks!

Msg 8964, Sev 16: Table error: Object ID 2. The text, ntext, or image node at page (1:2027787), slot 8, text ID 37039898624 is not referenced. [SQLSTATE 42000]
Msg 8964, Sev 16: Table error: Object ID 2. The text, ntext, or image node at page (1:2027787), slot 10, text ID 37039964160 is not referenced. [SQLSTATE 42000]
Msg 8964, Sev 16: Table error: Object ID 2. The text, ntext, or image node at page (1:2027787), slot 12, text ID 37040029696 is not referenced. [SQLSTATE 42000]
Msg 8964, Sev 16: Table error: Object ID 2. The text, ntext, or image node at page (1:2027787), slot 13, text ID 37040095232 is not referenced. [SQLSTATE 42000]
Msg 8964, Sev 16: Table error: Object ID 2. The text, ntext, or image node at page (1:4142208), slot 6, text ID 35910909952 is not referenced. [SQLSTATE 42000]
Msg 2536, Sev 16: DBCC results for 'Datawarehouse'. [SQLSTATE 01000]
Msg 2536, Sev 16: DBCC results for 'sysobjects'. [SQLSTATE 01000]
Msg 2593, Sev 16: There are 1377 rows in 30 pages for object 'sysobjects'. [SQLSTATE 01000]
Msg 2536, Sev 16: DBCC results for 'sysindexes'. [SQLSTATE 01000]
Msg 8923, Sev 16: The repair level on the DBCC statement caused this repair to be bypassed. [SQLSTATE 01000]
Msg 8923, Sev 16: The repair level on the DBCC statement caused this repair to be bypassed. [SQLSTATE 01000]
Msg 8923, Sev 16: The repair level on the DBCC statement caused this repair to be bypassed. [SQLSTATE 01000]
Msg 8923, Sev 16: The repair level on the DBCC statement caused this repair to be bypassed. [SQLSTATE 01000]
Msg 8964, Sev 16: Table error: Object ID 2. The text, ntext, or image node at page (1:4142208), slot 8, text ID 35910975488 is not referenced. [SQLSTATE 42000]
Msg 8964, Sev 16: Table error: Object ID 2. The text, ntext, or image node at page (1:4142208), slot 10, text ID 35911041024 is not referenced. [SQLSTATE 42000]
Msg 8964, Sev 16: Table error: Object ID 2. The text, ntext, or image node at page (1:4142208), slot 11, text ID 35911106560 is not referenced. [SQLSTATE 42000]
Msg 8964, Sev 16: Table error: Object ID 2. The text, ntext, or image node at page (1:4142208), slot 12, text ID 35911172096 is not referenced. [SQLSTATE 42000]
Msg 8964, Sev 16: Table error: Object ID 2. The text, ntext, or image node at page (1:4142208), slot 14, text ID 35911237632 is not referenced. [SQLSTATE 42000]
Msg 8964, Sev 16: Table error: Object ID 2. The text, ntext, or image node at page (1:7691690), slot 1, text ID 37040160768 is not referenced. [SQLSTATE 42000]
Msg 8964, Sev 16: Table error: Object ID 2. The text, ntext, or image node at page (1:7691690), slot 3, text ID 37040226304 is not referenced. [SQLSTATE 42000]
Msg 8964, Sev 16: Table error: Object ID 2. The text, ntext, or image node at page (1:7691691), slot 1, text ID 37040291840 is not referenced. [SQLSTATE 42000]
Msg 8923, Sev 16: The repair level on the DBCC statement caused this repair to be bypassed. [SQLSTATE 01000]
Msg 8923, Sev 16: The repair level on the DBCC statement caused this repair to be bypassed. [SQLSTATE 01000]
Msg 8923, Sev 16: The repair level on the DBCC statement caused this repair to be bypassed. [SQLSTATE 01000]
Msg 8923, Sev 16: The repair level on the DBCC statement caused this repair to be bypassed. [SQLSTATE 01000]
Msg 8923, Sev 16: The repair level on the DBCC statement caused this repair to be bypassed. [SQLSTATE 01000]
Msg 8923, Sev 16: The repair level on the DBCC statement caused this repair to be bypassed. [SQLSTATE 01000]
Msg 8923, Sev 16: The repair level on the DBCC statement caused this repair to be bypassed. [SQLSTATE 01000]
Msg 8923, Sev 16: The repair level on the DBCC statement caused this repair to be bypassed. [SQLSTATE 01000]
Msg 8923, Sev 16: The repair level on the DBCC statement caused this repair to be bypassed. [SQLSTATE 01000]
Msg 8964, Sev 16: Table error: Object ID 2. The text, ntext, or image node at page (1:7691691), slot 2, text ID 37040357376 is not referenced. [SQLSTATE 42000]
Msg 8964, Sev 16: Table error: Object ID 2. The text, ntext, or image node at page (1:7699783), slot 1, text ID 35911303168 is not referenced. [SQLSTATE 42000]
Msg 8964, Sev 16: Table error: Object ID 2. The text, ntext, or image node at page (1:7792736), slot 2, text ID 35911368704 is not referenced. [SQLSTATE 42000]
Msg 8923, Sev 16: The repair level on the DBCC statement caused this repair to be bypassed. [SQLSTATE 01000]
Msg 8923, Sev 16: The repair level on the DBCC statement caused this repair to be bypassed. [SQLSTATE 01000]
Msg 8923, Sev 16: The repair level on the DBCC statement caused this repair to be bypassed. [SQLSTATE 01000]
Msg 2593, Sev 16: There are 3487 rows in 218 pages for object 'sysindexes'. [SQLSTATE 01000]
Msg 8990, Sev 16: CHECKDB found 0 allocation errors and 16 consistency errors in table 'sysindexes' (object ID 2). [SQLSTATE 01000]

paulrandal
Yak with Vast SQL Skills

899 Posts

Posted - 2005-12-12 : 18:56:09

Why did you run repair? I'm guessing you had a bunch of other errors you were fixing (maybe 2576s)?

What SP are you on? Looks like you could have hit the bug described in this KB article http://support.microsoft.com/kb/816084 and need the hotfix or SP4.

Regards

Paul Randal
Lead Program Manager, Microsoft SQL Server Storage Engine
(Legalese: This posting is provided "AS IS" with no warranties, and confers no rights.)

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources