I have a problem with an 2K5 (v9.0.3042) database. For about 3 tables, several nonclustered indexes are getting corrupt every week. I droppped and recreated these indexes, did a DBCC CHECKDB and everything was ok, but the problem re-appears after several days. Tables and indexes which are giving problems are always the same. The only thing I see is that autoshrink is enabled (low diskspace)
Any help would be appreciated!
asked Mar 17, 2010 at 07:22 AM in Default
In SQL-2000,for a self updated query which is updating huge number of records we may find that non-clustured indexes is corrupted.In this case B-tree structure for the non-clustured indexes also corrupts.You may notice database corruption sometimes.Applying latest service packs on OS and SQL is one option to recover.second restore NCI back from the backup sets.May i know which DBCC command you ran?
answered Mar 17, 2010 at 08:01 AM
Grants suggestion of getting Paul in is a good suggestion.. Also search through his blog as he pretty my mind dumps all his knowledge on DBCC to there.
What DBCC CHECKDB command are you running?
In some cases it it possible that the file system is at fault. I would do the necessary check on the disks themselves too.
answered Mar 17, 2010 at 07:44 AM
That's a very abnormal situation. Are you sure you're on the latest service packs on your OS and on SQL Server? Are you getting errors prior to, or in conjunction with the corruption?
Honestly, something like this, I'd call in the Marines, or Paul Randal.
answered Mar 17, 2010 at 07:30 AM
Grant Fritchey ♦♦