How to truncate SQL Log

http://stackoverflow.com/questions/40402/what-is-the-command-to-truncate-a-sql-server-log-file

In management studio:

• Right-click the database, choose properties, then options.
• Make sure "Recovery model" is set to "Simple", not "Full"
• Click Ok
• Right-click the database again, choose tasks -> shrink files
• Change file type to "log"
• Click ok.

Alternatively, the SQL to do it:

 ALTER DATABASE mydatabase SET RECOVERY SIMPLE
 DBCC SHRINKFILE (mydatabase_Log, 1)

Ref: http://msdn.microsoft.com/en-us/library/ms189493.aspx