Hello all,I have run DBCC CHECKDB to check a consistency error that I keep getting which can randomly stop my website from working, and I get the following errors amongst the results...DBCC results for 'tbl_final_CountData'.Server: Msg 8951, Level 16, State 1, Line 1Table error: Table 'tbl_final_CountData' (ID 98099390). Missing or invalid key in index 'IX_tbl_final_CountData_CountID' (ID 2) for the row:Server: Msg 8955, Level 16, State 1, Line 1Data row (1:81990:2) identified by (RID = (1:81990:2) UID = 145373C8-9992-487E-AD4A-021204BDFBEC) has index values (CountID = 'FB60E631-CB09-42DE-9464-5AD26368C0F5' and UID = 145373C8-9992-487E-AD4A-021204BDFBEC).Server: Msg 8952, Level 16, State 1, Line 1Table error: Database 'dft-traffic-v1', index 'tbl_final_CountData.IX_tbl_final_CountData_CountID' (ID 98099390) (index ID 2). Extra or invalid key for the keys:Server: Msg 8956, Level 16, State 1, Line 1Index row (1:152794:73) with values (CountID = 'FB60E631-BB09-42DE-9464-5AD26368C0F5' and UID = 145373C8-9992-487E-AD4A-021204BDFBEC) points to the data row identified by ().Server: Msg 8952, Level 16, State 1, Line 1Table error: Database 'dft-traffic-v1', index 'tbl_final_CountData.IX_tbl_final_CountData_CPID' (ID 98099390) (index ID 3). Extra or invalid key for the keys:Server: Msg 8956, Level 16, State 1, Line 1Index row (1:162228:10) with values (CPID = '6BC94087-4923-48CE-A45D-A7CBEA75A1FC' and UID = AA55F4B4-7AD5-4035-8BCD-E401824DDEB1) points to the data row identified by ().There are 1699823 rows in 50187 pages for object 'tbl_final_CountData'.CHECKDB found 0 allocation errors and 3 consistency errors in table 'tbl_final_CountData' (object ID 98099390).
I am guessing that I have a problem with my index not matching the data.I am not a DBA so this is a bit over my head (am a lowly web app dev!).My questions are...1) How can I fix this?2) What could cause it?3) What can I do to stop it happening?Thanks very much for any hints!!AJ
Possible Index/Consistency Issue
Posted - 2007-11-12 : 11:10:47
