USE [master]
--简单模式
ALTER DATABASE [XXX] SET RECOVERY SIMPLE WITH NO_WAIT
GO
USE [XXX]
GO
--执行收缩命令，收缩到5MB
DBCC SHRINKFILE (N‘XXX_log‘ , 5, TRUNCATEONLY)
GO
USE [master]
GO
--还原为完全模式
ALTER DATABASE [XXX] SET RECOVERY FULL WITH NO_WAIT

sqlserver数据库日志收缩