Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

DBCC CheckTable Expand / Collapse
Author
Message
Posted Friday, June 4, 2010 10:54 PM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Monday, July 21, 2014 12:24 PM
Points: 604, Visits: 1,306
Hi,

Server giving the below eror message while running the dbcc checktable(mytable).

Server: Msg 2511, Level 16, State 2, Line 1
Table error: Object ID 2105058535, Index ID 0. Keys out of order on page (1:2528), slots 0 and 1.
Server: Msg 2511, Level 16, State 1, Line 1
Table error: Object ID 2105058535, Index ID 4. Keys out of order on page (1:142427), slots 32 and 33.
Server: Msg 2511, Level 16, State 1, Line 1
Table error: Object ID 2105058535, Index ID 4. Keys out of order on page (1:142427), slots 34 and 35.
DBCC results for 'MyTable'.
There are 12123 rows in 740 pages for object 'MyTable'.
CHECKTABLE found 0 allocation errors and 3 consistency errors in table 'MX_Properties' (object ID 2105058535).
repair_rebuild is the minimum repair level for the errors found by DBCC CHECKTABLE (SERVer.dbo.mytable ).

Please guide to resolve this issue in better way. thanks in advance.

Post #933125
Posted Saturday, June 5, 2010 4:40 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 3:09 AM
Points: 40,180, Visits: 36,583
Please run the following and post the full and complete output:
DBCC CHECKDB (<Database Name>) WITH NO_INFOMSGS, ALL_ERRORMSGS

What's the exact version of SQL that you're running?
SELECT @@Version



Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #933138
Posted Saturday, June 5, 2010 5:18 AM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Monday, July 21, 2014 12:24 PM
Points: 604, Visits: 1,306
GilaMonster (6/5/2010)
Please run the following and post the full and complete output:
DBCC CHECKDB (<Database Name>) WITH NO_INFOMSGS, ALL_ERRORMSGS

What's the exact version of SQL that you're running?
SELECT @@Version


Pls find the output of the command.
Server: Msg 2511, Level 16, State 2, Line 1
Table error: Object ID 2105058535, Index ID 0. Keys out of order on page (1:2528), slots 0 and 1.
Server: Msg 2511, Level 16, State 1, Line 1
Table error: Object ID 2105058535, Index ID 4. Keys out of order on page (1:140360), slots 37 and 38.
Server: Msg 2511, Level 16, State 1, Line 1
Table error: Object ID 2105058535, Index ID 4. Keys out of order on page (1:140360), slots 39 and 40.
CHECKDB found 0 allocation errors and 3 consistency errors in table 'Mytable' (object ID 2105058535).
CHECKDB found 0 allocation errors and 3 consistency errors in database 'SERVer'.
repair_rebuild is the minimum repair level for the errors found by DBCC CHECKDB (SERVer).

Version Details:
Microsoft SQL Server 2000 - 8.00.2055 (Intel X86)
Dec 16 2008 19:46:53
Copyright (c) 1988-2003 Microsoft Corporation
Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 2)
Post #933139
Posted Tuesday, June 8, 2010 10:08 AM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Monday, July 21, 2014 12:24 PM
Points: 604, Visits: 1,306
GilaMonster (6/5/2010)
Please run the following and post the full and complete output:
DBCC CHECKDB (<Database Name>) WITH NO_INFOMSGS, ALL_ERRORMSGS

What's the exact version of SQL that you're running?
SELECT @@Version


Hi,

Can you post your update ?

Thanks
Post #934092
Posted Friday, June 11, 2010 9:10 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 3:09 AM
Points: 40,180, Visits: 36,583
Take the DB into single user mode and run checkDB with the repair_rebuild option.


Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #936108
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse