压缩数据库日志

USE [databaseName]GO

-- 将数据库设置为简单恢复模式，ALTER DATABASE[databaseName]SET RECOVERY SIMPLE;GO

--压缩为100MDBCC SHRINKFILE ([databaseName_log], 100);GO-- 恢复ALTER DATABASE[databaseName]SET RECOVERY FULL;GO