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 5:59 am

    #1220595

    Can you run SQLCMD (the command line tool), connect to this DB and run the checkDB again. I think that SQLCMD will give all 3000 errors instead of the 1000 that SSMS reported. If so, save the list of errors in a text file, zip and attach please.

    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