Blog Post

Core Infrastructure and Security Blog
4 MIN READ

Lazy Log Truncation - Clearing of SQL transaction log VLF status deferred

SQLPFE's avatar
SQLPFE
Brass Contributor
Mar 15, 2019
First published on MSDN on Jun 27, 2013 I came across an oddity in the transaction log when I was testing Availability Group backup scenarios which really had me confused.  It required some help ...
Updated Apr 28, 2020
Version 5.0
LisaGardner
md365's avatar
md365
Copper Contributor
Nov 08, 2019

Hi,

 

Thanks for the details here.

 

I am facing this situation of few database and it seems like it prevents me to shrink the log file.

Any recommendation about that ?

 

Thanks for your help.

Mx