SHRINK Log file in SQL Server 2008
To shrink log file in Sql Server::
Use DATABASENAME
GO
Alter Database DATABASENAME Set Recovery Simple
GO
DBCC SHRINKFILE (‘LOGFILENAME_log’, 1000)
GO
Alter Database DATABASENAME Set Recovery Full
GO
Enjoy!!!