> 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
>

> 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
>

"Michael Hotek" wrote:

> You need to take a hard look at the disk controllers. This is the most
> frequent as well as most likely cause of your recurring corruption issues.
>
> --
> Mike Hotek
> MHS Enterprises, Inc
> http://www.mssqlserver.com
>
>
> "bijupg@hotmail.com" <bijupghotmailcom@discussions.microsoft.com> wrote in
> message news:D10A9BE2-6D5A-459C-BA0D-FCF172156E15@microsoft.com...
> > 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
> >
>
>