Shrink лог файлов в MSSQL 2008 и MSSQL 2008R2

USE [database name]
ALTER DATABASE [database name] SET RECOVERY SIMPLE
DBCC SHRINKFILE([log file name], <preferred size>)
ALTER DATABASE [database name] SET RECOVERY FULL