{"id":362,"date":"2014-08-06T12:46:49","date_gmt":"2014-08-06T03:46:49","guid":{"rendered":"http:\/\/ocworld.net\/?p=362"},"modified":"2024-12-13T15:04:35","modified_gmt":"2024-12-13T06:04:35","slug":"ms-sqlserver-2005%eb%b0%b1%ec%97%85-%eb%b0%8f-%eb%b3%b5%ec%9b%90-%eb%b0%a9%eb%b2%95","status":"publish","type":"post","link":"https:\/\/www.ocworld.net\/?p=362","title":{"rendered":"MS SQLserver 2005 \ubc31\uc5c5 \ubc0f \ubcf5\uc6d0 \ubc29\ubc95"},"content":{"rendered":"<p>\u00a0<strong><span style=\"font-size: 18pt;\">MS SQLserver 2005 \ubc31\uc5c5 \ubc0f \ubcf5\uc6d0 \ubc29\ubc95<\/span><\/strong>\u00a0<\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"font-size: 14pt;\"><strong>\ubc31\uc5c5<\/strong><\/span><\/p>\n<p>1. \uc6d0\ubcf8 \uc11c\ubc84\uc758 \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \uc120\ud0dd\ud55c \ud6c4 \ub9c8\uc6b0\uc2a4 \uc6b0\ud074\ub9ad\uc73c\ub85c &#8216;\uc791\uc5c5 &gt; \ubc31\uc5c5&#8230;&#8217;\uc744 \uc120\ud0dd\ud55c\ub2e4.<\/p>\n<p><a href=\"http:\/\/ocworld.net\/\/wp-content\/uploads\/2014\/08\/11.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-medium wp-image-363\" src=\"http:\/\/ocworld.net\/\/wp-content\/uploads\/2014\/08\/11-300x261.jpg\" alt=\"1\" width=\"300\" height=\"261\" srcset=\"https:\/\/www.ocworld.net\/wp-content\/uploads\/2014\/08\/11-300x261.jpg 300w, https:\/\/www.ocworld.net\/wp-content\/uploads\/2014\/08\/11.jpg 565w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/a><\/p>\n<p>2. &#8216;\uc6d0\ubcf8&#8217;\uc5d0\uc11c \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \ud655\uc778\ud55c \ud6c4 &#8216;\ubc31\uc5c5 \uc720\ud615&#8217;\uc5d0 \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \uc120\ud0dd\ud55c\ub2e4.<\/p>\n<p>&#8216;\ubc31\uc5c5 \uc138\ud2b8&#8217;\uc758 \uc774\ub984\uacfc \uc124\uba85\uc744 \uc791\uc131\ud55c\ub2e4.<\/p>\n<p>&#8216;\ub300\uc0c1&#8217;\uc5d0 \uae30\uc874\uc758 \uc704\uce58\uac00 \uc788\ub2e4\uba74 \uc81c\uac70\ub97c \ub20c\ub7ec \uc0ad\uc81c\ud55c\ub2e4.<\/p>\n<p><a href=\"http:\/\/ocworld.net\/\/wp-content\/uploads\/2014\/08\/21.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-medium wp-image-364\" src=\"http:\/\/ocworld.net\/\/wp-content\/uploads\/2014\/08\/21-297x300.jpg\" alt=\"2\" width=\"297\" height=\"300\" srcset=\"https:\/\/www.ocworld.net\/wp-content\/uploads\/2014\/08\/21-297x300.jpg 297w, https:\/\/www.ocworld.net\/wp-content\/uploads\/2014\/08\/21.jpg 573w\" sizes=\"auto, (max-width: 297px) 100vw, 297px\" \/><\/a><\/p>\n<p>3. &#8216;\ub300\uc0c1&#8217;\uc5d0\uc11c \ub514\uc2a4\ud06c\ub97c \uc120\ud0dd\ud55c \ud6c4 \ucd94\uac00\ub97c \ub20c\ub7ec \ubc31\uc5c5\ud560 \uc704\uce58\ub97c \uacb0\uc815\ud55c\ub2e4.<\/p>\n<p><a href=\"http:\/\/ocworld.net\/\/wp-content\/uploads\/2014\/08\/31.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-medium wp-image-365\" src=\"http:\/\/ocworld.net\/\/wp-content\/uploads\/2014\/08\/31-300x160.jpg\" alt=\"3\" width=\"300\" height=\"160\" srcset=\"https:\/\/www.ocworld.net\/wp-content\/uploads\/2014\/08\/31-300x160.jpg 300w, https:\/\/www.ocworld.net\/wp-content\/uploads\/2014\/08\/31.jpg 533w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/a><\/p>\n<p>4. \ub2e4 \ub9c8\uce5c \ud6c4 \ud655\uc778\uc744 \ub20c\ub7ec \ubc31\uc5c5\uc744 \uc2e4\ud589\ud55c\ub2e4.<\/p>\n<p>5.<span style=\"font-size: 14pt; color: #ff0000;\"><strong> (<\/strong><strong>\uc911\uc694<\/strong><strong>)<\/strong><strong>\ubc31\uc5c5 \uacf5\uac04 \ud655\ubcf4\uac00 \ud544\uc694\ud558\ub2e4<\/strong><strong>.<\/strong><\/span><\/p>\n<p>\u00a0\u00a0<\/p>\n<p><span style=\"font-size: 14pt;\"><strong>\ubcf5\uc6d0<\/strong><\/span><\/p>\n<p>1. \ub300\uc0c1 \uc11c\ubc84\uc758 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0\uc11c &#8216;\uc0c8\ub370\uc774\ud130\ubca0\uc774\uc2a4&#8230;&#8217;\ub85c \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \ub9cc\ub4e0\ub2e4.<\/p>\n<p><a href=\"http:\/\/ocworld.net\/\/wp-content\/uploads\/2014\/08\/41.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-medium wp-image-366\" src=\"http:\/\/ocworld.net\/\/wp-content\/uploads\/2014\/08\/41-300x190.jpg\" alt=\"4\" width=\"300\" height=\"190\" srcset=\"https:\/\/www.ocworld.net\/wp-content\/uploads\/2014\/08\/41-300x190.jpg 300w, https:\/\/www.ocworld.net\/wp-content\/uploads\/2014\/08\/41.jpg 578w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/a><\/p>\n<p>2. \ub300\uc0c1 \uc11c\ubc84\uc758 \uc0c8 \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \ub9c8\uc6b0\uc2a4 \uc6b0\ud074\ub9ad\uc73c\ub85c \uc791\uc5c5 &gt; \ub370\uc774\ud130\ubca0\uc774\uc2a4 \ubcf5\uc6d0\uc744 \ud074\ub9ad\ud55c\ub2e4.<\/p>\n<p>3. \ubcf5\uc6d0\ud560 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc774\ub984\uc744 \uc801\uc740 \ud6c4\uc5d0 &#8216;\uc7a5\uce58&#8217;\ub97c \uc120\ud0dd\ud558\uace0 &#8216;&#8230;&#8217;\uc744 \ud074\ub9ad\ud55c\ub2e4.<\/p>\n<p><a href=\"http:\/\/ocworld.net\/\/wp-content\/uploads\/2014\/08\/51.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-medium wp-image-367\" src=\"http:\/\/ocworld.net\/\/wp-content\/uploads\/2014\/08\/51-300x129.jpg\" alt=\"5\" width=\"300\" height=\"129\" srcset=\"https:\/\/www.ocworld.net\/wp-content\/uploads\/2014\/08\/51-300x129.jpg 300w, https:\/\/www.ocworld.net\/wp-content\/uploads\/2014\/08\/51-660x284.jpg 660w, https:\/\/www.ocworld.net\/wp-content\/uploads\/2014\/08\/51.jpg 714w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/a><\/p>\n<p>4. \ucd94\uac00\ubc84\ud2bc\uc744 \ub20c\ub7ec\uc11c \ubc31\uc5c5 \ud30c\uc77c\uc744 \uc77d\uc5b4\uc628 \ud6c4 \ud655\uc778\uc744 \ud074\ub9ad\ud55c\ub2e4.<\/p>\n<p><a href=\"http:\/\/ocworld.net\/\/wp-content\/uploads\/2014\/08\/61.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-medium wp-image-368\" src=\"http:\/\/ocworld.net\/\/wp-content\/uploads\/2014\/08\/61-300x193.jpg\" alt=\"6\" width=\"300\" height=\"193\" srcset=\"https:\/\/www.ocworld.net\/wp-content\/uploads\/2014\/08\/61-300x193.jpg 300w, https:\/\/www.ocworld.net\/wp-content\/uploads\/2014\/08\/61-660x426.jpg 660w, https:\/\/www.ocworld.net\/wp-content\/uploads\/2014\/08\/61.jpg 706w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/a><\/p>\n<p>5. \ubcf5\uc6d0 \ub300\uc0c1\uc758 \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \ud655\uc778\ud55c \ud6c4, \ubcf5\uc6d0\uc5d0 \uc0ac\uc6a9\ud560 \ubc31\uc5c5 \uc138\ud2b8 \ud56d\ubaa9\uc5d0\uc11c \ubaa9\ub85d\uc744 \uccb4\ud06c\ud55c\ub2e4.<\/p>\n<p><a href=\"http:\/\/ocworld.net\/\/wp-content\/uploads\/2014\/08\/71.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-medium wp-image-369\" src=\"http:\/\/ocworld.net\/\/wp-content\/uploads\/2014\/08\/71-300x126.jpg\" alt=\"7\" width=\"300\" height=\"126\" srcset=\"https:\/\/www.ocworld.net\/wp-content\/uploads\/2014\/08\/71-300x126.jpg 300w, https:\/\/www.ocworld.net\/wp-content\/uploads\/2014\/08\/71-660x279.jpg 660w, https:\/\/www.ocworld.net\/wp-content\/uploads\/2014\/08\/71.jpg 773w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/a><\/p>\n<p>6. \uc88c\uce21 \ud398\uc774\uc9c0 \uc120\ud0dd\uc5d0\uc11c \uc635\uc158\uc744 \ud074\ub9ad\ud55c \ud6c4, &#8216;\uae30\uc874 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \ub36e\uc5b4\uc4f0\uae30&#8217;\ub97c \uccb4\ud06c\ud55c \ud6c4 \ud655\uc778\uc744 \ud074\ub9ad\ud55c\ub2e4.<\/p>\n<p><a href=\"http:\/\/ocworld.net\/\/wp-content\/uploads\/2014\/08\/8.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-medium wp-image-370\" src=\"http:\/\/ocworld.net\/\/wp-content\/uploads\/2014\/08\/8-300x166.jpg\" alt=\"8\" width=\"300\" height=\"166\" srcset=\"https:\/\/www.ocworld.net\/wp-content\/uploads\/2014\/08\/8-300x166.jpg 300w, https:\/\/www.ocworld.net\/wp-content\/uploads\/2014\/08\/8-660x366.jpg 660w, https:\/\/www.ocworld.net\/wp-content\/uploads\/2014\/08\/8.jpg 811w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/a><br \/>7. <strong><span style=\"color: #ff0000; font-size: 14pt;\">\uc804\uccb4 \ubc31\uc5c5\uacfc \ucc28\ub4f1 \ubcf5\uc6d0, \ud2b8\ub79c\uc7ad\uc158 \ubcf5\uc6d0 \uc14b\ud2b8\ub85c \ubcf5\uc6d0\ud560 \uacbd\uc6b0\uc5d0 \uc804\uccb4 \ubcf5\uc6d0\uc744 \uba3c\uc800 \ucc98\ub9ac\ud55c \ud6c4 \ucc28\ub4f1\uacfc \ud2b8\ub79c\uc7ad\uc158\uc744 \ucc98\ub9ac\ud55c\ub2e4. <\/span><\/strong><\/p>\n<p><strong><span style=\"color: #ff0000; font-size: 14pt;\">\uc804\uccb4 \ubcf5\uc6d0\uc744 \ucc98\ub9ac\ud560 \uacbd\uc6b0\uc5d0\u00a0 &#8216;\ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \ube44\uc791\ub3d9 \uc0c1\ud0dc\ub85c \uc720\uc9c0\ud558\uace0 \ucee4\ubc0b\ub418\uc9c0 \uc54a\uc740 \ud2b8\ub79c\uc7ad\uc158\uc744 \ub864\ubc31\ud558\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4.~~~(Restore With NonRecovery)&#8217;\ub97c \uc120\ud0dd\ud55c \ud6c4 \ubc31\uc5c5\ud55c\ub2e4.<\/span><\/strong><\/p>\n<p><strong><span style=\"color: #ff0000; font-size: 14pt;\">\uc774\ud6c4\uc758 \ucc28\ub4f1\uacfc \ud2b8\ub79c\uc7ad\uc158 \ubc31\uc5c5\uc740 \uc544\ubb34\ub7f0 \uc635\uc158\uc744 \uc120\ud0dd\ud558\uc9c0 \uc54a\uace0 \ubcf5\uc6d0\ud558\uba74 \ub41c\ub2e4.<\/span><\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u00a0MS SQLserver 2005 \ubc31\uc5c5 \ubc0f \ubcf5\uc6d0 \ubc29\ubc95\u00a0 &nbsp; \ubc31\uc5c5 1. \uc6d0\ubcf8 \uc11c\ubc84\uc758 \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \uc120\ud0dd\ud55c \ud6c4 \ub9c8\uc6b0\uc2a4 \uc6b0\ud074\ub9ad\uc73c\ub85c &#8216;\uc791\uc5c5 &gt; \ubc31\uc5c5&#8230;&#8217;\uc744 \uc120\ud0dd\ud55c\ub2e4. 2. &#8216;\uc6d0\ubcf8&#8217;\uc5d0\uc11c \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \ud655\uc778\ud55c \ud6c4 &#8216;\ubc31\uc5c5 \uc720\ud615&#8217;\uc5d0 \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \uc120\ud0dd\ud55c\ub2e4. &#8216;\ubc31\uc5c5 \uc138\ud2b8&#8217;\uc758 \uc774\ub984\uacfc \uc124\uba85\uc744 \uc791\uc131\ud55c\ub2e4. &#8216;\ub300\uc0c1&#8217;\uc5d0 \uae30\uc874\uc758 \uc704\uce58\uac00 \uc788\ub2e4\uba74 \uc81c\uac70\ub97c \ub20c\ub7ec \uc0ad\uc81c\ud55c\ub2e4. 3. &#8216;\ub300\uc0c1&#8217;\uc5d0\uc11c \ub514\uc2a4\ud06c\ub97c \uc120\ud0dd\ud55c \ud6c4 \ucd94\uac00\ub97c \ub20c\ub7ec \ubc31\uc5c5\ud560 \uc704\uce58\ub97c \uacb0\uc815\ud55c\ub2e4. 4. \ub2e4 \ub9c8\uce5c [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[7],"tags":[],"class_list":["post-362","post","type-post","status-publish","format-standard","hentry","category-info"],"_links":{"self":[{"href":"https:\/\/www.ocworld.net\/index.php?rest_route=\/wp\/v2\/posts\/362","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.ocworld.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.ocworld.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.ocworld.net\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.ocworld.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=362"}],"version-history":[{"count":2,"href":"https:\/\/www.ocworld.net\/index.php?rest_route=\/wp\/v2\/posts\/362\/revisions"}],"predecessor-version":[{"id":372,"href":"https:\/\/www.ocworld.net\/index.php?rest_route=\/wp\/v2\/posts\/362\/revisions\/372"}],"wp:attachment":[{"href":"https:\/\/www.ocworld.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=362"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.ocworld.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=362"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.ocworld.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=362"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}