Sergiy (8/30/2016)
Grant Fritchey (8/30/2016)
That's if they add shrink file. That wasn't in your original answer. You just talked about the truncate, which won't result in freeing space on the drive.Probably not the most careful choice of words from my side, but honestly - what is another possible meaning of "truncate" in application to a log file?
'Truncate' as applied to a log file, means to make VLFs reusable (as in BACKUP LOG ...TRUNCATE ONLY), not shrink the file. When we talk about 'truncating the log' it means to make space inside the file by marking 0 or more VLFs as reusable. Checkpoint does the log truncation in simple recovery, log backups in full/bulk-logged
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