consistency errors | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

consistency errors

Hello, I have a beefy SQL Server box that houses several databases. It seems that I get consistency errors in these databases every few days now. I used to have no trouble at all. The errors are varied. I have never had errors in the master database, just the created databases. This box is on a nice UPS and is a Raid-5 array. It doesn’t lose power or get blue screens of death. The array consistency seems fine. I’m not sure why I’m getting this corruption. I should also mention that I’m always able to fix the errors, but I’m sure If I let them go they would get worse as time goes on. Any ideas? Thanks.
I should also mention that I’m using the PAE switch since my box has 8 gig of ram in it. I know there is a hotfix, but I’m a little scared to apply it.
What errors do you have?
Luis Martin
Moderator
SQL-Server-Performance.com One of the symptoms of an approaching nervous breakdown is the belief that one’s work is terribly important
Bertrand Russell
All postings are provided “AS IS” with no warranties for accuracy.
Here is a sample from the latest inconsistency.<br /><br /><br />Server: Msg 8951, Level 16, State 1, Line 1<br />Table error: Table ‘break1’ (ID 245575913). Missing or invalid key in index ‘IX_agency’ (ID 2) for the row:<br />Server: Msg 8955, Level 16, State 1, Line 1<br />Data row (1:1332225:74) identified by (RID = (1:1332225:74) ) has index values (agency = ‘LEADERS ‘).<br />Server: Msg 8952, Level 16, State 1, Line 1<br />Table error: Database ‘ibankcentral’, index ‘break1.IX_agency’ (ID 245575913) (index ID 2). Extra or invalid key for the keys:<br />Server: Msg 8956, Level 16, State 1, Line 1<br />Index row (1:1919959:24<img src=’/community/emoticons/emotion-11.gif’ alt=’8)’ /> with values (agency = ‘LEADER) points to the data row identified by (RID = (1:1332225:74)).
KBAhttp://support.microsoft.com/kb/284440/EN-US/ to fix the issue. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
]]>