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...
>
>
Showing posts with label mentioned. Show all posts
Showing posts with label mentioned. Show all posts
Friday, February 17, 2012
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 ...
> >
>
>
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 ...
> >
>
>
Tuesday, February 14, 2012
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_NAM
E
= '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...
>
>
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_NAM
E
= '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...
>
>
Subscribe to:
Posts (Atom)