Truncating SQL Server Log Files

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)