Home Forums SQL Server 2005 Data Corruption Extent (1:205976) in database ID 6 is marked allocated in the GAM, but no SGAM or IAM has allocated it. RE: Extent (1:205976) in database ID 6 is marked allocated in the GAM, but no SGAM or IAM has allocated it.

  • September 14, 2010 at 3:55 am

    #1220546

    Please run the following and post the full and complete output.

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

    Do you have a clean backup? One from before the corruption occurred?

    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