sqlserver收缩日志

ALTER DATABASE demo SET RECOVERY SIMPLE --将“恢复模式”设置为“简单”
GO
USE demo
GO
DBCC SHRINKFILE (N'demo_log' , 1, TRUNCATEONLY)--收缩日志文件大小到1M
GO
USE demo
GO
ALTER DATABASE demo SET RECOVERY FULL WITH NO_WAIT ----将“恢复模式”设置为“完整”
GO
ALTER DATABASE demo SET RECOVERY FULL
GO