If you see the next message “The log file for database ‘tempdb’ is full.”, or if you only want empty the log of each database, you can do the next.

Open the SQL Query Analyzer
and run this:

BACKUP LOG <"database_name"> WITH TRUNCATE_ONLY
GO

NOTE: Sorry for my english, but i am learning. I accept corrections.
(NOTE: was migrated of the old site)