Truncating SQL Server Log Files 12 November 2003 at 00:00
You can get the name of the log file for your database by looking in the sysfiles table.
  BACKUP LOG <database> WITH TRUNCATE_ONLY
  DBCC SHRINKFILE ('<logfile>', 100, TRUNCATEONLY)