• For the record, I might add that a truncate log does not actually clear individual records or transactions from the log. It simply clears all VLFs (Virtual Log Files) that are currently marked as inactive. So, you need all the transactions that have records on the same VLF to be completely finished before the VLF can be cleared.


    Kind regards,

    Vegard Hagen
    Norwegian DBA, occasional blogger and generally a nice guy who believes the world is big enough for all of us.
    @vegard_hagen on Twitter
    Blog: Vegards corner (No actual SQL stuff here - havent found my niche yet. Maybe some day...)

    It is better to light a candle than to curse the darkness. (Chinese proverb)