• CirquedeSQLeil (1/15/2010)


    Potentially lost. Data may be lost - it depends on how bad the corruption is.

    Will be lost.

    If the minimum level to repair is repair_allow_data_loss, it means that there will be data loss if that is run. There's only two cases that I know of (incorrect PFS pages and orphaned LOB pages) where repair allow_data_loss is required but data won't be lost.

    In this case, there is a single damaged page in the clustered index. Repair will drop that page and fix the links. Hence, any data on that page will be lost.

    http://sqlinthewild.co.za/index.php/2009/06/03/does-repair_allow_data_loss-cause-data-loss/

    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