DBCC CheckTable

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

  • 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, 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
  • 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)

  • 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

  • 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

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply