{"id":9498,"date":"2014-07-10T08:32:00","date_gmt":"2014-07-10T00:32:00","guid":{"rendered":"http:\/\/blog.pmail.idv.tw\/?p=9498"},"modified":"2014-07-10T08:32:00","modified_gmt":"2014-07-10T00:32:00","slug":"%e5%a3%93%e7%b8%aesql-log-%e6%aa%94","status":"publish","type":"post","link":"https:\/\/blog.pmail.idv.tw\/?p=9498","title":{"rendered":"\u58d3\u7e2eSQL log \u6a94"},"content":{"rendered":"<p>\u516c\u53f8Sarepoint \u4e3b\u6a5f\u786c\u789f\u7a7a\u9593\u5feb\u7206\u4e86\uff0c\u6aa2\u67e5\u4e86\u4e00\u4e0blog \u6a94\u6848\u6eff\u5927\u7684<\/p>\n<p><!--more--><\/p>\n<p>\u67e5\u4e86\u4e00\u4e0b\u6587\u4ef6 <\/p>\n<p><a title=\"http:\/\/technet.microsoft.com\/zh-tw\/library\/ms190757.aspx\" href=\"http:\/\/technet.microsoft.com\/zh-tw\/library\/ms190757.aspx\">http:\/\/technet.microsoft.com\/zh-tw\/library\/ms190757.aspx<\/a><\/p>\n<p>\u53ef\u4ee5\u4f7f\u7528\u4ee5\u4e0b\u6307\u4ee4\u4f86\u9032\u884c\u58d3\u7e2e<\/p>\n<p><font color=\"#ff0000\">USE config_db;<br \/><\/font><font color=\"#ff0000\">GO<\/font> <\/p>\n<p>&#8212; Truncate the log by changing the database recovery model to SIMPLE. <\/p>\n<p><font color=\"#ff0000\">ALTER DATABASE config_db<br \/><\/font><font color=\"#ff0000\">SET RECOVERY SIMPLE;<br \/><\/font><font color=\"#ff0000\">GO<\/font> <\/p>\n<p>&#8212; Shrink the truncated log file to 1 MB. <\/p>\n<p><font color=\"#ff0000\">DBCC SHRINKFILE (config_db_Log, 1);<br \/><\/font><font color=\"#ff0000\">GO<\/font> <\/p>\n<p>&#8212; Reset the database recovery model. <\/p>\n<p><font color=\"#ff0000\">ALTER DATABASE config_db<br \/><\/font><font color=\"#ff0000\">SET RECOVERY FULL;<br \/><\/font><font color=\"#ff0000\">GO<\/font><\/p>\n<div class=\"21cd169d3c0f71e95b84db320302cb4a\" data-index=\"1\" style=\"float: right; margin:10px 0 10px 10px;\">\n<script async src=\"https:\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js?client=ca-pub-8711325745898650\"\r\n     crossorigin=\"anonymous\"><\/script>\n<\/div>\n\n<div style=\"font-size: 0px; height: 0px; line-height: 0px; margin: 0; padding: 0; clear: both;\"><\/div>","protected":false},"excerpt":{"rendered":"<p>\u516c\u53f8Sarepoint \u4e3b\u6a5f\u786c\u789f\u7a7a\u9593\u5feb\u7206\u4e86\uff0c\u6aa2\u67e5\u4e86\u4e00\u4e0blog \u6a94\u6848\u6eff\u5927\u7684<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"ngg_post_thumbnail":0,"footnotes":""},"categories":[103],"tags":[],"class_list":["post-9498","post","type-post","status-publish","format-standard","hentry","category-mssql"],"_links":{"self":[{"href":"https:\/\/blog.pmail.idv.tw\/index.php?rest_route=\/wp\/v2\/posts\/9498","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.pmail.idv.tw\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.pmail.idv.tw\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.pmail.idv.tw\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.pmail.idv.tw\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=9498"}],"version-history":[{"count":0,"href":"https:\/\/blog.pmail.idv.tw\/index.php?rest_route=\/wp\/v2\/posts\/9498\/revisions"}],"wp:attachment":[{"href":"https:\/\/blog.pmail.idv.tw\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=9498"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.pmail.idv.tw\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=9498"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.pmail.idv.tw\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=9498"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}