DBCC CHECKDB Failed - SQL Server Forums

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 Failed

Author

Topic

AFTIadmin
Starting Member

22 Posts

Posted - 2010-01-12 : 18:43:32

One of my databases has integrity issues. I'm running CHECKDB through a maintenance plan and it is producing the following error:

Executing the query "DBCC CHECKDB(N'MYDB1') WITH NO_INFOMSGS
" failed with the following error: "Table error: table 'MYTABLE1' (ID 430624577). Data row does not have a matching index row in the index 'IDX_MYTABLE1_2' (ID 22). Possible missing or invalid keys for the index row matching:
Data row (1:738450:15) identified by (ResultID = 88754384) with index values 'DateMeasurement = '2009-12-09 01:00:00.000' and VisibleFlag = 1 and Copied = 1 and ResultEventID = 4139317 and ResultID = 88754384'.
Table error: table 'MYTABLE1' (ID 430624577). Data row does not have a matching index row in the index 'IDX_MYTABLE1_2' (ID 22). Possible missing or invalid keys for the index row matching:
Data row (1:738450:16) identified by (ResultID = 88754385) with index values 'DateMeasurement = '2009-12-09 00:00:00.000' and VisibleFlag = 1 and Copied = 1 and ResultEventID = 4139317 and ResultID = 88754385'.
Table error: table 'MYTABLE1' (ID 430624577). Data row does not have a matching index row in the index 'IDX_MYTABLE1_2' (ID 22). Possible missing or invalid keys for the index row matching:
Data row (1:738450:17) identified by (ResultID = 88754386) with index values 'DateMeasurement = '2009-12-08 23:00:00.000' and VisibleFlag = 1 and Copied = 1 and ResultEventID = 4139317 and ResultID = 88754386'.
Table error: table 'MYTABLE1' (ID 430624577). Data row does not have a matching index row in the index 'IDX_MYTABLE1_2' (ID 22). Possible missing or invalid keys for the index row matching:
Data row (1:738450:18) identified by (ResultID = 88754387) with index values 'DateMeasurement = '2009-12-08 22:00:00.000' and VisibleFlag = 1 and Copied = 1 and ResultEventID = 4139317 and ResultID = 88754387'.
Table error: table 'MYTABLE1' (ID 430624577). Data row does not have a matching index row in the index 'IDX_MYTABLE1_2' (ID 22). Possible missing or invalid keys for the index row matching:
Data row (1:738450:19) identified by (ResultID = 88754388) with index values 'DateMeasurement = '2009-12-08 21:00:00.000' and VisibleFlag = 1 and Copied = 1 and ResultEventID = 4139317 and ResultID = 88754388'.
Table error: table 'MYTABLE1' (ID 430624577). Data row does not have a matching index row in the index 'IDX_MYTABLE1_2' (ID 22). Possible missing or invalid keys for the index row matching:
Data row (1:738450:20) identified by (ResultID = 88754389) with index values 'DateMeasurement = '2009-12-08 20:00:00.000' and VisibleFlag = 1 and Copied = 1 and ResultEventID = 4139317 and ResultID = 88754389'.
Table error: table 'MYTABLE1' (ID 430624577). Data row does not have a matching index row in the index 'IDX_MYTABLE1_2' (ID 22). Possible missing or invalid keys for the index row matching:
Data row (1:738450:21) identified by (ResultID = 88754390) with index values 'DateMeasurement = '2009-12-08 19:00:00.000' and VisibleFlag = 1 and Copied = 1 and ResultEventID = 4139317 and ResultID = 88754390'.
Table error: table 'MYTABLE1' (ID 430624577). Data row does not have
a matching index row in the index 'IDX_MYTABLE1_2' (ID 22). Possible missing or invalid keys for the index row matching:
Data row (1:738450:22) identified by (ResultID = 88754391) with index values 'DateMeasurement = '2009-12-08 18:00:00.000' and VisibleFlag = 1 and Copied = 1 and ResultEventID = 4139317 and ResultID = 88754391'.
Table error: table 'MYTABLE1' (ID 430624577). Data row does not have a matching index row in the index 'IDX_MYTABLE1_2' (ID 22). Possible missing or invalid keys for the index row matching:
Data row (1:738450:23) identified by (ResultID = 88754392) with index values 'DateMeasurement = '2009-12-08 17:00:00.000' and VisibleFlag = 1 and Copied = 1 and ResultEventID = 4139317 and ResultID = 88754392'.
Table error: table 'MYTABLE1' (ID 430624577). Data row does not have a matching index row in the index 'IDX_MYTABLE1_2' (ID 22). Possible missing or invalid keys for the index row matching:
Data row (1:738450:24) identified by (ResultID = 88754393) with index values 'DateMeasurement = '2009-12-08 16:00:00.000' and VisibleFlag = 1 and Copied = 1 and ResultEventID = 4139317 and ResultID = 88754393'.
Table error: table 'MYTABLE1' (ID 430624577). Data row does not have a matching index row in the index 'IDX_MYTABLE1_2' (ID 22). Possible missing or invalid keys for the index row matching:
Data row (1:738450:25) identified by (ResultID = 88754394) with index values 'DateMeasurement = '2009-12-08 15:00:00.000' and VisibleFlag = 1 and Copied = 1 and ResultEventID = 4139317 and ResultID = 88754394'.
Table error: table 'MYTABLE1' (ID 430624577). Data row does not have a matching index row in the index 'IDX_MYTABLE1_2' (ID 22). Possible missing or invalid keys for the index row matching:
Data row (1:738450:33) identified by (ResultID = 88754402) with index values 'DateMeasurement = '2009-12-09 02:00:00.000' and VisibleFlag = 1 and Copied = 1 and ResultEventID = 4139317 and ResultID = 88754402'.
Table error: table 'MYTABLE1' (ID 430624577). Data row does not have a matching index row in the index 'IDX_MYTABLE1_2' (ID 22). Possible missing or invalid keys for the index row matching:
Data row (1:738450:90) identified by (ResultID = 88754459) with index values 'DateMeasurement = '2009-12-09 03:00:00.000' and VisibleFlag = 1 and Copied = 1 and ResultEventID = 4139320 and ResultID = 88754459'.
CHECKDB found 0 allocation errors and 13 consistency errors in table 'MYTABLE1' (object ID 430624577).
CHECKDB found 0 allocation errors and 13 consistency errors in database 'MYDB1'.
repair_rebuild is the minimum repair level for the errors found by DBCC CHECKDB (MYDB1).". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.

Urgently need ideas on what I do to fix it!

Thanks

AFTIadmin
Starting Member

22 Posts

Posted - 2010-01-12 : 18:53:16

Mods, please move this to "Data Corruption Issues" section

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2010-01-13 : 02:23:14

See my reply at SQLServerCentral (http://www.sqlservercentral.com/Forums/Topic846620-1550-1.aspx). Damage to a single nonclustered index, drop it and recreate it.

--
Gail Shaw
SQL Server MVP

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-01-13 : 12:32:13

quote:
Originally posted by AFTIadmin

Mods, please move this to "Data Corruption Issues" section

Your wish is my command.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

"Let's begin with the premise that everything you've done up until this point is wrong."

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources