Home Forums SQL Server 7,2000 Data Corruption REPAIR_ALLOW_DATA_LOSS not resolving the allocation error RE: REPAIR_ALLOW_DATA_LOSS not resolving the allocation error

  • Please run the following, post the full and unedited output.

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

    CheckDB never guarantees to repair all errors. It's primarily (though certainly not only) for times when you don't have a backup and have no choice but to repair and discard data in the process.

    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