Shrink Logfile

This works with MS SQL 2005 and 2008

Use
GO
Alter Database Set Recovery Simple
GO
Alter Database Set Recovery Full
GO
DBCC SHRINKFILE (‘’, 1)
GO