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