Msg 2511

We are getting the following error on our production machine when we run
DBCC CHECKDB
Server: Msg 2511, Level 16, State 1, Line 1
Table error: Object ID 1488776411, Index ID 3. Keys out of order on page
(1:41060), slots 264 and 265.
Server: Msg 2511, Level 16, State 1, Line 1
Table error: Object ID 1488776411, Index ID 3. Keys out of order on page
(1:41085), slots 75 and 76.
Server: Msg 2511, Level 16, State 1, Line 1
Table error: Object ID 1488776411, Index ID 3. Keys out of order on page
(1:41125), slots 15 and 16.
CHECKTABLE found 0 allocation errors and 3 consistency errors in table
'INT_AUX_ACTIVITY' (object ID 1488776411).
repair_rebuild is the minimum repair level for the errors found by DBCC
CHECKTABLE (sca_master.dbo.INT_AUX_ACTIVITY ).
I searched Google and found the following article,
http://www.winnetmag.com/SQLServer/Forums/messageview.cfm?catid=1664&threadid=117814
However, my network admin tells me that he could not find anything wrong
with the server. If drop the index pointed out in the error, dbcc returns no
errors.
If add the index back, I get the errors again.
Did anybody expericence a similar issue. Any pointers would be appreciated.
Thanks.
PrasadUsing SQL 2K, SP3a, with MS03-031.
Using RAID5 for data.
RAM: 2GB
"Prasad Koukuntla" <prasad.koukuntla@.scapromo.com> wrote in message
news:ew6EAWkIEHA.3664@.TK2MSFTNGP11.phx.gbl...
> We are getting the following error on our production machine when we run
> DBCC CHECKDB
> Server: Msg 2511, Level 16, State 1, Line 1
> Table error: Object ID 1488776411, Index ID 3. Keys out of order on page
> (1:41060), slots 264 and 265.
> Server: Msg 2511, Level 16, State 1, Line 1
> Table error: Object ID 1488776411, Index ID 3. Keys out of order on page
> (1:41085), slots 75 and 76.
> Server: Msg 2511, Level 16, State 1, Line 1
> Table error: Object ID 1488776411, Index ID 3. Keys out of order on page
> (1:41125), slots 15 and 16.
> CHECKTABLE found 0 allocation errors and 3 consistency errors in table
> 'INT_AUX_ACTIVITY' (object ID 1488776411).
> repair_rebuild is the minimum repair level for the errors found by DBCC
> CHECKTABLE (sca_master.dbo.INT_AUX_ACTIVITY ).
> I searched Google and found the following article,
>
http://www.winnetmag.com/SQLServer/Forums/messageview.cfm?catid=1664&threadid=117814
> However, my network admin tells me that he could not find anything wrong
> with the server. If drop the index pointed out in the error, dbcc returns
no
> errors.
> If add the index back, I get the errors again.
> Did anybody expericence a similar issue. Any pointers would be
appreciated.
> Thanks.
> Prasad
>|||I ran dbcc checktable(int_aux_activity, REPAIR_REBUILD) with no_infomsgs
as suggested in the error. However, the errors still showed up, when I ran
the DBCC CHECKTABLE without the repair option.
"Prasad Koukuntla" <prasad.koukuntla@.scapromo.com> wrote in message
news:ew6EAWkIEHA.3664@.TK2MSFTNGP11.phx.gbl...
> We are getting the following error on our production machine when we run
> DBCC CHECKDB
> Server: Msg 2511, Level 16, State 1, Line 1
> Table error: Object ID 1488776411, Index ID 3. Keys out of order on page
> (1:41060), slots 264 and 265.
> Server: Msg 2511, Level 16, State 1, Line 1
> Table error: Object ID 1488776411, Index ID 3. Keys out of order on page
> (1:41085), slots 75 and 76.
> Server: Msg 2511, Level 16, State 1, Line 1
> Table error: Object ID 1488776411, Index ID 3. Keys out of order on page
> (1:41125), slots 15 and 16.
> CHECKTABLE found 0 allocation errors and 3 consistency errors in table
> 'INT_AUX_ACTIVITY' (object ID 1488776411).
> repair_rebuild is the minimum repair level for the errors found by DBCC
> CHECKTABLE (sca_master.dbo.INT_AUX_ACTIVITY ).
> I searched Google and found the following article,
>
http://www.winnetmag.com/SQLServer/Forums/messageview.cfm?catid=1664&threadid=117814
> However, my network admin tells me that he could not find anything wrong
> with the server. If drop the index pointed out in the error, dbcc returns
no
> errors.
> If add the index back, I get the errors again.
> Did anybody expericence a similar issue. Any pointers would be
appreciated.
> Thanks.
> Prasad
>