mssql 收缩日志

--设置简单模式
USE[master]
GO
ALTER DATABASE mindeemes_spy SET RECOVERY SIMPLE WITH NO_WAIT
GO
ALTER DATABASE mindeemes_spy SET RECOVERY SIMPLE
GO

--设置压缩后的日志大小为2M，可自定义
USE mindeemes_spy
GO
DBCC SHRINKFILE (N'mindeemes_spy_log' , 2, TRUNCATEONLY)
GO

--还原完全模式
USE[master]
GO
ALTER DATABASE mindeemes_spy SET RECOVERY FULL WITH NO_WAIT
GO
ALTER DATABASE mindeemes_spy SET RECOVERY FULL
GO