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 3:06 pm

    #1774496

    GilaMonster (1/30/2015)

    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'

    My apologies.

    I've been in single user mode during all these tests.

    CheckDB on 'elmah' yields:

    Msg 608, Level 16, State 1, Line 1

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