sql transaction logs - Truncation

[Robert_Koss]

This is probable a very easy question however I am going to ask it anyway!

My databases are set to simple (not full).  I have SQL 2000 and SQL 2005. When I do a full back up does it truncate my transaction logs automatically?  If not, can I set my full to truncate my transaction log or do I have to run a backup of the Transaction log with the truncate option?

Message Edited by Robert Koss on 07-30-200701:21 PM

[Hywel_Mallett]

If your databases are in simple logging mode, then your transaction logs won't be growing.

If your databases were set to full logging mode, then you'd need to do a full backup and a transaction log backup to truncate the logs.

[Robert_Koss]

Thanks for the information it makes sense.