Index Corruption in SQL 2000-Urgent

Giganews Newsgroups
Subject: Index Corruption in SQL 2000-Urgent
Posted by:  biju…@hotmail.com (bijupghotmailc…@discussions.microsoft.com)
Date: Mon, 28 Aug 2006

Dear ALL,
I am running sql 2000 (sp3 a) on a cluster (comopaq) with database located
in a raid 10 array .
it was woking properly since 2002 but recently i getting lot of index
corruption around 5 corruptions in this month and all rectified by recreating
the corrupted indexes . but it is happening again .

Additionaly i am having Tranasactional replication and logshipping
configured on this database as result of these corruption the log shipping
process failing and i am usually rebuilding the log shipping process.

The cooling in the server room is fine.and there no error looged in the
system event viewer to indicate any possible hardware issues.

Please advice about what actions i should take as my database is a very
critical OLTP database.
The error messages:
icrosoft][ODBC SQL Server Driver][SQL Server]Table error: Table
'Rpt_mktg_TRAN' (ID 196195749). Missing or invalid key in index
'card_no_rpt_mktg_tran' (ID 9) for the row:
[Microsoft][ODBC SQL Server Driver][SQL Server]Data row (1:59680:54)
identified by (RID = (1:59680:54) tran_id = 12275244) has index values
(card_no = 6141623056 and tran_id = 12275244).
[Microsoft][ODBC SQL Server Driver][SQL Server]CHECKDB found 0 allocation
errors and 1 consistency errors in table 'Rpt_mktg_TRAN' (object ID
196195749).
[Microsoft][ODBC SQL Server Driver][SQL Server]CHECKDB found 0 allocation
errors and 1 consistency errors in database 'Revenues'.
[Microsoft][ODBC SQL Server Driver][SQL Server]repair_fast is the minimum
repair level for the errors found by DBCC CHECKDB (Revenues ).
Rgds
Biju

Replies