sqlserver 数据库、日志文件收缩

--收缩数据库日志文件 log

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



--收缩数据库文件MDF

ALTER DATABASE [weilaixueyuan_test] SET RECOVERY SIMPLE --将“恢复模式”设置为“简单”

DBCC SHRINKDATABASE([weilaixueyuan_test], 0)  --收缩数据库

ALTER DATABASE [weilaixueyuan_test] SET RECOVERY FULL  ----将“恢复模式”设置为“完整”