Post reply

No Catalog Entry Found For Partition ID X in DataBase Y

  • April 23, 2012 at 1:27 am

    #267834

    HI For All

    I Upgrade Sql Server 2005 to Sql Server 2008R2

    When I Execute Drop Table Command I Give this Error:

    No catalog entry found for partition ID 281474980577280 in database 5. The metadata is inconsistent. Run DBCC CHECKDB to check for a metadata corruption.

    When I Run DBCC CHECKDB Again Give this Error

    please Help me.

    thanks

  • April 23, 2012 at 3:45 am

    #1477357

    Please run this and post the full and complete output.

    DBCC CHECKDB (<Database Name>) WITH NO_INFOMSGS, ALL_ERRORMSGS

    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

  • April 23, 2012 at 4:09 am

    #1477371

    thanks for your reply

    I Execute <<DBCC CHECKDB (<database_name>) WITH NO_INFOMSGS, ALL_ERRORMSGS>> and I give this error again:

    No catalog entry found for partition ID 281474977824768 in database 10. The metadata is inconsistent. Run DBCC CHECKDB to check for a metadata corruption.

  • April 23, 2012 at 5:07 am

    #1477396

    The entire and complete, unedited output please.

    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

  • April 23, 2012 at 5:32 am

    #1477418

    Msg 608, Level 16, State 1, Line 1

    No catalog entry found for partition ID 281474977824768 in database 10. The metadata is inconsistent. Run DBCC CHECKDB to check for a metadata corruption.

  • April 23, 2012 at 5:39 am

    #1477424

    Is that absolutely all that it output? I really do want to see every single line that checkDB output, regardless of whether it looks important or not.

    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

  • April 23, 2012 at 11:02 pm

    #1477906

    thanks

    yes this is absolut output after Execute DBCC CHECKBD Command

Viewing 7 posts - 1 through 6 (of 6 total)

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