{"id":3255,"date":"2013-02-03T02:31:26","date_gmt":"2013-02-03T02:31:26","guid":{"rendered":"http:\/\/blog.pmail.idv.tw\/?p=3255"},"modified":"2013-02-03T02:31:26","modified_gmt":"2013-02-03T02:31:26","slug":"%e8%a7%a3%e6%b1%basharepoint-%e7%a1%ac%e7%a2%9f%e7%a9%ba%e9%96%93%e4%b8%8d%e8%b6%b3","status":"publish","type":"post","link":"https:\/\/blog.pmail.idv.tw\/?p=3255","title":{"rendered":"\u89e3\u6c7aSharePoint \u786c\u789f\u7a7a\u9593\u4e0d\u8db3"},"content":{"rendered":"

\u56e0\u4e3b\u6a5f\u7a7a\u9593\u4e0d\u5920\uff0c\u767c\u73fe\u8cc7\u6599\u5eab\u53calog \u6a94\u6848\u904e\u5927 <\/p>\n

\u5176\u5be6\u53ea\u8981\u505alog\u58d3\u7e2e\u5373\u53ef<\/p>\n

<\/p>\n

===== \u53c3\u8003\u8a9e\u6cd5 \u58d3\u7e2e\u6210 300 MB ==== <\/p>\n

USE WSS_Content; <\/p>\n

GO <\/p>\n

— Truncate the log by changing the database recovery model to SIMPLE. <\/p>\n

ALTER DATABASE WSS_Content <\/p>\n

SET RECOVERY SIMPLE; <\/p>\n

GO <\/p>\n

— Shrink the truncated log file to 300 MB. <\/p>\n

DBCC SHRINKFILE (WSS_Content_Log, 300); <\/p>\n

GO <\/p>\n

— Reset the database recovery model. <\/p>\n

ALTER DATABASE WSS_Content <\/p>\n

SET RECOVERY FULL; <\/p>\n

GO <\/p>\n

Ps.\u53c3\u8003 <\/p>\n

http:\/\/msdn.microsoft.com\/zh-tw\/library\/ms189493.aspx<\/a><\/p>\n

\n