How to resolve an issue from DBCC checkdb result?

  • I am running aDBCC checkdb and found a problem with one of the table and it depicts the following error message:

    [Microsoft][ODBC SQL Server Driver][SQL Server]Table error: Object ID -889817902, index ID 50020, page ID (1:923037). The PageId in the page header = (33739:-664239519). [Microsoft][ODBC SQL Server Driver][SQL Server]Table error: Object ID 1685581043. The

    How to repair a table? Will recreatring it will resolve the issue?

    Any idea or advice would help.

  • The data corruption forum is probably a better place for this than the forum on administration of notification services. That said....

    DBCC returns a statement at the bottom stating the minimum level required to fix the table.

    If it says that repair_rebuild will fix the issue, then you can use DBCC CheckDB with repair_rebuild to fix the problem. (check Books online for details)

    If it says that repair_allow_data_loss is required, then you have two choices. You can run checkdb with that opption however, you will loose data.

    Alternativly, you can find a backup from before the corruption occurred, restore that and restore your tran logs. Good if the corruption is recent and the data critical.

    It depends how critical the data is and how often it changes.

    You can try and recreate the table. SQL may throw errors however.

    Do you know what table it is? Looking at the object and index ids you gave, they look very wrong.

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

     

    Most of the time table give errors when index pages goes wrong.

    Pls read books online about DBCC checktable with the tablename.

    U can repair the table with the option given for the command.

     

    Regards

     

     

Viewing 3 posts - 1 through 3 (of 3 total)

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