SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


DBCC CheckTable


DBCC CheckTable

Author
Message
sudhakara
sudhakara
Ten Centuries
Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)

Group: General Forum Members
Points: 1040 Visits: 1386
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.
GilaMonster
GilaMonster
SSC Guru
SSC Guru (88K reputation)SSC Guru (88K reputation)SSC Guru (88K reputation)SSC Guru (88K reputation)SSC Guru (88K reputation)SSC Guru (88K reputation)SSC Guru (88K reputation)SSC Guru (88K reputation)

Group: General Forum Members
Points: 88397 Visits: 45283
Please run the following and post the full and complete output:

DBCC CHECKDB (<Database Name>Wink 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, MVP, M.Sc (Comp Sci)
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


sudhakara
sudhakara
Ten Centuries
Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)

Group: General Forum Members
Points: 1040 Visits: 1386
GilaMonster (6/5/2010)
Please run the following and post the full and complete output:

DBCC CHECKDB (<Database Name>Wink 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)
sudhakara
sudhakara
Ten Centuries
Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)

Group: General Forum Members
Points: 1040 Visits: 1386
GilaMonster (6/5/2010)
Please run the following and post the full and complete output:

DBCC CHECKDB (<Database Name>Wink 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
GilaMonster
GilaMonster
SSC Guru
SSC Guru (88K reputation)SSC Guru (88K reputation)SSC Guru (88K reputation)SSC Guru (88K reputation)SSC Guru (88K reputation)SSC Guru (88K reputation)SSC Guru (88K reputation)SSC Guru (88K reputation)

Group: General Forum Members
Points: 88397 Visits: 45283
Take the DB into single user mode and run checkDB with the repair_rebuild option.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
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


Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search