How do I truncate my MS SQL transaction log?

Connect to your MSSQL database with Query Analyzer and execute the following statement:

BACKUP LOG [db_name] WITH TRUNCATE_ONLY

where db_name should be the name of your database.