My database is simple recovery model and when I view the free space in log file it shows 99%. Why doesn't my log file truncate the committed data automatically to free space in ldf file? When I shrink it does shrink. Please advice. I saw this question, Why Does the Transaction Log Keep Growing or Run Out of Space?. But unlike that scenario I have a simple recovery model and my transactions seemed to have committed as there are no on going transactions and shirkable size is shown as 99%
Asked
Active
Viewed 34 times
