SQLServer2008收缩数据库日志

-- 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

该方法是目前经常使用的