Revealing the secrets – Truncating a Transaction Log File
In my earlier blog post on Shrinking the Transaction Log files in SQL Server , I had mentioned that a VLF can be truncated only when all transactions, that have at least one command written into the specified VLF have either been committed or rolled back. While this is true, I understand that it might create a bit of confusion around how the truncation actually happens behind the covers.
Read the original post:
Revealing the secrets – Truncating a Transaction Log File
