Shrink Logfile

This works with MS SQL 2005 and 2008

 
Use <database Name>
GO

Alter Database <database Name> Set Recovery Simple
GO
Alter Database <database Name> Set Recovery Full
GO
DBCC SHRINKFILE (‘<log file name>’, 1)
GO