• ryan.mcatee (6/18/2013)


    In simple recovery mode, when you take a full backup, I believe the log file is backed up and truncated.

    No.

    In simple recovery model a checkpoint will truncate the log. Checkpoints run on a regular basis. In full and bulk-logged recovery model a log backup truncates the log

    Full backups do not, in any recovery model, truncate the log. Nor do they back up the log (though they include enough of the log for a consistent restore in all recovery models)

    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