Home Forums SQL Server 2012 SQL Server 2012 - T-SQL Clustered index not in Sys.Partions (The metadata is inconsistent. Run DBCC CHECKDB to check for a metadata corruption) RE: Clustered index not in Sys.Partions (The metadata is inconsistent. Run DBCC CHECKDB to check for a metadata corruption)

  • January 30, 2015 at 10:43 am

    #1774414

    Database 19 will probably be the hidden snapshot that CheckDB creates.

    To be honest, I suspect dropping the table will be about the only solution here, although I'd like to see the rest of the output from that CheckDB first as you left out the important lines.

    Can you also try to run

    DBCC CheckDB('elmah_error') WITH NO_INFOMSGS, Tablock

    Make sure there are no connections to the DB from anywhere first.

    p.s. It's not 'Mr'

    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