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 6:14 am

    #1220608

    The hard shutdown on the 19th Aug can't have been the cause if the database backup from the 28th August is undamaged (as you indicated).

    When did the job start failing? Look for anything that happened between the last time the integrity job ran successfully and the first time it failed.

    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