• David Kang (12/3/2012)


    repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKDB (PMM ).

    Since repair allow data loss is the minimum repair level necessary, running checkDB with any lesser repair level will be a waste of time. Minimum repair level is exactly that.

    You will lose data. Four pages of data from the table REQ_ITEM.

    I assume there's no good backup available...

    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