{"id":1469,"date":"2007-03-29T14:26:29","date_gmt":"2007-03-29T14:26:29","guid":{"rendered":"http:\/\/bluesoul.pe.kr\/wp\/?p=1469"},"modified":"2007-03-29T14:26:29","modified_gmt":"2007-03-29T14:26:29","slug":"mssql-%eb%94%94%eb%b9%84%ec%b6%95%ec%86%8c-%eb%aa%85%eb%a0%b9%ec%96%b4","status":"publish","type":"post","link":"https:\/\/bluesoul.pe.kr\/wp\/?p=1469","title":{"rendered":"mssql \ub514\ube44\ucd95\uc18c \uba85\ub839\uc5b4"},"content":{"rendered":"<p> \ucd9c\ucc98 : http:\/\/cafe.naver.com\/ilovedata.cafe?iframe_url=\/ArticleRead.nhn%3Farticleid=297<\/p>\n<p>autoshrink(\uc790\ub3d9\ucd95\uc18c)<\/p>\n<p>autoshrink \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc18d\uc131\uc740 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uac00 \uc790\ub3d9\uc73c\ub85c \ucd95\uc18c\ub418\uac8c \ud55c\ub2e4.<br \/>\nautoshrink \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc18d\uc131\uc740 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 \ub4f1\ub85d\uc815\ubcf4\uc758 \uc635\uc158\ud15d\uc5d0\uc11c \uc124\uc815\ud560 \uc218 \uc788\ub2e4.<br \/>\n\ud6a8\uacfc\ub294 DBCC SHRINKDATABASE(dbname, 25)\ub97c \uc2e4\ud589\uc2dc\ud0a4\ub294 \uac83\uacfc \ub3d9\uc77c\ud558\ub2e4.<br \/>\n\uc774 \uc635\uc158\uc740 \ucd95\uc18c\ud55c \ud6c4\uc5d0 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0 25% \uc5ec\uc720 \uacf5\uac04\uc744 \ub0a8\uae30\uace0, \ub098\uba38\uc9c0 \ub0a8\ub294 \uacf5\uac04\uc740 \uc6b4\uc601\uccb4\uc81c\uc5d0\uac8c \ubc18\ud658\ud55c\ub2e4. autoshrink\ub97c \uc218\ud589\ud558\ub294 \uc2a4\ub808\ub4dc(\ud56d\uc0c1 \uc11c\ubc84 \ud504\ub85c\uc138\uc2a4 ID(spid) 6\uc744 \uac00\uc9d0)\ub294 30\ubd84 \uac04\uaca9\uc73c\ub85c \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \ucd95\uc18c\ud55c\ub2e4.<\/p>\n<p>DBCC SHRINKFILE<\/p>\n<p>DBCC SHRINKFILE\uc740 \ud604\uc7ac \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0 \uc788\ub294 \ud30c\uc77c\ub4e4\uc744 \ucd95\uc18c\uc2dc\ud0a8\ub2e4.<br \/>\n\uad6c\ubb38\uc740 \ub2e4\uc74c\uacfc \uac19\ub2e4.<br \/>\nDBCC SHRINKFILE<br \/>\n     ( { file_name | file_id }<br \/>\n         { [ , target_size(mb) ]<br \/>\n             | [ , { EMPTYFILE | NOTRUNCATE | TRUNCATEONLY } ]<br \/>\n        }<br \/>\n    ) <\/p>\n<p>target_size\uac00 \uc9c0\uc815\ub420 \ub54c DBCC SHRINKFILE\uc740 \uc9c0\uc815\ub41c \ud30c\uc77c\uc744 MB \ub2e8\uc704\ub85c \uc9c0\uc815\ub41c \ud06c\uae30\ub85c \ucd95\uc18c\uc2dc\ud0a4\ub824\uace0 \ud55c\ub2e4. \uc0ac\uc6a9\ub41c \ud398\uc774\uc9c0 \uc911\uc5d0\uc11c \ud574\uc81c\ub41c \ubd80\ubd84\uc5d0 \ub4e4\uc5b4\uac04 \uc601\uc5ed\uc740 \ud30c\uc77c \ub0b4\uc758 \uc0ac\uc6a9 \uac00\ub2a5\ud55c \uc5ec\uc720 \uacf5\uac04\uc73c\ub85c \ub4e4\uc5b4\uac04\ub2e4.<br \/>\n\uc608\ub97c \ub4e4\uc5b4, 15MB \ub370\uc774\ud130 \ud30c\uc77c\uc774 \uc788\uc744 \ub54c target_size(MB) \uac12\uc774 12\uc778 DBCC SHRINKFILE\ub97c \uc2e4\ud589\uc2dc\ud0a4\uba74(DBCC SHRINKFILE(dbname, 12)) \ud30c\uc77c\uc758 \ub9c8\uc9c0\ub9c9 3MB\uc5d0 \uc788\ub294 \ubaa8\ub4e0 \uc0ac\uc6a9\ub41c \ud398\uc774\uc9c0\ub4e4\uc740 \ucc98\uc74c 12MB\uc5d0 \uc788\ub294 \uc5ec\uc720 \uc2ac\ub86f\uc5d0 \ub4e4\uc5b4\uac04\ub2e4.<br \/>\nDBCC SHRINKFILE\uc740 \ub370\uc774\ud130 \uc800\uc7a5\uc5d0 \ud544\uc694\ud55c \ud06c\uae30\ubcf4\ub2e4 \uc801\uac8c \ud30c\uc77c\uc744 \ucd95\uc18c\uc2dc\ud0a4\uc9c0 \uc54a\ub294\ub2e4. \uc608\uc744 \ub4e4\uc5b4, 10MB \ub370\uc774\ud130 \ud30c\uc77c\uc5d0 \uc788\ub294 \ud398\uc774\uc9c0\ub4e4\uc758 70%\uac00 \uc0ac\uc6a9\ub418\uace0 \uc788\ub2e4\uba74 target_size \uac12\uc774 5\uc778 DBCC SHRINKFILE \ubb38\uc740 \ud30c\uc77c \ud06c\uae30\ub97c 5MB\uac00 \uc544\ub2cc 7MB\ub85c \ucd95\uc18c\uc2dc\ud0a8\ub2e4.<\/p>\n<p>DBCC SHRINKDATABASE<\/p>\n<p>DBCC SHRINKDATABASE \ub294 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0 \uc788\ub294 \ubaa8\ub4e0 \ud30c\uc77c\ub4e4\uc744 \ucd95\uc18c\uc2dc\ud0a8\ub2e4.<br \/>\n\uad6c\ubb38\uc740 \ub2e4\uc74c\uacfc \uac19\ub2e4.<br \/>\nDBCC SHRINKDATABASE<br \/>\n     ( database_name [ , target_percent (%)]<br \/>\n         [ , { NOTRUNCATE | TRUNCATEONLY } ]<br \/>\n    ) <\/p>\n<p>\ub370\uc774\ud130\ubca0\uc774\uc2a4\ub294 model \ub370\uc774\ud130\ubca0\uc774\uc2a4 \ubcf4\ub2e4 \ub610\ub294 \ud30c\uc77c\uc758 \ucd5c\uc18c \ud06c\uae30\ubcf4\ub2e4 \ub354 \uc801\uac8c \ucd95\uc18c \ub420 \uc218\ub294 \uc5c6\ub2e4.<br \/>\n\ub370\uc774\ud130\ubca0\uc774\uc2a4 \ud30c\uc77c\uc758 \ucd5c\uc18c \ud06c\uae30\ub294 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uac00 \uc0dd\uc131\ub420 \ub54c \uc9c0\uc815\ub41c \ud30c\uc77c\uc758 \ucd08\uae30 \ud06c\uae30\uc77c \uc218\ub3c4 \uc788\uace0, alter database\ub098 dbcc shrinkfile \uba85\ub839\uc5b4\ub97c \uc0ac\uc6a9\ud558\uc5ec \uba85\uc2dc\uc801\uc73c\ub85c \ud655\uc7a5\ub418\uac70\ub098 \ucd95\uc18c\ub41c \ud30c\uc77c \ud06c\uae30\uc77c \uc218\ub3c4 \uc788\ub2e4.<br \/>\nDBCC SHRINKDATABASE\uc740 \ud30c\uc77c\ubcc4\ub85c \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \ucd95\uc18c \uc2dc\ud0a4\uae30 \ub54c\ubb38\uc5d0 \uc2e4\uc81c \ucd95\uc18c \uc791\uc5c5\uc744 \uc218\ud589\ud558\uae30 \uc704\ud574 \uc0ac\uc6a9\ub41c \uba54\ucee4\ub2c8\uc998\uc740 DBCC SHRINKFILE\uc5d0\uc11c \uc0ac\uc6a9\ub41c \uac83\uacfc \ub3d9\uc77c\ud558\ub2e4. SQL Server\ub294 \uba3c\uc800 \ud30c\uc77c\uc758 \uc55e\ubd80\ubd84\uc73c\ub85c \ud398\uc774\uc9c0\ub4e4\uc744 \uc774\ub3d9\uc2dc\ucf1c\uc11c \ub4b7\ubd80\ubd84\uc5d0 \uc5ec\uc720 \uacf5\uac04\uc744 \ub9cc\ub4e0 \ud6c4, \uc801\ub2f9\ud55c \uac1c\uc218\uc758 \uc5ec\uc720 \ud398\uc774\uc9c0\ub4e4\uc744 \uc6b4\uc601\uccb4\uc81c\uc5d0\uac8c \ubc18\ud658\ud55c\ub2e4.<\/p>\n<p>\uc635\uc158<br \/>\nNOTRUNCATE \uc635\uc158\uc740 \uc5ec\uc720 \uacf5\uac04\uc73c\ub85c \ub41c \ubd80\ubd84\uc774 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \ud30c\uc77c\uc5d0 \uc720\uc9c0\ub418\uac8c \ud55c\ub2e4. SQL Server\ub294 \ub370\uc774\ud130\ub97c \ud30c\uc77c\uc758 \uc55e\ubd80\ubd84\uc73c\ub85c \uc774\ub3d9\uc2dc\ud0a4\ub294 \ubc29\uc2dd\uc73c\ub85c\ub9cc \ub370\uc774\ud130\ub97c \ucd95\uc18c\uc2dc\ud0a8\ub2e4. \ub514\ud3f4\ud2b8 \ubc29\uc2dd\uc740 \uc5ec\uc720 \uacf5\uac04\uc73c\ub85c \ub41c \ubd80\ubd84\uc744 \uc6b4\uc601\uccb4\uc81c\uc5d0\uac8c \ubc18\ud658\ud558\ub294 \uac83\uc774\ub2e4.<\/p>\n<p>TRUNCATEONLY \uc635\uc158\uc740 \ub370\uc774\ud130 \ud30c\uc77c \uc911\uc5d0\uc11c \uc0ac\uc6a9\ub418\uc9c0 \uc54a\ub294 \uacf5\uac04\uc744 \uc6b4\uc601\uccb4\uc81c\uc5d0\uac8c \ubc18\ud658\ud558\uac8c \ud55c\ub2e4. \ud589\ub4e4\uc744 \ud560\ub2f9\ub418\uc9c0 \uc54a\ub294 \ud398\uc774\uc9c0\ub85c \uc774\ub3d9\uc2dc\ud0a4\ub294 \ub3d9\uc791\uc740 \uc77c\uc5b4\ub098\uc9c0 \uc54a\ub294\ub2e4. TRUNCATEONLY\uac00 \uc0ac\uc6a9\ub420 \ub54c target_size\ub098 target_percent\ub294 \ubb34\uc2dc\ub41c\ub2e4.<\/p>\n<p>EMPTYFILE \uc635\uc158\uc740 DBCC SHRINKFILE \uc5d0\uc11c\ub9cc \uc0ac\uc6a9\ub420 \uc218 \uc788\ub2e4. \ub370\uc774\ud130 \ud30c\uc77c\uc758 \ub0b4\uc6a9\uc744 \ube44\uc6b0\uace0, \uc774\uac83\ub4e4\uc744 \ud30c\uc77c \uadf8\ub8f9\uc758 \ub2e4\ub978 \ud30c\uc77c\ub4e4\ub85c \uc774\ub3d9\uc2dc\ud0a8\ub2e4. <\/p>\n","protected":false},"excerpt":{"rendered":"<p>\ucd9c\ucc98 : http:\/\/cafe.naver.com\/ilovedata.cafe?iframe_url=\/ArticleRead.nhn%3Farticleid=297 autoshrink(\uc790\ub3d9\ucd95\uc18c) autoshrink \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc18d\uc131\uc740 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uac00 \uc790\ub3d9\uc73c\ub85c \ucd95\uc18c\ub418\uac8c \ud55c\ub2e4. autoshrink \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc18d\uc131\uc740 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 \ub4f1\ub85d\uc815\ubcf4\uc758 \uc635\uc158\ud15d\uc5d0\uc11c \uc124\uc815\ud560 \uc218 \uc788\ub2e4. \ud6a8\uacfc\ub294 DBCC SHRINKDATABASE(dbname, 25)\ub97c \uc2e4\ud589\uc2dc\ud0a4\ub294 \uac83\uacfc \ub3d9\uc77c\ud558\ub2e4. \uc774 \uc635\uc158\uc740 \ucd95\uc18c\ud55c \ud6c4\uc5d0 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0 25% \uc5ec\uc720 \uacf5\uac04\uc744 \ub0a8\uae30\uace0, \ub098\uba38\uc9c0 \ub0a8\ub294 \uacf5\uac04\uc740 \uc6b4\uc601\uccb4\uc81c\uc5d0\uac8c \ubc18\ud658\ud55c\ub2e4. autoshrink\ub97c \uc218\ud589\ud558\ub294 \uc2a4\ub808\ub4dc(\ud56d\uc0c1 \uc11c\ubc84 \ud504\ub85c\uc138\uc2a4 ID(spid) 6\uc744 \uac00\uc9d0)\ub294 30\ubd84 \uac04\uaca9\uc73c\ub85c \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \ucd95\uc18c\ud55c\ub2e4. DBCC SHRINKFILE &hellip; <a href=\"https:\/\/bluesoul.pe.kr\/wp\/?p=1469\" class=\"more-link\">\uacc4\uc18d \uc77d\uae30<span class=\"screen-reader-text\"> &#8220;mssql \ub514\ube44\ucd95\uc18c \uba85\ub839\uc5b4&#8221;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-1469","post","type-post","status-publish","format-standard","hentry","category-tip"],"_links":{"self":[{"href":"https:\/\/bluesoul.pe.kr\/wp\/index.php?rest_route=\/wp\/v2\/posts\/1469","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/bluesoul.pe.kr\/wp\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/bluesoul.pe.kr\/wp\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/bluesoul.pe.kr\/wp\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/bluesoul.pe.kr\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1469"}],"version-history":[{"count":0,"href":"https:\/\/bluesoul.pe.kr\/wp\/index.php?rest_route=\/wp\/v2\/posts\/1469\/revisions"}],"wp:attachment":[{"href":"https:\/\/bluesoul.pe.kr\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1469"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/bluesoul.pe.kr\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1469"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/bluesoul.pe.kr\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1469"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}