Corruption in user Database, Unable to repair using DBCC checkdb

  • Hi Folks,

    We are receiving following message on one of the user databases and unable to repair via DBCC check DB. ALso, we don't have clean backups for last 3-4 months. Please advise on how to fix the issue.

    Msg 8992, Level 16, State 1, Line 1

    Check Catalog Msg 3853, State 1:

    Attribute of row in sys.columns does not have a matching row in sys.objects

  • CheckDB won't fix that.

    Either you have metadata corruption or the DB was upgraded from SQL 2000 and someone went messing with the system tables back then.

    Script all objects, export all data, recreate the DB.

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

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

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