USE [databaseName]
GO
-- 将数据库设置为简单恢复模式,
ALTER DATABASE [databaseName]
SET RECOVERY SIMPLE;
GO
--压缩为100M
DBCC SHRINKFILE ([databaseName_log], 100);
GO
-- 恢复
ALTER DATABASE [databaseName]
SET RECOVERY FULL;
GO
USE [databaseName]
GO
-- 将数据库设置为简单恢复模式,
ALTER DATABASE [databaseName]
SET RECOVERY SIMPLE;
GO
--压缩为100M
DBCC SHRINKFILE ([databaseName_log], 100);
GO
-- 恢复
ALTER DATABASE [databaseName]
SET RECOVERY FULL;
GO