解決SharePoint 硬碟空間不足

因主機空間不夠，發現資料庫及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

本篇瀏覽人數: 2204