About That Large Log File

This was the most useful article I could find on how to deal with a large transaction log in SQL Server. Other articles advised to truncate the log on backup with the truncate_only option. This is not advised and the option has been dropped in SQL Server 2008.

For advice on how your file may have gotten so big, and what to do about, read Help! My SQL Server Log File is too big!!!