Home Forums SQL Server 2005 Administering Full Backup after changing Changing recovery models RE: Full Backup after changing Changing recovery models

  • No, it'll make it worse or no change at all.

    Simple recovery - minimal logging, log truncated on checkpoint

    Bulk-logged recovery - minimal logging, log truncated on log backup (if a full or diff backup has been taken since switching)

    So why would you switch to bulk-logged and have the log be harder to reuse with no other gain?

    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