coolchaitu (10/27/2016)
Good morning Experts,In the Simple recovery model, are the tlogs truncated on checkpoint or physically shrinked? Does Log truncation mean physical shrinking of log file?
The log entries are marked as available for reuse when the checkpoint fires. Space is not yielded back to the operating system.
Shrinking is a different operation. You generally don't want to shrink your log files, but like so many other generalities, there are exceptions. In short, it depends.