该方法可以简单粗暴的将SQL Server的巨大Log文件缩减为2M, 根据事务恢复将失效.

USE[master]
GO

ALTER DATABASE [XXXXX] SET RECOVERY SIMPLE WITH NO_WAIT
GO

ALTER DATABASE [XXXXX] SET RECOVERY SIMPLE   —简单模式
GO

USE [XXXXX]
GO

DBCC SHRINKFILE (N’XXXXX_log’ , 2, TRUNCATEONLY)  —设置压缩后的日志大小为2M，可以自行指定
GO

USE[master]
GO

ALTER DATABASE [XXXXX] SET RECOVERY FULL WITH NO_WAIT
GO

ALTER DATABASE [XXXXX] SET RECOVERY FULL  —还原为完全模式