{"id":3334,"date":"2014-03-27T09:57:25","date_gmt":"2014-03-27T00:57:25","guid":{"rendered":"http:\/\/auctionpro.co.kr\/?p=3334"},"modified":"2024-02-26T17:34:33","modified_gmt":"2024-02-26T08:34:33","slug":"ms-sql-ldf-log-%ed%8c%8c%ec%9d%bc%ec%9a%a9%eb%9f%89-%ec%a4%84%ec%9d%b4%ea%b8%b0","status":"publish","type":"post","link":"https:\/\/www.auctionpro.co.kr\/?p=3334","title":{"rendered":"MS SQL LDF log \ud30c\uc77c\uc6a9\ub7c9 \uc904\uc774\uae30"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">mssql express \uc0ac\uc6a9\uc2dc\u00a0Ms sql ldf log \uc6a9\ub7c9\uc774 \ucee4 \ucffc\ub9ac\uac00 \uc548\uba39\ub294 \uacbd\uc6b0\uac00 \ubc1c\uc0dd \ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<br>\uc774\ub54c \ub2e4\uc74c \uba85\ub839\uc5b4\ub85c \ud574\uacb0<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">\ub514\ube44 \uc6a9\ub7c9 \ud655\uc778<\/h3>\n\n\n\n<div class=\"wp-block-urvanov-syntax-highlighter-code-block\"><pre class=\"lang:vim decode:true \" >EXEC sp_helpfile<\/pre><\/div>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<div class=\"wp-block-urvanov-syntax-highlighter-code-block\"><pre class=\"lang:tsql decode:true \">USE [DSR]\nGO\n-- Truncate the log by changing the database recovery model to SIMPLE.\nALTER DATABASE [DSR]\nSET RECOVERY SIMPLE;\nGO\n \n-- Shrink the truncated log file to 1 MB.\nDBCC SHRINKFILE ([DSR_Log], 1);\nGO\n \n-- Reset the database recovery model.\nALTER DATABASE [DSR]\nSET RECOVERY FULL;\nGO<\/pre><\/div>\n\n\n\n<h3 class=\"wp-block-heading\">\uc2e4\ud589 \ud6c4<\/h3>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/www.auctionpro.co.kr\/wp-content\/uploads\/2014\/03\/Shrink.png\"><img loading=\"lazy\" decoding=\"async\" width=\"652\" height=\"477\" src=\"https:\/\/www.auctionpro.co.kr\/wp-content\/uploads\/2014\/03\/Shrink.png\" alt=\"\" class=\"wp-image-7224\" srcset=\"https:\/\/www.auctionpro.co.kr\/wp-content\/uploads\/2014\/03\/Shrink.png 652w, https:\/\/www.auctionpro.co.kr\/wp-content\/uploads\/2014\/03\/Shrink-300x219.png 300w, https:\/\/www.auctionpro.co.kr\/wp-content\/uploads\/2014\/03\/Shrink-150x110.png 150w, https:\/\/www.auctionpro.co.kr\/wp-content\/uploads\/2014\/03\/Shrink-400x293.png 400w\" sizes=\"auto, (max-width: 652px) 100vw, 652px\" \/><\/a><\/figure>\n","protected":false},"excerpt":{"rendered":"<div class=\"mh-excerpt\"><p>mssql express \uc0ac\uc6a9\uc2dc\u00a0Ms sql ldf log \uc6a9\ub7c9\uc774 \ucee4 \ucffc\ub9ac\uac00 \uc548\uba39\ub294 \uacbd\uc6b0\uac00 \ubc1c\uc0dd \ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.\uc774\ub54c \ub2e4\uc74c \uba85\ub839\uc5b4\ub85c \ud574\uacb0 \ub514\ube44 \uc6a9\ub7c9 \ud655\uc778 \uc2e4\ud589 \ud6c4<\/p>\n<\/div>","protected":false},"author":6,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[16],"tags":[],"class_list":["post-3334","post","type-post","status-publish","format-standard","hentry","category-mssql-server"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.auctionpro.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/3334","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.auctionpro.co.kr\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.auctionpro.co.kr\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.auctionpro.co.kr\/index.php?rest_route=\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/www.auctionpro.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=3334"}],"version-history":[{"count":0,"href":"https:\/\/www.auctionpro.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/3334\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.auctionpro.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=3334"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.auctionpro.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=3334"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.auctionpro.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=3334"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}