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