-- Set to SIMPLE mode
ALTER DATABASE [DATABASE_NAME] SET RECOVERY SIMPLE; -- Shrink the db
DBCC SHRINKFILE ('DATABASE_LOG_NAME', 1); -- Set back to FULL (optional depending on backup method used)
ALTER DATABASE [DATABASE_NAME] SET RECOVERY FULL; --SELECT * FROM sys.database_files
关于 DBCC 可参考:DBCC (Transact-SQL) 来自MSDN
该方法是目前经常使用的