Transaction Logs and Backups

[sshafe]

If I'm in simple recovery mode, when are the transaction logs truncated? Is it as soon as a full backup is done? Or do I have to specify a special parameter?

Reason for asking:
I had a transaction log grow to 13G about 2 1/2 hours after a differential backup. I'm trying to narrow down if this was due to a LUW or something else I need to be looking for.

Any help is appreciated.

 

[mrdenny]

If you are in simple recovery mode the transaction logs should truncate them selves every checkpoint, which should be about once per minute.

Now keep in mind that the file will not get any smaller just because the log is truncated unless the auto shrink option is set on the database.

Denny

--Anything is possible. All it takes is a little research. (Me)