【SQL Server 学习系列】-- 收缩数据库文件大小

USE WebExam;  
GO  

ALTER DATABASE WebExam
SET RECOVERY SIMPLE;  
GO  

-- 收缩文件到 1 MB.  
DBCC SHRINKFILE (WebExam_Log, 1);  
GO  

ALTER DATABASE WebExam
SET RECOVERY FULL;  
GO

 

转载于:https://www.cnblogs.com/elliot-lei/p/5584362.html