我使用了DBCC命令,但是收缩叶不成功啊USE wapgw GO -- Truncate the log by changing the database recovery model to SIMPLE. ALTER DATABASE wapgw SET RECOVERY SIMPLE; GO -- Shrink the truncated log file to 950000 MB. DBCC SHRINKFILE (wapgw, 950000); GO -- Reset the database recovery model. ALTER DATABASE wapgw SET RECOVERY FULL; GO
GO
-- Truncate the log by changing the database recovery model to SIMPLE.
ALTER DATABASE wapgw
SET RECOVERY SIMPLE;
GO
-- Shrink the truncated log file to 950000 MB.
DBCC SHRINKFILE (wapgw, 950000);
GO
-- Reset the database recovery model.
ALTER DATABASE wapgw
SET RECOVERY FULL;
GO