DBCC CHECKDB error

Hi all,
One of my SQL 2000 backups failed with the below error from DBCC CHECKDB. I
can't seem to find the rows mentioned in the error nor do I know how to
search on RID. Can anyone tell me how to get this issue resolved? Would a
rebuild of the 2 indexes be an option? I can do a manual backup, it only
fails in the maint plan.
Any help on this would be greatly appreciated.
Thanks,
Joe
Error:
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'AUDIT_LOG' (ID 190883997). Missing or invalid key in
index 'IX_AUDIT_LOG_1' (ID 3) for the row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:239820:19) identified by (RID = (1:239820:19) BATCH_ID = '0x18b93662f8073047a8319dd37d99b2790000' and TABLE_NAME = 'EV_LOG_DISP' and
COLUMN_NAME = NULL) has index values (DT = Nov 12 2005 10:24AM and TABLE_NAME
= 'EV_LOG_DISP' and KEY1 = and BATCH_ID = '0x18b93662f8073047a8319dd37d99b2790000' and TABLE_NAME = 'EV_LOG_DISP' and
COLUMN_NAME = NULL).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'AUDIT_LOG' (ID 190883997). Missing or invalid key in
index 'IX_AUDIT_LOG_2' (ID 4) for the row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:239820:19) identified by (RID = (1:239820:19) BATCH_ID = '0x18b93662f8073047a8319dd37d99b2790000' and TABLE_NAME = 'EV_LOG_DISP' and
COLUMN_NAME = NULL) has index values (USERID = 'Administrator' and DT = Nov
12 2005 10:24AM and BATCH_ID = '0x18b93662f8073047a8319dd37d99b2790000' and
BATCH_ID = '0x18b93662f8073047a8319dd37d99b2790000' and TABLE_NAME = 'EV_LOG_DISP' and COLUMN_NAME ...That looks like a nonclustered index so I would try rebuilding the indexes
for that table.
--
Andrew J. Kelly SQL MVP
"jaylou" <jaylou@.discussions.microsoft.com> wrote in message
news:DEF08F31-0B75-4F11-94A3-F8CEE69B672E@.microsoft.com...
> Hi all,
> One of my SQL 2000 backups failed with the below error from DBCC CHECKDB.
> I
> can't seem to find the rows mentioned in the error nor do I know how to
> search on RID. Can anyone tell me how to get this issue resolved? Would
> a
> rebuild of the 2 indexes be an option? I can do a manual backup, it only
> fails in the maint plan.
> Any help on this would be greatly appreciated.
> Thanks,
> Joe
> Error:
> Server: Msg 8951, Level 16, State 1, Line 1
> Table error: Table 'AUDIT_LOG' (ID 190883997). Missing or invalid key in
> index 'IX_AUDIT_LOG_1' (ID 3) for the row:
> Server: Msg 8955, Level 16, State 1, Line 1
> Data row (1:239820:19) identified by (RID = (1:239820:19) BATCH_ID => '0x18b93662f8073047a8319dd37d99b2790000' and TABLE_NAME = 'EV_LOG_DISP'
> and
> COLUMN_NAME = NULL) has index values (DT = Nov 12 2005 10:24AM and
> TABLE_NAME
> = 'EV_LOG_DISP' and KEY1 = and BATCH_ID => '0x18b93662f8073047a8319dd37d99b2790000' and TABLE_NAME = 'EV_LOG_DISP'
> and
> COLUMN_NAME = NULL).
> Server: Msg 8951, Level 16, State 1, Line 1
> Table error: Table 'AUDIT_LOG' (ID 190883997). Missing or invalid key in
> index 'IX_AUDIT_LOG_2' (ID 4) for the row:
> Server: Msg 8955, Level 16, State 1, Line 1
> Data row (1:239820:19) identified by (RID = (1:239820:19) BATCH_ID => '0x18b93662f8073047a8319dd37d99b2790000' and TABLE_NAME = 'EV_LOG_DISP'
> and
> COLUMN_NAME = NULL) has index values (USERID = 'Administrator' and DT => Nov
> 12 2005 10:24AM and BATCH_ID = '0x18b93662f8073047a8319dd37d99b2790000'
> and
> BATCH_ID = '0x18b93662f8073047a8319dd37d99b2790000' and TABLE_NAME => 'EV_LOG_DISP' and COLUMN_NAME ...
>|||Thank you for the response, I rebuilt the indexes and all is well.
"Andrew J. Kelly" wrote:
> That looks like a nonclustered index so I would try rebuilding the indexes
> for that table.
> --
> Andrew J. Kelly SQL MVP
> "jaylou" <jaylou@.discussions.microsoft.com> wrote in message
> news:DEF08F31-0B75-4F11-94A3-F8CEE69B672E@.microsoft.com...
> > Hi all,
> > One of my SQL 2000 backups failed with the below error from DBCC CHECKDB.
> > I
> > can't seem to find the rows mentioned in the error nor do I know how to
> > search on RID. Can anyone tell me how to get this issue resolved? Would
> > a
> > rebuild of the 2 indexes be an option? I can do a manual backup, it only
> > fails in the maint plan.
> >
> > Any help on this would be greatly appreciated.
> >
> > Thanks,
> > Joe
> >
> > Error:
> > Server: Msg 8951, Level 16, State 1, Line 1
> > Table error: Table 'AUDIT_LOG' (ID 190883997). Missing or invalid key in
> > index 'IX_AUDIT_LOG_1' (ID 3) for the row:
> > Server: Msg 8955, Level 16, State 1, Line 1
> > Data row (1:239820:19) identified by (RID = (1:239820:19) BATCH_ID => > '0x18b93662f8073047a8319dd37d99b2790000' and TABLE_NAME = 'EV_LOG_DISP'
> > and
> > COLUMN_NAME = NULL) has index values (DT = Nov 12 2005 10:24AM and
> > TABLE_NAME
> > = 'EV_LOG_DISP' and KEY1 = and BATCH_ID => > '0x18b93662f8073047a8319dd37d99b2790000' and TABLE_NAME = 'EV_LOG_DISP'
> > and
> > COLUMN_NAME = NULL).
> > Server: Msg 8951, Level 16, State 1, Line 1
> > Table error: Table 'AUDIT_LOG' (ID 190883997). Missing or invalid key in
> > index 'IX_AUDIT_LOG_2' (ID 4) for the row:
> > Server: Msg 8955, Level 16, State 1, Line 1
> > Data row (1:239820:19) identified by (RID = (1:239820:19) BATCH_ID => > '0x18b93662f8073047a8319dd37d99b2790000' and TABLE_NAME = 'EV_LOG_DISP'
> > and
> > COLUMN_NAME = NULL) has index values (USERID = 'Administrator' and DT => > Nov
> > 12 2005 10:24AM and BATCH_ID = '0x18b93662f8073047a8319dd37d99b2790000'
> > and
> > BATCH_ID = '0x18b93662f8073047a8319dd37d99b2790000' and TABLE_NAME => > 'EV_LOG_DISP' and COLUMN_NAME ...
> >
>
>