USE [databaseName]GO

-- 將數據庫設置為簡單恢復模式，ALTER DATABASE[databaseName]SET RECOVERY SIMPLE;GO

--壓縮為100MDBCC SHRINKFILE ([databaseName_log], 100);GO-- 恢復ALTER DATABASE[databaseName]SET RECOVERY FULL;GO