|
oliviermoron
Starting Member
7 Posts |
 Posted - 05/10/2006 : 07:29:24
|
Dear all,
I have several SQL Server 8.0 SP4 in different locations (12 sites).
And on two specific machines I have got very often problems on indexes.
I'm obliged each time to do a DBCC DBREINDEX on the broken indexes.
These problems appeared last year around October, and are random.
Have you got any idea on how I can solve these in order to prevent them?
Here is a sample of what I got:
Server: Msg 8952, Level 16, State 1, Line 1
quote:
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'PROPLAST2000_PRESSES', index 'EVENEMENT.IX_PO_ID' (ID 421576540) (index ID 2). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:2369983:37) with values (PO_ID = 38809 and DATE_DEBUT_EVENEMENT = Apr 22 2006 10:08AM) points to the data row identified by (RID = (1:2369604:5)).
Regards,
Olivier Moron.
|
|
|
oliviermoron
Starting Member
7 Posts |
Posted - 05/10/2006 : 07:48:02
|
No, I haven't tried the drop and create index rather than rebuild, due to:
* the fact that the rebuild works well
* I'm looking for a fix to prevent corruption of the indexes.
* the server is used on a production plant without any possibility to stop it without sttoping the production itself.
Yes, I have done the dbcc checkdb.
Regards,
Olivier Moron |
 |
|
Corruputed indexes
