因主機空間不夠,發現資料庫及log 檔案過大
其實只要做log壓縮即可
===== 參考語法 壓縮成 300 MB ====
USE WSS_Content;
GO
— Truncate the log by changing the database recovery model to SIMPLE.
ALTER DATABASE WSS_Content
SET RECOVERY SIMPLE;
GO
— Shrink the truncated log file to 300 MB.
DBCC SHRINKFILE (WSS_Content_Log, 300);
GO
— Reset the database recovery model.
ALTER DATABASE WSS_Content
SET RECOVERY FULL;
GO
Ps.參考
http://msdn.microsoft.com/zh-tw/library/ms189493.aspx
本篇瀏覽人數: 2261