SQL Error 644

[andreis]

Hello, All:
Our SQL Server 7 - based application started to receive Error 644 (Could not find the index entry for RID '%.*hs' in index page %S_PGID, index ID %d, database '%.*ls'. This error occurs when the nonclustered index indicated by the index ID is corrupt. The corruption is detected when a process tries to delete a nonexistent row) in different locations. DBCC checkdb with repair_rebuils fixes the problem, but the frequency of the error is suspicious.

What may to contribute to the index corruption?

Any hint would be greatly appreciated.

Thanks.

Andrei

 

[fluteplr]

Have you tried deleting and recreating the index?

 

[fluteplr]

I would also check your NT error logs both the system and application ones looking for any disk io or other related errors.

 

[andreis]

fluteplr, thanks

Yes, index recreating fixes the problem, we are just worried why does it happen so often? Is it a kinda 'usual' SQL error, should running dbcc checkdb on a daily basis help? And thanks for NT log hint, although it looks like nothing wrong is in there...
Andrei