It is the production database. It is backed up using Symantec Backup Exec. I did a backup directly in SQL Server and that did not decrease the log file size. I see in Management Studio there is a shrink database task. Is that some I should try?

>
>If yours is a Development Databse then by all means change to Simple Recovery, that's the way it should be.
>If it is a Production Database holding live data of an organisation then taking backups regularly should truncate the log file.
>
>Also please see the Webcast on SQL Server it will clear all your doubts:
>"MSDN Webcast A Primer to Proper SQL Server Development 1 of 10.wmv"
>It can be downloaded from Microsoft's Website.