{"id":1311,"date":"2022-02-25T13:35:03","date_gmt":"2022-02-25T05:35:03","guid":{"rendered":"http:\/\/www.haoht.com.cn\/?p=1311"},"modified":"2022-02-25T13:35:03","modified_gmt":"2022-02-25T05:35:03","slug":"sql2008-%e4%bb%a5%e4%b8%8a%e7%89%88%e6%9c%ac%e6%97%a5%e5%bf%97%e6%b8%85%e7%90%86","status":"publish","type":"post","link":"http:\/\/www.haoht.com.cn\/1311\/","title":{"rendered":"SQL2008 \u4ee5\u4e0a\u7248\u672c\u65e5\u5fd7\u6e05\u7406"},"content":{"rendered":"<h2>SQL2008 \u4ee5\u4e0a\u7248\u672c\u65e5\u5fd7\u6e05\u7406<\/h2>\n<ul>\n<li>\u5efa\u8bae\u5bf9\u9700\u8981\u505a\u65e5\u5fd7\u6e05\u7406\u7684\u6570\u636e\u5e93\uff0c\u5148\u505a <span style=\"color: #993300;\">\u6570\u636e\u5e93\u5907\u4efd<\/span><\/li>\n<li>\u6570\u636e\u5e93\u53ef\u80fd\u56e0\u4e3a\u65e5\u5fd7\u6587\u4ef6\u5927\u800c\u9020\u6210\u7a7a\u95f4\u4e0d\u8db3\uff08\u5148\u67e5\u770b\u6570\u636e\u5e93\u6587\u4ef6\u7684\u65e5\u5fd7\u6587\u4ef6\u5927\u5c0f\uff09<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-1315 size-full\" src=\"http:\/\/www.haoht.com.cn\/wp-content\/uploads\/2022\/02\/sqllog1.jpg\" alt=\"\" width=\"247\" height=\"287\" \/><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-1314 size-full\" src=\"http:\/\/www.haoht.com.cn\/wp-content\/uploads\/2022\/02\/sqllog2.jpg\" alt=\"\" width=\"560\" height=\"361\" srcset=\"http:\/\/www.haoht.com.cn\/wp-content\/uploads\/2022\/02\/sqllog2.jpg 560w, http:\/\/www.haoht.com.cn\/wp-content\/uploads\/2022\/02\/sqllog2-300x193.jpg 300w\" sizes=\"auto, (max-width: 560px) 100vw, 560px\" \/><\/p>\n<ul>\n<li>\u8fd0\u884c\u811a\u672c\u83b7\u53d6\u6240\u9700\u6e05\u7406\u6570\u636e\u5e93\u7684\u65e5\u5fd7\u540d\u79f0 \uff08\u4fee\u6539\u7ea2\u8272\u90e8\u5206\u6570\u636e\u5e93\u540d\u79f0\uff09<\/li>\n<\/ul>\n<table>\n<tbody>\n<tr>\n<td width=\"1\"><\/td>\n<\/tr>\n<tr>\n<td><\/td>\n<td width=\"597\">\n<table width=\"100%\">\n<tbody>\n<tr>\n<td>&#8211;\u67e5\u8be2\u6307\u5b9a\u6570\u636e\u5e93\u7684 \uff0c\u901a\u8fc7\u4e0b\u9762\u7684sql\u7684\u8bed\u53e5\u67e5\u8be2<\/p>\n<p>USE [\u6570\u636e\u5e93\u540d]<br \/>\nGO<br \/>\nSELECT name FROM SYS.database_files WHERE type_desc=&#8217;LOG&#8217;<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-1313 size-full\" src=\"http:\/\/www.haoht.com.cn\/wp-content\/uploads\/2022\/02\/sqllog3.jpg\" alt=\"\" width=\"387\" height=\"330\" srcset=\"http:\/\/www.haoht.com.cn\/wp-content\/uploads\/2022\/02\/sqllog3.jpg 387w, http:\/\/www.haoht.com.cn\/wp-content\/uploads\/2022\/02\/sqllog3-300x256.jpg 300w\" sizes=\"auto, (max-width: 387px) 100vw, 387px\" \/><\/p>\n<ul>\n<li>\u6253\u5f00\u5e76\u4fee\u6539\u6e05\u7406\u65e5\u5fd7\u6587\u4ef6<\/li>\n<\/ul>\n<table>\n<tbody>\n<tr>\n<td width=\"2\"><\/td>\n<\/tr>\n<tr>\n<td><\/td>\n<td width=\"597\">\n<table width=\"100%\">\n<tbody>\n<tr>\n<td>USE [master]<\/p>\n<p>GO<\/p>\n<p>ALTER DATABASE [\u6570\u636e\u5e93\u540d] SET RECOVERY SIMPLE WITH NO_WAIT<\/p>\n<p>GO<\/p>\n<p>ALTER DATABASE [\u6570\u636e\u5e93\u540d] SET RECOVERY SIMPLE<\/p>\n<p>GO<\/p>\n<p>USE [\u6570\u636e\u5e93\u540d]<\/p>\n<p>GO<\/p>\n<p>DBCC SHRINKFILE (N&#8217;\u6570\u636e\u5e93\u65e5\u5fd7\u6587\u4ef6\u540d\u79f0&#8217; , 0,TRUNCATEONLY)<\/p>\n<p>GO<\/p>\n<p>USE [master]<\/p>\n<p>GO<\/p>\n<p>ALTER DATABASE [\u6570\u636e\u5e93\u540d] SET RECOVERY FULL WITH NO_WAIT<\/p>\n<p>GO<\/p>\n<p>ALTER DATABASE [\u6570\u636e\u5e93\u540d] SET RECOVERY FULL<\/p>\n<p>GO<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>\u6309\u811a\u672c\u83b7\u53d6\u5230\u7684 \u6570\u636e\u5e93\u65e5\u5fd7\u6587\u4ef6\u540d\u79f0 \u2013 \u8986\u76d6\uff1b \u53ca\u4fee\u6539 \u6570\u636e\u5e93\u540d<\/p>\n<p>\u7c98\u8d34\u4ee3\u7801\u5230 SQL\u7684\u67e5\u8be2\u5206\u6790\u5668\u8fdb\u884c\u8fd0\u884c<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-1312 size-full\" src=\"http:\/\/www.haoht.com.cn\/wp-content\/uploads\/2022\/02\/sqllog4.jpg\" alt=\"\" width=\"560\" height=\"429\" srcset=\"http:\/\/www.haoht.com.cn\/wp-content\/uploads\/2022\/02\/sqllog4.jpg 560w, http:\/\/www.haoht.com.cn\/wp-content\/uploads\/2022\/02\/sqllog4-300x230.jpg 300w\" sizes=\"auto, (max-width: 560px) 100vw, 560px\" \/><\/p>\n<p>\u8fd0\u884c\u540e\uff0c\u65e5\u5fd7\u6587\u4ef6\u5c06\u6e05\u7a7a<\/p>\n","protected":false},"excerpt":{"rendered":"<p>SQL2008 \u4ee5\u4e0a\u7248\u672c\u65e5\u5fd7\u6e05\u7406 \u5efa\u8bae\u5bf9\u9700\u8981\u505a\u65e5\u5fd7\u6e05\u7406\u7684\u6570\u636e\u5e93\uff0c\u5148\u505a \u6570\u636e\u5e93\u5907\u4efd \u6570\u636e\u5e93\u53ef\u80fd\u56e0\u4e3a\u65e5\u5fd7\u6587\u4ef6\u5927\u800c\u9020 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":1316,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2,3,4],"tags":[16],"class_list":["post-1311","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-pcenter","category-cpsc","category-shishi","tag-shouce"],"_links":{"self":[{"href":"http:\/\/www.haoht.com.cn\/wp-json\/wp\/v2\/posts\/1311","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.haoht.com.cn\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.haoht.com.cn\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.haoht.com.cn\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.haoht.com.cn\/wp-json\/wp\/v2\/comments?post=1311"}],"version-history":[{"count":1,"href":"http:\/\/www.haoht.com.cn\/wp-json\/wp\/v2\/posts\/1311\/revisions"}],"predecessor-version":[{"id":1317,"href":"http:\/\/www.haoht.com.cn\/wp-json\/wp\/v2\/posts\/1311\/revisions\/1317"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/www.haoht.com.cn\/wp-json\/wp\/v2\/media\/1316"}],"wp:attachment":[{"href":"http:\/\/www.haoht.com.cn\/wp-json\/wp\/v2\/media?parent=1311"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.haoht.com.cn\/wp-json\/wp\/v2\/categories?post=1311"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.haoht.com.cn\/wp-json\/wp\/v2\/tags?post=1311"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}