SQL Server transaction log Possible Duplicate:
  Why Does the Transaction Log Keep Growing or Run Out of Space?  




Is it possible to have SQL Server 2008 R2 reset the transaction log for certain databases when the database is backed up?

Scenario:

Auto backup job in SQL Server takes a backup of database XYZ and also of it's transaction log. When this backup has completed SQL Server will reset the transaction log (log file size will be increased to starting point)

Thank you.
Quoting Paul Randal here:


  In the FULL or BULK_LOGGED recovery models, the only thing that
  clears the log is a log backup.


http://www.sqlskills.com/blogs/paul/post/A-SQL-Server-DBA-myth-a-day-(3030)-backup-myths.aspx