{"id":1635,"date":"2022-06-12T19:39:50","date_gmt":"2022-06-12T10:39:50","guid":{"rendered":"https:\/\/manvscloud.com\/?p=1635"},"modified":"2022-10-25T20:46:32","modified_gmt":"2022-10-25T11:46:32","slug":"ncp-cloud-db-for-mssql%ec%9d%98-%eb%aa%a8%eb%93%a0-%ea%b2%83","status":"publish","type":"post","link":"https:\/\/manvscloud.com\/?p=1635","title":{"rendered":"[NCLOUD] Cloud DB for MSSQL\uc758 \ubaa8\ub4e0 \uac83"},"content":{"rendered":"\n<p>\uc548\ub155\ud558\uc138\uc694 ManVSCloud \uae40\uc218\ud604\uc785\ub2c8\ub2e4.<\/p>\n\n\n\n<p>\uae08\uc77c \ud3ec\uc2a4\ud305\uc740 Cloud DB for MSSQL\uc5d0 \ub300\ud574 \ubaa8\ub450 \uc54c\uc544\ubcf4\ub294 \uac83\uc744 \ubaa9\ud45c\ub85c \ud3ec\uc2a4\ud305\ud574\ubcf4\uc558\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-css-opacity\"\/>\n\n\n\n<h3 class=\"has-white-color has-vivid-green-cyan-background-color has-text-color has-background wp-block-heading\"> Cloud DB for MSSQL <\/h3>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"895\" height=\"145\" src=\"https:\/\/cdn.manvscloud.com\/wp-content\/uploads\/2022\/06\/11141907\/cloud-db-for-mssql-2.png\" alt=\"\" class=\"wp-image-1664\" srcset=\"https:\/\/cdn.manvscloud.com\/wp-content\/uploads\/2022\/06\/11141907\/cloud-db-for-mssql-2.png 895w, https:\/\/cdn.manvscloud.com\/wp-content\/uploads\/2022\/06\/11141907\/cloud-db-for-mssql-2-300x49.png 300w, https:\/\/cdn.manvscloud.com\/wp-content\/uploads\/2022\/06\/11141907\/cloud-db-for-mssql-2-768x124.png 768w\" sizes=\"(max-width: 895px) 100vw, 895px\" \/><\/figure>\n\n\n\n<p>Cloud DB for MSSQL\uc740 \uc644\uc804 \uad00\ub9ac\ud615 \uc11c\ube44\uc2a4\uc785\ub2c8\ub2e4.<br>\uc644\uc804 \uad00\ub9ac\ud615 \uc11c\ube44\uc2a4\ub780 \ubb34\uc5c7\uc774\ub0d0? \ub124\uc774\ubc84 \ud074\ub77c\uc6b0\ub4dc \ud50c\ub7ab\ud3fc\uc5d0\uc11c \uc7a5\ube44, OS \uc124\uce58 \ubc0f \ub370\uc774\ud130 \ubca0\uc774\uc2a4 \uc194\ub8e8\uc158 \uc124\uce58 \ub4f1\uc744 \ubaa8\ub450 \uad00\ub9ac\ud558\uac8c \ub429\ub2c8\ub2e4. <\/p>\n\n\n\n<p>\uad00\ub9ac\ud615\uacfc \uc644\uc804 \uad00\ub9ac\ud615\uc758 \ucc28\uc774? : \uad00\ub9ac\ud615\uc740 \ub124\uc774\ubc84 \ud074\ub77c\uc6b0\ub4dc \ud50c\ub7ab\ud3fc\uc758 Server, \uc644\uc804 \uad00\ub9ac\ud615\uc740 Cloud DB for MSSQL\uc774\ub77c\uace0 \ud558\uba74 \uc5b4\ub5a4 \ucc28\uc774\uac00 \uc788\ub294\uc9c0 \uc26c\uc6b8 \uac83\uac19\uc2b5\ub2c8\ub2e4.<br>\ub458 \ub2e4 \ubb3c\ub9ac\uc801 \uc7a5\ube44\uc640 OS\ub97c \uc81c\uacf5\ud558\uace0 \uad00\ub9ac\ud558\uc9c0\ub9cc Server\ub294 DB\uc640 \uac19\uc740 \uc194\ub8e8\uc158\uc740 \uc0ac\uc6a9\uc790\uac00 \uc9c1\uc811 \uc124\uce58\ud558\uace0 \uad00\ub9ac\ud574\uc57c\ud558\uba70 \ubc31\uc5c5\uc774\ub098 \uac00\uc6a9\uc131 \ub4f1\uc5d0 \ub300\ud574 \ubaa8\ub450 \uad00\ub9ac\ud574\uc57c\ud569\ub2c8\ub2e4.<br>\ub2e4\ub9cc \uc644\uc804 \uad00\ub9ac\ud615\uc740 DB\uc194\ub8e8\uc158\uc774 \uc774\ubbf8 \uc124\uce58\ub41c \uc0c1\ud488\uc774\uace0 \ubc31\uc5c5\uc774\ub098 \uace0\uac00\uc6a9\uc131 \uae30\ub2a5\uc774 \uc788\uc5b4 \uc120\ud0dd\ub9cc\ud558\uba74 \ub429\ub2c8\ub2e4. <\/p>\n\n\n\n<ul><li>\ub370\uc774\ud130\ubca0\uc774\uc2a4 \ucd5c\uc801\ud654 \uc124\uc815<\/li><li>\ubaa8\ub2c8\ud130\ub9c1\uacfc \uc54c\ub78c<\/li><li>\ub370\uc774\ud130 \uc790\ub3d9 \ubc31\uc5c5 \uc9c0\uc6d0<\/li><li>\uc6a9\uc774\ud55c \ucffc\ub9ac \ubd84\uc11d<\/li><li>2TB\uae4c\uc9c0 \uc790\ub3d9 \uc99d\uac00\ud558\ub294 \ub370\uc774\ud130 \uc2a4\ud1a0\ub9ac\uc9c0<\/li><li>\uc790\ub3d9 \ud398\uc77c\uc624\ubc84(Failover) \uae30\ubcf8 \uc81c\uacf5<\/li><li>\uc77d\uae30 \uc2ac\ub808\uc774\ube0c(Slave) \uc11c\ubc84 \uc81c\uacf5<\/li><\/ul>\n\n\n\n<p>VPC \uae30\uc900 \ub77c\uc774\uc13c\uc2a4\ub294 <strong>Standard Edition, Enterprise Edition<\/strong>\uc744 \uc9c0\uc6d0\ud558\uace0 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<p><strong><span class=\"has-inline-color has-vivid-cyan-blue-color\">\u2193 \ubbfc\uac04\uc6a9 Cloud DB for MSSQL \ub9c1\ud06c<\/span><\/strong><\/p>\n\n\n<div class=\"vlp-link-container vlp-layout-basic wp-block-visual-link-preview-link\"><a href=\"https:\/\/guide.ncloud-docs.com\/docs\/database-database-9-1\" class=\"vlp-link\" title=\"\ud035\uc2a4\ud0c0\ud2b8 \uac00\uc774\ub4dc - Cloud DB for MSSQL\" rel=\"nofollow\" target=\"_blank\"><\/a><div class=\"vlp-layout-zone-side\"><div class=\"vlp-block-2 vlp-link-image\"><img decoding=\"async\" src=\"https:\/\/cdn.document360.io\/6998976f-9d95-4df8-b847-d375892b92c2\/Images\/Documentation\/ncp-manual-logo-ko-v2.svg\" style=\"max-width: 150px; max-height: 150px\" \/><\/div><\/div><div class=\"vlp-layout-zone-main\"><div class=\"vlp-block-0 vlp-link-title\">\ud035\uc2a4\ud0c0\ud2b8 \uac00\uc774\ub4dc &#8211; Cloud DB for MSSQL<\/div><div class=\"vlp-block-1 vlp-link-summary\">Q. Cloud DB for MSSQL \uc11c\ubc84\uc5d0 \uc5b4\ub5bb\uac8c \uc811\uadfc\ud558\ub098\uc694?<\/div><\/div><\/div>\n\n\n<p><strong><span class=\"has-inline-color has-luminous-vivid-orange-color\">\u2193 \uae08\uc735 Cloud DB for MSSQL \ub9c1\ud06c<\/span><\/strong><\/p>\n\n\n<div class=\"vlp-link-container vlp-layout-basic wp-block-visual-link-preview-link\"><a href=\"https:\/\/guide-fin.ncloud-docs.com\/docs\/database-cdbmssql-cdbmssqlquickstart\" class=\"vlp-link\" title=\"\ud035\uc2a4\ud0c0\ud2b8 \uac00\uc774\ub4dc - Cloud DB for MSSQL\" rel=\"nofollow\" target=\"_blank\"><\/a><div class=\"vlp-layout-zone-side\"><div class=\"vlp-block-2 vlp-link-image\"><img decoding=\"async\" src=\"https:\/\/cdn.document360.io\/logo\/0406ed95-101f-4cde-8dd8-308d03444a94\/def3869d00c249c18f6d5831d61869d5-ncp-fin-manual-logo-ko-v2.svg\" style=\"max-width: 150px; max-height: 150px\" \/><\/div><\/div><div class=\"vlp-layout-zone-main\"><div class=\"vlp-block-0 vlp-link-title\">\ud035\uc2a4\ud0c0\ud2b8 \uac00\uc774\ub4dc &#8211; Cloud DB for MSSQL<\/div><div class=\"vlp-block-1 vlp-link-summary\">Q. Cloud DB for MSSQL \uc11c\ubc84\uc5d0 \uc5b4\ub5bb\uac8c \uc811\uadfc\ud558\ub098\uc694?<\/div><\/div><\/div>\n\n\n<hr class=\"wp-block-separator has-css-opacity\"\/>\n\n\n\n<h3 class=\"has-white-color has-vivid-cyan-blue-background-color has-text-color has-background wp-block-heading\"> Functional Check<\/h3>\n\n\n\n<h4 class=\"wp-block-heading\">\u203b DB Server \ud0c0\uc785<\/h4>\n\n\n\n<p>\u2014 \ucd08\uae30 \uc0dd\uc131 \uc2dc <span class=\"has-inline-color has-vivid-cyan-blue-color\"><strong>Standard \/ High Memory<\/strong><\/span> \uc120\ud0dd \ud6c4 DB \uc2a4\ud399 \ubcc0\uacbd \uc2dc \ucc98\uc74c \uc120\ud0dd\ud55c \ud0c0\uc785\uc5d0\uc11c\ub9cc \uc2a4\ud399 \ubcc0\uacbd\uc774 \uac00\ub2a5\ud569\ub2c8\ub2e4. <br><span class=\"has-inline-color has-vivid-cyan-blue-color\">(Standard \uc120\ud0dd \uc2dc Standard \ud06c\uae30\uc5d0\uc11c\ub9cc \ubcc0\uacbd \uac00\ub2a5, High Memory, High CPU\ub85c \ubcc0\uacbd \ubd88\uac00)<\/span><\/p>\n\n\n\n<div style=\"height:30px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h4 class=\"wp-block-heading\">\u203b \uc7ac\uc2dc\uc791 (Failover)<\/h4>\n\n\n\n<p><strong>\u2014<\/strong> <strong>Without FailOver<\/strong> <br>(NCP \uc124\uba85 : SSMS \ub85c \uc124\uc815\ud55c \ub0b4\uc6a9\uc774 \uadf8\ub300\ub85c \ubcf4\uc7a5\ub418\uc9c0\ub9cc, service down time \uc774 \uae41\ub2c8\ub2e4. (\uba87 \ubd84 \uc774\uc0c1))<\/p>\n\n\n\n<p><strong>\u2014<\/strong> <strong>With FailOver<\/strong> : <span class=\"has-inline-color has-vivid-cyan-blue-color\">\uace0\uac00\uc6a9\uc131\uc774 \uc544\ub2cc \ub2e8\uc77c \uad6c\uc131\uc740 With FailOver \uae30\ub2a5\uc744 \uc0ac\uc6a9\ud560 \uc218 \uc5c6\uc2b5\ub2c8\ub2e4.<\/span><br>(NCP \uc124\uba85 : service down time \uc774 \uc9e7\uc9c0\ub9cc(30\ucd08\uc774\ub0b4), \uc0ac\uc6a9\uc790\uaed8\uc11c SSMS\ub85c \uc124\uc815\ud55c \ub0b4\uc6a9\uc774 \uc720\uc2e4 \ub420 \uc218 \uc788\uc2b5\ub2c8\ub2e4.)<\/p>\n\n\n\n<p><strong>\u2014<\/strong> \uc11c\ubc84\uc7a5\uc560\ub4f1\uc73c\ub85c \uc790\ub3d9 \uc870\uce58\uc911\uc774\uba74, failover \ubc0f \uc7ac\ubd80\ud305\uc774 \uc9c4\ud589\ub418\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<figure class=\"wp-block-gallery has-nested-images columns-default is-cropped wp-block-gallery-1 is-layout-flex wp-block-gallery-is-layout-flex\">\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"400\" data-id=\"1654\" src=\"https:\/\/cdn.manvscloud.com\/wp-content\/uploads\/2022\/06\/11131649\/failover_test01-1-1024x400.png\" alt=\"\" class=\"wp-image-1654\" srcset=\"https:\/\/cdn.manvscloud.com\/wp-content\/uploads\/2022\/06\/11131649\/failover_test01-1-1024x400.png 1024w, https:\/\/cdn.manvscloud.com\/wp-content\/uploads\/2022\/06\/11131649\/failover_test01-1-300x117.png 300w, https:\/\/cdn.manvscloud.com\/wp-content\/uploads\/2022\/06\/11131649\/failover_test01-1-768x300.png 768w, https:\/\/cdn.manvscloud.com\/wp-content\/uploads\/2022\/06\/11131649\/failover_test01-1-1536x600.png 1536w, https:\/\/cdn.manvscloud.com\/wp-content\/uploads\/2022\/06\/11131649\/failover_test01-1-1080x422.png 1080w, https:\/\/cdn.manvscloud.com\/wp-content\/uploads\/2022\/06\/11131649\/failover_test01-1.png 1544w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><figcaption>\uc815\uc0c1<\/figcaption><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"842\" height=\"710\" data-id=\"1655\" src=\"https:\/\/cdn.manvscloud.com\/wp-content\/uploads\/2022\/06\/11131650\/failover_test02-1.png\" alt=\"\" class=\"wp-image-1655\" srcset=\"https:\/\/cdn.manvscloud.com\/wp-content\/uploads\/2022\/06\/11131650\/failover_test02-1.png 842w, https:\/\/cdn.manvscloud.com\/wp-content\/uploads\/2022\/06\/11131650\/failover_test02-1-300x253.png 300w, https:\/\/cdn.manvscloud.com\/wp-content\/uploads\/2022\/06\/11131650\/failover_test02-1-768x648.png 768w\" sizes=\"(max-width: 842px) 100vw, 842px\" \/><figcaption>\uc11c\ube44\uc2a4 \ub2e4\uc6b4<\/figcaption><\/figure>\n<figcaption class=\"blocks-gallery-caption\">Failover \uc2dc \uc77c\uc2dc\uc801\uc73c\ub85c \uc11c\ube44\uc2a4 \ub2e4\uc6b4\uc774 \ubc1c\uc0dd<\/figcaption><\/figure>\n\n\n\n<div style=\"height:20px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<figure class=\"wp-block-pullquote\"><blockquote><p>\ud14c\uc2a4\ud2b8 \uacb0\uacfc : <\/p><cite>\ud14c\uc2a4\ud2b8 \uc9c4\ud589 \uc2dc Without FailOver, With FailOver \ub458 \ub2e4 <strong>&#8220;\uc7ac\ubd80\ud305\uc911 &#8211; \uc124\uc815\uc911 &#8211; \uc6b4\uc601\uc911&#8221;<\/strong> \ubaa8\ub4e0 \uacfc\uc815\uc5d0 \uc18c\uc694\ub418\ub294 \uc2dc\uac04\uc774 6\ubd84 \uc774\uc0c1 \uc18c\uc694\ub418\uc5c8\uc73c\uba70 \ub450 \ubc29\uc2dd \ub3d9\uc77c\ud558\uac8c 1\ubd84 \uac00\ub7c9 1\ud68c\uc758 Service Down\uc774 \ubc1c\uc0dd\ub418\uc5c8\uc2b5\ub2c8\ub2e4. <br>(\uba87\ud68c \uc2dc\ub3c4\uc2dc \ud574\ub2f9 \uc11c\ube44\uc2a4 \ub2e4\uc6b4 \uc774\ud6c4 \uc77c\uc2dc\uc801\uc73c\ub85c \ucd94\uac00\uc801\uc778 10\ucd08 \uac00\ub7c9\uc758 Service Down\ub3c4 \uc788\uc5c8\uc2b5\ub2c8\ub2e4.) <br><br>&#8220;\uc2e4\uc6b4\uc601 \ubc0f \ub370\uc774\ud130 \uc99d\uac00 \uc2dc\uc5d0\ub294 \ubc29\uc2dd\uc5d0 \ub530\ub77c \uc2dc\uac04 \ucc28\uc774\uac00 \uc788\uc744 \uac83\uc73c\ub85c \ubcf4\uc5ec\uc9d1\ub2c8\ub2e4.&#8221; <br><br><strong>\u2192<\/strong> <strong>&#8216;Without FailOver&#8217; \ubc29\uc2dd\uc73c\ub85c \uc9c4\ud589\ub420 \uacbd\uc6b0 <\/strong><br>[Cloud Activity Tracer] \uc791\uc5c5 \ub0b4\uc5ed\uc5d0 &#8220;Restart DB Server&#8221;\ub85c \ub85c\uadf8\uac00 \ub0a8\uc2b5\ub2c8\ub2e4. <br><br><strong>\u2192 &#8216;With FailOver&#8217; \ubc29\uc2dd\uc73c\ub85c \uc9c4\ud589\ub420 \uacbd\uc6b0 <\/strong><br>[Cloud Activity Tracer] \uc791\uc5c5 \ub0b4\uc5ed\uc5d0 &#8220;Restart DB Service With Failover&#8221;, &#8220;Switch to Mirror DB Server Due to Failover&#8221;, &#8220;Switch to Principal DB Server Due to Failover&#8221;\uc758 \ub85c\uadf8\uac00 \ub0a8\uc2b5\ub2c8\ub2e4. <br>(Cloud Activity Tracer\uc5d0 \ub0a8\ub294 \ub85c\uadf8\ub294 \uc7ac\uc2dc\uc791 \uc2dc \ub85c\uadf8\uac00 \uc544\ub2c8\ub77c \uc7ac\uc2dc\uc791 \ud6c4 \uc815\uc0c1 \uc6b4\uc601\uc911 \uc0c1\ud0dc\uac00 \ub418\uc5c8\uc744 \ub54c \ub85c\uadf8\uc5d0 \ub0a8\uac8c\ub429\ub2c8\ub2e4.) <br><br><strong>\u2192 \uc7a5\uc560\ub85c \uc778\ud55c FailOver\uc758 \uacbd\uc6b0\uc5d0\ub294 Event\uc5d0\uc11c FailOver\ucabd\uc73c\ub85c \ucd94\uac00 \ud655\uc778\uc774 \ud544\uc694\ud574\ubcf4\uc785\ub2c8\ub2e4.<\/strong><\/cite><\/blockquote><\/figure>\n\n\n\n<div style=\"height:15px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<ul><li><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-vivid-red-color\">SQL Server Management Studio(SSMS)\ub97c \uc774\uc6a9\ud558\uac70\ub098 \uc9c1\uc811 \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \uc0dd\uc131\ud558\ub294 \uacbd\uc6b0 \uc635\uc158\uc5d0\uc11c \ubcf5\uad6c \ubaa8\ub378\uc744 \uc804\uccb4(full)\ub85c \uc120\ud0dd\ud574\uc57c \ubbf8\ub7ec\ub9c1(Mirroring) \uad6c\uc131\uc774 \uac00\ub2a5<\/mark><br>(\ubcf5\uad6c \ubaa8\ub378\uc774 Full\uc774 \uc544\ub2d0 \uacbd\uc6b0 \uc790\ub3d9 Failover\uc5d0 \ubb38\uc81c\uac00 \ubc1c\uc0dd\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.)<\/li><\/ul>\n\n\n\n<p>\u2014 Cloud DB for MSSQL\uc5d0\uc11c \uc790\ub3d9\uc73c\ub85c \ubbf8\ub7ec\ub9c1 \ud65c\uc131\ud654\ub41c \ud6c4\uc5d0\ub294 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \ubbf8\ub7ec\ub9c1\uc744 \uc81c\uac70\ud558\uc9c0 \uc54a\uc73c\uba74 CLI\uc5d0\uc11c\ub294 \uc9c1\uc811\uc801\uc73c\ub85c \ub370\uc774\ud130\ubca0\uc774\uc2a4\uac00 \uc0ad\uc81c\ub418\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">1> USE master;\n2> GO\n3> DROP DATABASE test1;\n4> GO<\/pre>\n\n\n\n<div style=\"height:15px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<figure class=\"wp-block-pullquote\"><blockquote><p>\ubbf8\ub7ec\ub9c1\uc774 \uc9c4\ud589\ub41c Database \uc0ad\uc81c \uc2dc \ubc1c\uc0dd\ud558\ub294 \uc5d0\ub7ec <\/p><cite>m-11181583-002) Msg 3743 (severity 16, state 1) from M-11181583-002 Line 1: &#8220;The database &#8216;test1&#8217; is enabled for database mirroring. Database mirroring must be removed before you drop the database.&#8221; <br><br><span class=\"has-inline-color has-cyan-bluish-gray-color\">\/\/ FailOver \ud6c4 Database DROP \uc2dc\ub3c4<\/span> <br>m-11181583-001) Msg 3743 (severity 16, state 1) from M-11181583-001 Line 1: &#8220;The database &#8216;test1&#8217; is enabled for database mirroring. Database mirroring must be removed before you drop the database.&#8221;<\/cite><\/blockquote><\/figure>\n\n\n\n<p><em><strong>\u2192 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc0ad\uc81c \ubc29\ubc95 :<\/strong><span class=\"has-inline-color has-vivid-cyan-blue-color\"> [\ucf58\uc194] &#8211; &#8220;Cloud DB for MSSQL \/ DB Server&#8221; &#8211; [DB \uad00\ub9ac] &#8211; [Database\uad00\ub9ac]<\/span> \uc5d0\uc11c DB\ub97c \uc0ad\uc81c\ud574\uc8fc\uba74 \uc815\uc0c1 \uc0ad\uc81c\uac00 \ub429\ub2c8\ub2e4.<\/em><\/p>\n\n\n\n<div style=\"height:30px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h4 class=\"wp-block-heading\">\u203b Slave<\/h4>\n\n\n\n<ul><li><strong>&#8220;Slave \uc11c\ubc84\ub294 24\uc2dc\uac04 \uc77d\uae30\uac00 \uac00\ub2a5\ud558\uc9c0 \uc54a\uae30\ub54c\ubb38\uc5d0 \uc77d\uae30 \uac00\ub2a5 \uc2dc\uac04\ub300\ub97c \uc124\uc815\ud558\uc5ec \uc0ac\uc6a9\ud574\uc57c\ud569\ub2c8\ub2e4.<span class=\"has-inline-color has-cyan-bluish-gray-color\"> (batch \ubc0f BI \ub4f1\uc758 \ubaa9\uc801\uc5d0 \uc801\ud569)<\/span>&#8220;<\/strong><\/li><\/ul>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"867\" height=\"520\" src=\"https:\/\/cdn.manvscloud.com\/wp-content\/uploads\/2022\/06\/11135411\/slave.png\" alt=\"\" class=\"wp-image-1660\" srcset=\"https:\/\/cdn.manvscloud.com\/wp-content\/uploads\/2022\/06\/11135411\/slave.png 867w, https:\/\/cdn.manvscloud.com\/wp-content\/uploads\/2022\/06\/11135411\/slave-300x180.png 300w, https:\/\/cdn.manvscloud.com\/wp-content\/uploads\/2022\/06\/11135411\/slave-768x461.png 768w\" sizes=\"(max-width: 867px) 100vw, 867px\" \/><\/figure>\n\n\n\n<p>\u2014 \ucd5c\ub300 5\uac1c\uae4c\uc9c0 \uc0dd\uc131 \uac00\ub2a5<br>\u2014 \ucd5c\ub300 20\uc2dc\uac04\uae4c\uc9c0 \uc124\uc815 \uac00\ub2a5<br>\u2014 \uc124\uc815\ud55c \uc77d\uae30 \uac00\ub2a5 \uc2dc\uac04\ub300\uc5d0\ub294 data sync\uac00 \ub418\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4.<br>\u2014 Slave\uc758 spec\uc744 \ubcc0\uacbd\ud558\uba74 Principal\uc640 Mirror \uc11c\ubc84\uc758 \uc2a4\ud399\ub3c4 \ud568\uaed8 \ubcc0\uacbd\ub429\ub2c8\ub2e4.<\/p>\n\n\n\n<div style=\"height:30px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h4 class=\"wp-block-heading\">\u203b Monitoring<\/h4>\n\n\n\n<p>\ud574\ub2f9 Monitoring\uc740 Cloud DB for MSSQL \uc11c\ube44\uc2a4\uc5d0 \ud3ec\ud568\ub418\uc5b4\uc788\ub294 \uc11c\ube44\uc2a4\ub77c \ucd94\uac00\uc801\uc778 \ube44\uc6a9\uc774 \ubc1c\uc0dd\ud558\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"377\" src=\"https:\/\/cdn.manvscloud.com\/wp-content\/uploads\/2022\/06\/11143230\/monitoring-dashboard-1024x377.png\" alt=\"\" class=\"wp-image-1665\" srcset=\"https:\/\/cdn.manvscloud.com\/wp-content\/uploads\/2022\/06\/11143230\/monitoring-dashboard-1024x377.png 1024w, https:\/\/cdn.manvscloud.com\/wp-content\/uploads\/2022\/06\/11143230\/monitoring-dashboard-300x111.png 300w, https:\/\/cdn.manvscloud.com\/wp-content\/uploads\/2022\/06\/11143230\/monitoring-dashboard-768x283.png 768w, https:\/\/cdn.manvscloud.com\/wp-content\/uploads\/2022\/06\/11143230\/monitoring-dashboard-1536x566.png 1536w, https:\/\/cdn.manvscloud.com\/wp-content\/uploads\/2022\/06\/11143230\/monitoring-dashboard-2048x755.png 2048w, https:\/\/cdn.manvscloud.com\/wp-content\/uploads\/2022\/06\/11143230\/monitoring-dashboard-1080x398.png 1080w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>\uccab\ubc88\uc9f8 DB Dashboard \ud398\uc774\uc9c0\uc5d0\uc11c\ub294 CPU \uc0ac\uc6a9\ub960, \ubd84\ub2f9 \uc2e4\ud589\ub41c \ucffc\ub9ac \ud69f\uc218, \ucffc\ub9ac \uc218\ud589 \ud69f\uc218 \ub300\ube44 CPU \uc18c\ubaa8\ub7c9 \ubc0f \uba54\ubaa8\ub9ac \uc77d\uae30 \uc218\ub97c \ubcf4\uc5ec\uc8fc\ub294 \ud398\uc774\uc9c0 \uc785\ub2c8\ub2e4.<\/p>\n\n\n\n<p>\uc870\uae08 \ub354 \uc138\ubd80\uc801\uc778 \ubaa8\ub2c8\ud130\ub9c1\uc744 \uc6d0\ud558\uc2dc\ub294 \uacbd\uc6b0 Performance \ud0ed\uc744 \ud074\ub9ad\ud558\uc5ec \ubcfc \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<figure class=\"wp-block-gallery has-nested-images columns-default is-cropped wp-block-gallery-2 is-layout-flex wp-block-gallery-is-layout-flex\">\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"396\" data-id=\"1668\" src=\"https:\/\/cdn.manvscloud.com\/wp-content\/uploads\/2022\/06\/11143254\/monitoring-per-1024x396.png\" alt=\"\" class=\"wp-image-1668\" srcset=\"https:\/\/cdn.manvscloud.com\/wp-content\/uploads\/2022\/06\/11143254\/monitoring-per-1024x396.png 1024w, https:\/\/cdn.manvscloud.com\/wp-content\/uploads\/2022\/06\/11143254\/monitoring-per-300x116.png 300w, https:\/\/cdn.manvscloud.com\/wp-content\/uploads\/2022\/06\/11143254\/monitoring-per-768x297.png 768w, https:\/\/cdn.manvscloud.com\/wp-content\/uploads\/2022\/06\/11143254\/monitoring-per-1536x594.png 1536w, https:\/\/cdn.manvscloud.com\/wp-content\/uploads\/2022\/06\/11143254\/monitoring-per-1080x418.png 1080w, https:\/\/cdn.manvscloud.com\/wp-content\/uploads\/2022\/06\/11143254\/monitoring-per.png 1908w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"396\" data-id=\"1667\" src=\"https:\/\/cdn.manvscloud.com\/wp-content\/uploads\/2022\/06\/11143252\/monitoring-per2-1024x396.png\" alt=\"\" class=\"wp-image-1667\" srcset=\"https:\/\/cdn.manvscloud.com\/wp-content\/uploads\/2022\/06\/11143252\/monitoring-per2-1024x396.png 1024w, https:\/\/cdn.manvscloud.com\/wp-content\/uploads\/2022\/06\/11143252\/monitoring-per2-300x116.png 300w, https:\/\/cdn.manvscloud.com\/wp-content\/uploads\/2022\/06\/11143252\/monitoring-per2-768x297.png 768w, https:\/\/cdn.manvscloud.com\/wp-content\/uploads\/2022\/06\/11143252\/monitoring-per2-1536x594.png 1536w, https:\/\/cdn.manvscloud.com\/wp-content\/uploads\/2022\/06\/11143252\/monitoring-per2-1080x418.png 1080w, https:\/\/cdn.manvscloud.com\/wp-content\/uploads\/2022\/06\/11143252\/monitoring-per2.png 1923w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n<\/figure>\n\n\n\n<p>Performance\uc5d0\uc11c \ubaa8\ub2c8\ud130\ub9c1 \ud560 \uc218 \uc788\ub294 \ubaa9\ub85d\uc740 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<ul><li>CPU used<\/li><li>CPU Queue length<\/li><li>Context Switches<\/li><li>disk read latency<\/li><li>disk write latency<\/li><li>disk Queue Length<\/li><li>disk read mbyte<\/li><li>disk write mbyte<\/li><li>network in<\/li><li>network out<\/li><li>network packet<\/li><li>DB lazy write<\/li><li>Free Memory<\/li><li>Page Life Expectancy<\/li><li>Memory Grants Pending<\/li><li>execute queries count<\/li><li>DB buffer lookup<\/li><li>DB buffer reads<\/li><li>DB buffer writes<\/li><li>db latch wait<\/li><li>db lock wait<\/li><li>sql compile<\/li><li>sql re-compile<\/li><li>connections<\/li><li>availableMemory<\/li><\/ul>\n\n\n\n<p>\ucd94\uac00\ub85c <strong>\ubaa8\ub2c8\ud130\ub9c1 \uc815\ubcf4\ub294 (\uae30\uac04 : \ucd5c\uadfc 1\uc2dc\uac04 \uae30\uc900) \ub9e4 1\ubd84 \uc218\uc9d1\ub41c \ud3c9\uade0\uac12 \uae30\uc900<\/strong>\uc785\ub2c8\ub2e4.<br><strong><span class=\"has-inline-color has-vivid-cyan-blue-color\">\uae30\uac04\uc5d0 \ub530\ub77c \uc218\uc9d1 \uc8fc\uae30\uac00 \ub2ec\ub77c\uc9d1\ub2c8\ub2e4.<\/span><\/strong><br>ex) \uae30\uac04 : \ucd5c\uadfc 7\uc77c \uae30\uc900\uc77c \ub54c \ub9e4 30\ubd84 \uc218\uc9d1\ub41c \ud3c9\uade0\uac12 \uae30\uc900 \ub4f1 \uc120\ud0dd\ud55c \uae30\uac04\uc5d0 \ub530\ub77c \uc8fc\uae30\uac00 \ub2e4\ub984.<br>\uc989, \ucd5c\uadfc 1\uc77c\ub85c \ubcfc\ub54c\uc640 \ucd5c\uadfc 7\uc77c \uae30\uc900\uc73c\ub85c \ubcfc \ub54c \ubaa8\ub2c8\ud130\ub9c1 \uadf8\ub798\ud504\uac00 \ub2e4\ub974\ub2e4\ub294 \uad81\uae08\uc99d\uc744 \uac00\uc9c0\ub294 \ubd84\ub4e4\uc774 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<p>\ud558\uc9c0\ub9cc \uc774\ub294 \ub2f9\uc5f0\ud55c \uac83\uc785\ub2c8\ub2e4. <br><span class=\"has-inline-color has-vivid-green-cyan-color\">\ucd5c\uadfc 1\uc77c \uae30\uc900\uc73c\ub85c \ubcf4\uc558\uc744 \ub54c \ub9e4 1\ubd84\uac04 \uc218\uc9d1\ub41c \uacb0\uacfc\uc758 \ud3c9\uade0\uac12\uc774 \uadf8\ub798\ud504\ub85c \ub098\ud0c0\ub098\uace0 \ucd5c\uadfc 7\uc77c \uae30\uc900\uc73c\ub85c \ubcf4\uba74 \ub9e4 30\ubd84 \uc218\uc9d1\ub41c \ud3c9\uade0\uac12\uc73c\ub85c \uadf8\ub798\ud504\ub85c \ub098\ud0c0\ub098\ubbc0\ub85c \uadf8\ub798\ud504\uac00 \ub2e4\ub974\uac8c \ubcf4\uc774\ub294 \uac83<\/span>\uc785\ub2c8\ub2e4.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"439\" src=\"https:\/\/cdn.manvscloud.com\/wp-content\/uploads\/2022\/06\/11143241\/monitoring-logs-1024x439.png\" alt=\"\" class=\"wp-image-1666\" srcset=\"https:\/\/cdn.manvscloud.com\/wp-content\/uploads\/2022\/06\/11143241\/monitoring-logs-1024x439.png 1024w, https:\/\/cdn.manvscloud.com\/wp-content\/uploads\/2022\/06\/11143241\/monitoring-logs-300x129.png 300w, https:\/\/cdn.manvscloud.com\/wp-content\/uploads\/2022\/06\/11143241\/monitoring-logs-768x329.png 768w, https:\/\/cdn.manvscloud.com\/wp-content\/uploads\/2022\/06\/11143241\/monitoring-logs-1536x658.png 1536w, https:\/\/cdn.manvscloud.com\/wp-content\/uploads\/2022\/06\/11143241\/monitoring-logs-2048x877.png 2048w, https:\/\/cdn.manvscloud.com\/wp-content\/uploads\/2022\/06\/11143241\/monitoring-logs-1080x463.png 1080w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>\ub9c8\uc9c0\ub9c9\uc73c\ub85c Monitoring \ud398\uc774\uc9c0\uc5d0\uc11c\ub294 DB Logs\ub3c4 \ud655\uc778\uc744 \ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<p>\uc124\uc815\ud55c \uae30\uac04 \ub3d9\uc548\uc758 \uc5d0\ub7ec \ub85c\uadf8 \ub0b4\uc6a9\uc774 \ud45c\uc2dc\ub418\uac8c \ub429\ub2c8\ub2e4.<\/p>\n\n\n\n<div style=\"height:30px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h4 class=\"wp-block-heading\">\u203b Backup<\/h4>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"845\" src=\"https:\/\/cdn.manvscloud.com\/wp-content\/uploads\/2022\/06\/11133849\/backup-01-1-1024x845.png\" alt=\"\" class=\"wp-image-1657\" srcset=\"https:\/\/cdn.manvscloud.com\/wp-content\/uploads\/2022\/06\/11133849\/backup-01-1-1024x845.png 1024w, https:\/\/cdn.manvscloud.com\/wp-content\/uploads\/2022\/06\/11133849\/backup-01-1-300x247.png 300w, https:\/\/cdn.manvscloud.com\/wp-content\/uploads\/2022\/06\/11133849\/backup-01-1-768x634.png 768w, https:\/\/cdn.manvscloud.com\/wp-content\/uploads\/2022\/06\/11133849\/backup-01-1.png 1068w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>\u2014 \uc57d 1\uc2dc\uac04 \uc18c\uc694\ub418\uc5c8\uc73c\uba70 DB \uc6a9\ub7c9\uc5d0 \ub530\ub77c \ub354 \uc624\ub79c \uc2dc\uac04\uc774 \uc18c\uc694\ub420 \uac83\uc73c\ub85c \ubcf4\uc785\ub2c8\ub2e4.<\/p>\n\n\n\n<p>\u2014 \uc120\ud0dd\ud55c \uc2dc\uac04\ub300\uc5d0 \uac00\uc7a5 \uac00\uae4c\uc6b4 \ubc31\uc5c5 \ud30c\uc77c\uc744 \uc774\uc6a9\ud558\uc5ec \uc0c8\ub85c\uc6b4 \uc11c\ubc84\uac00 \uc0dd\uc131\ub429\ub2c8\ub2e4. <br>     (VPC, Subnet \ub4f1\uc744 \uc124\uc815\ud560 \uc218 \uc5c6\uc2b5\ub2c8\ub2e4.)<\/p>\n\n\n\n<p>\u2014 <span class=\"has-inline-color has-vivid-red-color\">\u201cCloud DB for MSSQL\u201d to \uc678\ubd80 \ub610\ub294 \u201c\uc678\ubd80 to Cloud DB for MSSQL\u201d \ubc31\uc5c5 \ubc0f \ubcf5\uc6d0\uc740 DMT \ud234\uc744 \uc774\uc6a9\ud558\uc5ec \uac00\ub2a5<\/span>\ud569\ub2c8\ub2e4. <br>     (\uc5c5\ub85c\ub4dc, \ub2e4\uc6b4\ub85c\ub4dc \ubaa8\ub450 \uac00\ub2a5\ud569\ub2c8\ub2e4.) <\/p>\n\n\n<div class=\"vlp-link-container vlp-layout-basic wp-block-visual-link-preview-link\"><a href=\"https:\/\/github.com\/NaverCloudPlatform\/DataMigrationTool\" class=\"vlp-link\" title=\"GitHub - NaverCloudPlatform\/DataMigrationTool\" rel=\"nofollow\" target=\"_blank\"><\/a><div class=\"vlp-layout-zone-side\"><div class=\"vlp-block-2 vlp-link-image\"><img decoding=\"async\" src=\"https:\/\/opengraph.githubassets.com\/65e925bada36b9ea6170a984062fa4782844c766f60994716ec9fb2dabbe8c18\/NaverCloudPlatform\/DataMigrationTool\" style=\"max-width: 150px; max-height: 150px\" \/><\/div><\/div><div class=\"vlp-layout-zone-main\"><div class=\"vlp-block-0 vlp-link-title\">GitHub &#8211; NaverCloudPlatform\/DataMigrationTool<\/div><div class=\"vlp-block-1 vlp-link-summary\">Contribute to NaverCloudPlatform\/DataMigrationTool development by creating an account on GitHub.<\/div><\/div><\/div>\n\n\n<div style=\"height:15px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"420\" src=\"https:\/\/cdn.manvscloud.com\/wp-content\/uploads\/2022\/06\/11133906\/backup-02-1024x420.png\" alt=\"\" class=\"wp-image-1658\" srcset=\"https:\/\/cdn.manvscloud.com\/wp-content\/uploads\/2022\/06\/11133906\/backup-02-1024x420.png 1024w, https:\/\/cdn.manvscloud.com\/wp-content\/uploads\/2022\/06\/11133906\/backup-02-300x123.png 300w, https:\/\/cdn.manvscloud.com\/wp-content\/uploads\/2022\/06\/11133906\/backup-02-768x315.png 768w, https:\/\/cdn.manvscloud.com\/wp-content\/uploads\/2022\/06\/11133906\/backup-02-1080x443.png 1080w, https:\/\/cdn.manvscloud.com\/wp-content\/uploads\/2022\/06\/11133906\/backup-02.png 1376w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>\u2014 <strong><span class=\"has-inline-color has-vivid-red-color\">Backup\uc73c\ub85c \ubcf5\uc6d0\ud55c DB Server\ub294 Multi Zone\uc774 Y\uc5d0\uc11c N\ub85c \uc0dd\uc131\ub429\ub2c8\ub2e4. <\/span><\/strong><br>(\uae30\uc874\uc5d0 Multi Zone\uc73c\ub85c \uc6b4\uc601\uc911\uc774\uc5c8\ub354\ub77c\ub3c4 \ubcf5\uc6d0 \uc2dc \ud558\ub098\uc758 Zone\uc5d0 Principal\uc640 Mirror\uac00 \uc0dd\uc131\ub418\uc5b4 Zone \uc7a5\uc560 \ubc1c\uc0dd \uc2dc \ubb38\uc81c\uac00 \ub420 \uc218 \uc788\uc73c\ub2c8 \uc774 \ubd80\ubd84\uc744 \ubbf8\ub9ac \uc778\uc9c0\ud558\uace0 \ubc29\uc548\uc744 \uc0dd\uac01\ud574\ub450\ub294 \uac83\uc774 \uc88b\uc544\ubcf4\uc785\ub2c8\ub2e4.)<br> <span class=\"has-inline-color has-vivid-red-color\">\u203b \ubcf5\uc6d0 \uc2dc \uc2f1\uae00\uc874\/\uba40\ud2f0\uc874, AZ \ub4f1 \uc774\ub7ec\ud55c \uc120\ud0dd\uc9c0\uc5d0 \ub300\ud55c \uc635\uc158\uc740 4\ubd84\uae30 \uc815\ub3c4\uc5d0 \uac1c\uc120\ub420 \uc608\uc815\uc785\ub2c8\ub2e4.<\/span><\/p>\n\n\n\n<div style=\"height:30px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h4 class=\"wp-block-heading\">\u203b Event<\/h4>\n\n\n\n<ul><li>Cloud DB for MSSQL \uc11c\ubc84\uc5d0\uc11c \ubc1c\uc0dd\ud55c \uc774\ubca4\ud2b8 \uc774\ub825\uc744 \ud655\uc778\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/li><li>Metric \uc774\ubca4\ud2b8\ub97c Cloud Insight\uc5d0\uc11c \uc124\uc815\ud558\uc5ec \uba54\uc77c \ub610\ub294 SMS\ub85c \uc54c\ub9bc\uc744 \ubc1b\uc744 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/li><\/ul>\n\n\n\n<p>\ud655\uc778 \uac00\ub2a5\ud55c \uc774\ubca4\ud2b8\uc640 \uc124\uc815 \uac00\ub2a5\ud55c \uc774\ubca4\ud2b8 \ud56d\ubaa9\uc740 \uc544\ub798 \ub9c1\ud06c\ub97c \ud1b5\ud574 \ud655\uc778\ud558\uc2e4 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n<div class=\"vlp-link-container vlp-layout-basic wp-block-visual-link-preview-link\"><a href=\"https:\/\/guide.ncloud-docs.com\/docs\/database-database-9-7\" class=\"vlp-link\" title=\"Event \uc0ac\uc6a9 \uac00\uc774\ub4dc - Cloud DB for MSSQL\" rel=\"nofollow\" target=\"_blank\"><\/a><div class=\"vlp-layout-zone-side\"><div class=\"vlp-block-2 vlp-link-image\"><img decoding=\"async\" src=\"https:\/\/cdn.document360.io\/6998976f-9d95-4df8-b847-d375892b92c2\/Images\/Documentation\/ncp-manual-logo-ko-v2.svg\" style=\"max-width: 150px; max-height: 150px\" \/><\/div><\/div><div class=\"vlp-layout-zone-main\"><div class=\"vlp-block-0 vlp-link-title\">Event \uc0ac\uc6a9 \uac00\uc774\ub4dc &#8211; Cloud DB for MSSQL<\/div><div class=\"vlp-block-1 vlp-link-summary\">Q. Cloud DB for MSSQL\uc758 \uc774\ubca4\ud2b8\ub294 \uc5b4\ub5a4 \uc11c\ube44\uc2a4\uc778\uac00\uc694?<\/div><\/div><\/div>\n\n\n<div style=\"height:10px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p>\u2014 \uc218\ub3d9\uc73c\ub85c \uc7ac\uc2dc\uc791\ud55c Failover\ub294 [Event] &#8211; [\ud544\ud130]\uc758 &#8216;\uc774\ubca4\ud2b8 \uc774\ub984 : Restart&#8217;\uc5d0 \ub0a8\uc2b5\ub2c8\ub2e4.<br>\uc989, \uc7a5\uc560\ub85c \uc778\ud55c Failover\ub9cc [Event] &#8211; [\ud544\ud130]\uc758 &#8216;\uc774\ubca4\ud2b8 \uc774\ub984 : Failover&#8217; \uc5d0 \ub0a8\uaca8\uc9c8 \uac83\uc73c\ub85c \ubcf4\uc785\ub2c8\ub2e4.<\/p>\n\n\n\n<div style=\"height:30px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h4 class=\"wp-block-heading\">\u203b Config Group<\/h4>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"477\" height=\"112\" src=\"https:\/\/cdn.manvscloud.com\/wp-content\/uploads\/2022\/06\/11134936\/config-01.png\" alt=\"\" class=\"wp-image-1659\" srcset=\"https:\/\/cdn.manvscloud.com\/wp-content\/uploads\/2022\/06\/11134936\/config-01.png 477w, https:\/\/cdn.manvscloud.com\/wp-content\/uploads\/2022\/06\/11134936\/config-01-300x70.png 300w\" sizes=\"(max-width: 477px) 100vw, 477px\" \/><\/figure>\n\n\n\n<p>\u2014 Config Group\uc5d0 \uc124\uc815\ub41c Config\uac12\uc740 Console\uc5d0\uc11c\ub9cc \ubcc0\uacbd\uc774 \uac00\ub2a5\ud569\ub2c8\ub2e4. <br>\uae30\ubcf8\uc801\uc73c\ub85c \uc0dd\uc131\ub418\ub294 default Config Group\uc5d0\uc11c\ub294 Config \ubcc0\uacbd\uc774 \ub418\uc9c0\uc54a\uc2b5\ub2c8\ub2e4. <br>(\uc7ac\uc2dc\uc791\uc774 \ud544\uc694\ud55c \ubcc0\uacbd\uc740 Cloud DB \uc11c\ubc84 \uc7ac\uc2dc\uc791 \ud6c4\uc5d0 \uc801\uc6a9)<\/p>\n\n\n\n<p>\u2014 Config Group\uc5d0\uc11c network packet size \uc218\uce58 \ubcc0\uacbd \ud6c4 CLI\uc5d0\uc11c \ud655\uc778 \uc2dc \uc815\uc0c1 \ubcc0\uacbd \ud655\uc778<\/p>\n\n\n\n<figure class=\"wp-block-pullquote\"><blockquote><p>Config Group\uc5d0\uc11c \uc124\uc815 \uac12 \ubcc0\uacbd \ud6c4 \uc11c\ubc84 \ub0b4 \uc801\uc6a9\ub41c \uac12 \ud655\uc778 \ud574\ubcf4\uae30<\/p><cite>Config Group\uc5d0\uc11c network packet size \uc758 \uae30\ubcf8\uac12 4096\uc744 8192\ub85c \ubcc0\uacbd \ud6c4 <br>\uc11c\ubc84\uc5d0 \uc811\uc18d\ud558\uc5ec \ubcc0\uacbd\ub41c \uac12\uc744 \ucffc\ub9ac\ub85c \ud655\uc778\ud574\ubcf4\uc558\uc2b5\ub2c8\ub2e4.<\/cite><\/blockquote><\/figure>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">1> EXEC sp_configure @configname='network packet size';\n2> GO\nname    minimum maximum config_value    run_value\nnetwork packet size (B) 512     32767   8192    8192\n(1 row affected)\n(return status = 0)<\/pre>\n\n\n\n<hr class=\"wp-block-separator has-css-opacity\"\/>\n\n\n\n<h3 class=\"has-white-color has-vivid-red-background-color has-text-color has-background wp-block-heading\"> How to connect to Cloud DB for MSSQL<\/h3>\n\n\n\n<p>Cloud DB for MSSQL\uc5d0 \uc811\uc18d\ud558\ub294 \ubc29\ubc95\uc740 \ud06c\uac8c \uc138\uac00\uc9c0 \ubc29\ubc95\uc774 \uc874\uc7ac\ud569\ub2c8\ub2e4.<\/p>\n\n\n\n<ol><li>\ub124\uc774\ubc84 \ud074\ub77c\uc6b0\ub4dc \ud50c\ub7ab\ud3fc \uc11c\ubc84\uc5d0\uc11c private \ub3c4\uba54\uc778 \uc774\uc6a9\ud558\uc5ec \uc811\uadfc<\/li><li>SSL VPN\uc744 \uc774\uc6a9\ud558\uc5ec \uc811\uadfc<\/li><li><s>Public \ub3c4\uba54\uc778\uc744 \uc774\uc6a9\ud558\uc5ec \uc811\uadfc<\/s><\/li><\/ol>\n\n\n\n<p>\uba3c\uc800 1\ubc88\uc740 \ub124\uc774\ubc84 \ud074\ub77c\uc6b0\ub4dc \ud50c\ub7ab\ud3fc\uc5d0\uc11c \uc11c\ubc84\ub97c \uc0dd\uc131\ud558\uc5ec \ud574\ub2f9 \uc11c\ubc84\ub97c \ud1b5\ud574 private \ud1b5\uc2e0\uc73c\ub85c \uc5f0\uacb0\ud558\ub294 \ubc29\ubc95\uc785\ub2c8\ub2e4. <\/p>\n\n\n\n<p>2\ubc88\uc9f8 \ubc29\ubc95\uc73c\ub85c\ub294 SSL VPN\uc744 \uc774\uc6a9\ud558\uc5ec \uc811\uadfc\ud558\ub294 \ubc29\ubc95\uc785\ub2c8\ub2e4.<\/p>\n\n\n<div class=\"vlp-link-container vlp-layout-basic wp-block-visual-link-preview-link\"><a href=\"https:\/\/manvscloud.com\/?p=1674\" class=\"vlp-link\" title=\"[NCP] \ub124\uc774\ubc84 \ud074\ub77c\uc6b0\ub4dc\uc5d0\uc11c SSL VPN\uc744 \uc0ac\uc6a9\ud574\ubcf4\uc790\" rel=\"nofollow\" target=\"_blank\"><\/a><div class=\"vlp-layout-zone-side\"><div class=\"vlp-block-2 vlp-link-image\"><img decoding=\"async\" src=\"https:\/\/cdn.manvscloud.com\/wp-content\/uploads\/2022\/06\/12163202\/ssl-vpn-01-1024x717.png\" style=\"max-width: 150px; max-height: 150px\" \/><\/div><\/div><div class=\"vlp-layout-zone-main\"><div class=\"vlp-block-0 vlp-link-title\">[NCP] \ub124\uc774\ubc84 \ud074\ub77c\uc6b0\ub4dc\uc5d0\uc11c SSL VPN\uc744 \uc0ac\uc6a9\ud574\ubcf4\uc790<\/div><div class=\"vlp-block-1 vlp-link-summary\">\uc548\ub155\ud558\uc138\uc694 ManVSCloud \uae40\uc218\ud604\uc785\ub2c8\ub2e4. \ub124\uc774\ubc84 \ud074\ub77c\uc6b0\ub4dc\uc5d0\uc11c SSL VPN\uc744 \uc0ac\uc6a9\ud558\ub294 \ubc29\ubc95\uc744 \ud3ec\uc2a4\ud305 \ud558\ub3c4\ub85d \ud558\uaca0\uc2b5\ub2c8\ub2e4.\ud56d\uc0c1 \uadf8\ub7ac\ub4ef VPC \ud658\uacbd\uc5d0\uc11c \uc9c4\ud589\ud558\uc600\uc2b5\ub2c8\ub2e4. SSL VPN SSL VPN\uc740 Site to Client, \uc989 \uc7a5\ube44\uc640 \uc0ac\uc6a9\uc790 \uac04 \ud1b5\uc2e0\uc5d0 \uc554\ud638\ud654 \uc11c\ube44\uc2a4\ub97c \uc81c\uacf5\ud558\uac8c\ub418\ub294\ub370 \ucd5c\uadfc \uc7ac\ud0dd\uadfc\ubb34\uac00 \ub9ce\uc544\uc9c0\uba70 VPN Client Agent(Software)\ub97c \uc124\uce58 \ud6c4 \ub85c\uadf8\uc778\ud558\uc5ec \ud68c\uc0ac \uc0ac\uc124\ub9dd\uc73c\ub85c \uc5f0\uacb0\ud558\ub294 \uacbd\ud5d8\uc744 \ub9ce\uc774 \ud558\uac8c\ub418\uc5b4 \uc798 \uc544\uc2e4 \uac70\ub77c \uc0dd\uac01\ub429\ub2c8\ub2e4. \ub124\uc774\ubc84 \ud074\ub77c\uc6b0\ub4dc \ud50c\ub7ab\ud3fc\uc5d0\uc11c SSL VPN\uc744 \uc0ac\uc6a9\ud558\uac8c \ub420 \uacbd\uc6b0 \ub124\uc774\ubc84 \ud074\ub77c\uc6b0\ub4dc\uc5d0\uc11c 1.\u2026<\/div><\/div><\/div>\n\n\n<p>Public \ud558\uac8c \uc0ac\uc6a9\ud558\ub294 \uac83\uc744 \uad8c\uc7a5\ud558\uc9c0 \uc54a\uc73c\ubbc0\ub85c 3\ubc88\uc758 \uacbd\uc6b0 \uc904\uc744 \uba3c\uc800 \uadf8\uc5b4\ub193\uc558\uc2b5\ub2c8\ub2e4.<br>(1, 2\ubc88\uc758 \ubc29\ubc95\uc744 \uc0ac\uc6a9\ud569\uc2dc\ub2e4. \ud83d\ude0e)<\/p>\n\n\n\n<hr class=\"wp-block-separator has-css-opacity\"\/>\n\n\n\n<h3 class=\"has-white-color has-luminous-vivid-amber-background-color has-text-color has-background wp-block-heading\"> Test Environment &amp; Collection of Queries Used<\/h3>\n\n\n\n<pre class=\"wp-block-preformatted\"><strong>## SERVER<\/strong> <strong>:<\/strong> \n<strong>* \ubc84\uc804<\/strong> : centos-7.8-64 (+ Apache 2.4.6, PHP 7.4.30 ) \n\n<strong>## Cloud DB for MSSQL :<\/strong> \n<strong>* \ubc84\uc804 <\/strong>: Microsoft SQL Server 2019 (RTM) - 15.0.2000.5 (X64) Sep 24 2019 13:48:23 Copyright (C) 2019 Microsoft Corporation Standard Edition (64-bit) on Windows Server 2016 Standard 10.0 &lt;X64&gt; (Build 14393: ) (Hypervisor)\n\n<strong>* SERVER\uc5d0\uc11c Cloud DB for MSSQL \uc811\uc18d \uc2dc \uc0ac\uc6a9\ub41c CLI \uba85\ub839\uc5b4<\/strong>\nsqlcmd -S 'Cloud DB For MSSQL\uc758 \uc5d4\ub4dc\ud3ec\uc778\ud2b8' -U \uacc4\uc815\uba85 -P '\ud328\uc2a4\uc6cc\ub4dc' \n<span class=\"has-inline-color has-cyan-bluish-gray-color\">\ub610\ub294<\/span> \ntsql -S 'Cloud DB For MSSQL\uc758 \uc5d4\ub4dc\ud3ec\uc778\ud2b8' -p 1433 -U \uacc4\uc815\uba85 -P '\ud328\uc2a4\uc6cc\ub4dc' <\/pre>\n\n\n\n<div style=\"height:15px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-vivid-cyan-blue-color\">sqlcmd\ub97c \uc0ac\uc6a9\ud558\uae30 \uc704\ud574\uc11c\ub294 <strong><em>mssql<\/em>-tools<\/strong>\ub97c \uc124\uce58\ud558\uba74 \ub418\uace0 <br>tsql\uc744 \uc0ac\uc6a9\ud558\uc2dc\ub824\uba74 <strong>freetds<\/strong>\ub97c \uc124\uce58\ud558\uba74 \ub429\ub2c8\ub2e4.<\/mark><\/p>\n\n\n\n<div style=\"height:30px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h4 class=\"wp-block-heading\">\u203b \ud14c\uc2a4\ud2b8 \uc2dc \uc0ac\uc6a9\ub41c \ucffc\ub9ac<\/h4>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">--------------------------------------------------------------------------\n\/\/ \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc0dd\uc131\nCREATE DATABASE test1;\nGO\n\n\n\/\/ \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc0ad\uc81c\nUSE master;\nGO\nDROP DATABASE test1;\nGO\n\n\n\/\/ \ud14c\uc774\ube14 \uc0dd\uc131\nCREATE TABLE emp \n(\n    empno    INT NOT NULL PRIMARY KEY,\n    ename    VARCHAR(10),\n    job      VARCHAR(9),\n    mgr      INT,\n    hiredate DATE,\n    sal      NUMERIC(7, 2),\n    comm     NUMERIC(7, 2),\n    deptno   INT\n)\nGO\n\n\n\/\/ \ud14c\uc774\ube14 \uc870\ud68c\nSELECT *\n  FROM INFORMATION_SCHEMA.TABLES\n  ORDER BY TABLE_NAME\nGO\n\n\n\/\/ sp_configure \uc124\uc815\uac12 \uc870\ud68c\nUSE master;\nGO\nEXEC sp_configure @configname='network packet size';\nGO\n\n\n\/\/ \ubcf5\uad6c \ubaa8\ub378 \ud655\uc778\nSELECT name, recovery_model_desc  \n   FROM sys.databases  \n      WHERE name = 'model' ;  \nGO\n\n\/\/ \uc0ac\uc6a9\uc790 \uc0dd\uc131\n-- Creates the login AbolrousHazem with password '340$Uuxwp7Mcxo7Khy'.  \nCREATE LOGIN AbolrousHazem   \n    WITH PASSWORD = '340$Uuxwp7Mcxo7Khy';  \nGO  \n\n-- Creates a database user for the login created above.  \nCREATE USER AbolrousHazem FOR LOGIN AbolrousHazem;  \nGO  \n--------------------------------------------------------------------------<\/pre>\n\n\n\n<div style=\"height:15px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<ul><li><strong>MSSQL \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc0ac\uc6a9 \uad8c\ud55c \ucffc\ub9ac \ucc38\uace0<\/strong><\/li><\/ul>\n\n\n<div class=\"vlp-link-container vlp-layout-basic wp-block-visual-link-preview-link\"><a href=\"https:\/\/docs.microsoft.com\/ko-kr\/sql\/t-sql\/statements\/grant-database-permissions-transact-sql?view=sql-server-ver16\" class=\"vlp-link\" title=\"GRANT Database Permissions(Transact-SQL) - SQL Server\" rel=\"nofollow\" target=\"_blank\"><\/a><div class=\"vlp-layout-zone-side\"><div class=\"vlp-block-2 vlp-link-image\"><img decoding=\"async\" src=\"https:\/\/docs.microsoft.com\/en-us\/media\/logos\/logo-ms-social.png\" style=\"max-width: 150px; max-height: 150px\" \/><\/div><\/div><div class=\"vlp-layout-zone-main\"><div class=\"vlp-block-0 vlp-link-title\">GRANT Database Permissions(Transact-SQL) &#8211; SQL Server<\/div><div class=\"vlp-block-1 vlp-link-summary\">GRANT \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc0ac\uc6a9 \uad8c\ud55c(Transact-SQL)<\/div><\/div><\/div>\n\n\n<div style=\"height:30px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h4 class=\"wp-block-heading\">\u203b \ud14c\uc2a4\ud2b8 \uc2dc MSSQL + PHP \uc5f0\ub3d9 \uc18c\uc2a4<\/h4>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">&lt;?php \n$serverName = \"\uc11c\ubc84\uc544\uc774\ud53c\";\n$connectionOptions = array(\n    \"database\" => \"database_name\", \/\/ \ub370\uc774\ud130\ubca0\uc774\uc2a4\uba85\n    \"uid\" => \"user_name\",   \/\/ \uc720\uc800 \uc544\uc774\ub514\n    \"pwd\" => \"user_passwd\"    \/\/ \uc720\uc800 \ube44\ubc88\n);\n\n\/\/ DB\ucee4\ub125\uc158 \uc5f0\uacb0\n$dbconn = sqlsrv_connect($serverName, $connectionOptions); \n\n\/\/ \ucffc\ub9ac\n$query = \"SELECT name, age FROM test\"; \n\n\/\/ \ucffc\ub9ac\ub97c \uc2e4\ud589\ud558\uc5ec statement \ub97c \uc5bb\uc5b4\uc628\ub2e4\n$stmt = sqlsrv_query($dbconn, $query);\n\n\/\/ statement \ub97c \ub3cc\uba74\uc11c \ud544\ub4dc\uac12\uc744 \uac00\uc838\uc628\ub2e4\nwhile ($row = sqlsrv_fetch_array($stmt, SQLSRV_FETCH_ASSOC))\n\n{\n    echo $row['name'];\n    echo $row['age'];\n    echo \"&lt;br>\";\n}\n\n\/\/ \ub370\uc774\ud130 \ucd9c\ub825\ud6c4 statement \ub97c \ud574\uc81c\ud55c\ub2e4\nsqlsrv_free_stmt($stmt);\n\n\/\/ \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc811\uc18d\uc744 \ud574\uc81c\ud55c\ub2e4\nsqlsrv_close($dbconn);\n\necho\necho \"\ud604\uc7ac \ub0a0\uc9dc : \". date(\"Y-m-d\").\"&lt;br\/>\";\necho \"\ud604\uc7ac \uc2dc\uac04 : \". date(\"H:i:s\").\"&lt;br\/>\";\necho \"\ud604\uc7ac \uc77c\uc2dc : \". date(\"Y-m-d H:i:s\").\"&lt;br\/>\";\n\n?><\/pre>\n\n\n\n<div style=\"height:15px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<ul><li><strong>MSSQL + PHP \uc5f0\ub3d9 \uc2dc \ucc38\uace0\ud55c URL<\/strong><\/li><\/ul>\n\n\n<div class=\"vlp-link-container vlp-layout-basic wp-block-visual-link-preview-link\"><a href=\"https:\/\/doolyit.tistory.com\/143\" class=\"vlp-link\" title=\"PHP\uc5d0\uc11c MSSQL \uc5f0\ub3d9\ud558\uc5ec \ucffc\ub9ac\uc2e4\ud589\ud558\uae30, sqlsrv\ub85c MS-SQL \uc811\uc18d\ud558\uae30\" rel=\"nofollow\" target=\"_blank\"><\/a><div class=\"vlp-layout-zone-side\"><div class=\"vlp-block-2 vlp-link-image\"><img decoding=\"async\" src=\"https:\/\/img1.daumcdn.net\/thumb\/R800x0\/?scode=mtistory2&amp;fname=https%3A%2F%2Fblog.kakaocdn.net%2Fdn%2FowduP%2FbtqvGC2r6oj%2FqrRSlVt7KIaw7Ef8baAEk0%2Fimg.png\" style=\"max-width: 150px; max-height: 150px\" \/><\/div><\/div><div class=\"vlp-layout-zone-main\"><div class=\"vlp-block-0 vlp-link-title\">PHP\uc5d0\uc11c MSSQL \uc5f0\ub3d9\ud558\uc5ec \ucffc\ub9ac\uc2e4\ud589\ud558\uae30, sqlsrv\ub85c MS-SQL \uc811\uc18d\ud558\uae30<\/div><div class=\"vlp-block-1 vlp-link-summary\">PHP\uc5d0\uc11c MSSQL \uc5d0 \uc5f0\ub3d9\ud558\uac70\ub098 \uc811\uc18d \ud6c4 \ucffc\ub9ac\ub97c \uc2e4\ud589\ud558\ub294 \uacfc\uc815\uc744 \uc815\ub9ac\ud574 \ubcf4\uaca0\uc2b5\ub2c8\ub2e4 MS-SQL \uc740 IIS \uc11c\ubc84\uc640 \ud568\uaed8 \uc124\uce58\ub418\uac8c \ub418\ub294\ub370\uc694, \uc708\ub3c4\uc6b0 \uc6b4\uc601\uccb4\uc81c\ub97c \uae30\ubc18\uc73c\ub85c \ud558\uace0 \uc788\uae30 \ub54c\ubb38\uc5d0 \ub300\ubd80\ubd84 ASP \ub97c \uc774\uc6a9\ud558\uc5ec \ucf54\ub529\uc744..<\/div><\/div><\/div>\n\n\n<hr class=\"wp-block-separator has-css-opacity\"\/>\n\n\n\n<h3 class=\"has-white-color has-cyan-bluish-gray-background-color has-text-color has-background wp-block-heading\"> Personal Comments<\/h3>\n\n\n\n<p>\uc9c0\uae08\uae4c\uc9c0 Cloud DB for MSSQL\uc5d0 \ub300\ud574\uc11c \uc54c\uc544\ubcf4\uc558\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<p>Cloud DB for MSSQL \uc11c\ube44\uc2a4\ub97c \uc0ac\uc6a9\ud558\uc2dc\ub294 \ub370\uc5d0 \ud070 \ub3c4\uc6c0\uc774 \ub410\uc73c\uba74 \ud558\ub294 \ubc14\ub78c\uc785\ub2c8\ub2e4.<br>\ub2e4\uc74c \ud3ec\uc2a4\ud305\uc740 \ub354\uc6b1 \ud765\ubbf8\ub85c\uc6b4 \ud3ec\uc2a4\ud305\uc73c\ub85c \uc900\ube44\ud574\ubcf4\uaca0\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<p>\uae34 \uae00 \uc77d\uc5b4\uc8fc\uc154\uc11c \uac10\uc0ac\ud569\ub2c8\ub2e4.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-css-opacity\"\/>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"773\" height=\"133\" src=\"https:\/\/cdn.manvscloud.com\/wp-content\/uploads\/2021\/08\/12204137\/Ncloud_Master_logo.png\" alt=\"\" class=\"wp-image-1229\" srcset=\"https:\/\/cdn.manvscloud.com\/wp-content\/uploads\/2021\/08\/12204137\/Ncloud_Master_logo.png 773w, https:\/\/cdn.manvscloud.com\/wp-content\/uploads\/2021\/08\/12204137\/Ncloud_Master_logo-300x52.png 300w, https:\/\/cdn.manvscloud.com\/wp-content\/uploads\/2021\/08\/12204137\/Ncloud_Master_logo-768x132.png 768w\" sizes=\"(max-width: 773px) 100vw, 773px\" \/><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>\uc548\ub155\ud558\uc138\uc694 ManVSCloud \uae40\uc218\ud604\uc785\ub2c8\ub2e4. \uae08\uc77c \ud3ec\uc2a4\ud305\uc740 Cloud DB for MSSQL\uc5d0 \ub300\ud574 \ubaa8\ub450 \uc54c\uc544\ubcf4\ub294 \uac83\uc744 \ubaa9\ud45c\ub85c \ud3ec\uc2a4\ud305\ud574\ubcf4\uc558\uc2b5\ub2c8\ub2e4. Cloud DB for MSSQL Cloud DB for MSSQL\uc740 \uc644\uc804 \uad00\ub9ac\ud615 \uc11c\ube44\uc2a4\uc785\ub2c8\ub2e4.\uc644\uc804 \uad00\ub9ac\ud615 \uc11c\ube44\uc2a4\ub780 \ubb34\uc5c7\uc774\ub0d0? \ub124\uc774\ubc84 \ud074\ub77c\uc6b0\ub4dc \ud50c\ub7ab\ud3fc\uc5d0\uc11c \uc7a5\ube44, OS \uc124\uce58 \ubc0f \ub370\uc774\ud130 \ubca0\uc774\uc2a4 \uc194\ub8e8\uc158 \uc124\uce58 \ub4f1\uc744 \ubaa8\ub450 \uad00\ub9ac\ud558\uac8c \ub429\ub2c8\ub2e4. \uad00\ub9ac\ud615\uacfc \uc644\uc804 \uad00\ub9ac\ud615\uc758 \ucc28\uc774? : \uad00\ub9ac\ud615\uc740 \ub124\uc774\ubc84 \ud074\ub77c\uc6b0\ub4dc \ud50c\ub7ab\ud3fc\uc758 Server, \uc644\uc804 \uad00\ub9ac\ud615\uc740 Cloud DB for MSSQL\uc774\ub77c\uace0 \ud558\uba74 \uc5b4\ub5a4 \ucc28\uc774\uac00 \uc788\ub294\uc9c0 \uc26c\uc6b8 \uac83\uac19\uc2b5\ub2c8\ub2e4.\ub458 \ub2e4 \ubb3c\ub9ac\uc801 \uc7a5\ube44\uc640 OS\ub97c \uc81c\uacf5\ud558\uace0 \uad00\ub9ac\ud558\uc9c0\ub9cc Server\ub294 DB\uc640 \uac19\uc740 \uc194\ub8e8\uc158\uc740 \uc0ac\uc6a9\uc790\uac00 \uc9c1\uc811 \uc124\uce58\ud558\uace0 \uad00\ub9ac\ud574\uc57c\ud558\uba70 \ubc31\uc5c5\uc774\ub098 \uac00\uc6a9\uc131 \ub4f1\uc5d0 \ub300\ud574 \ubaa8\ub450 \uad00\ub9ac\ud574\uc57c\ud569\ub2c8\ub2e4.\ub2e4\ub9cc \uc644\uc804 \uad00\ub9ac\ud615\uc740 DB\uc194\ub8e8\uc158\uc774 \uc774\ubbf8 \uc124\uce58\ub41c \uc0c1\ud488\uc774\uace0 \ubc31\uc5c5\uc774\ub098 \uace0\uac00\uc6a9\uc131 \uae30\ub2a5\uc774 \uc788\uc5b4 \uc120\ud0dd\ub9cc\ud558\uba74 \ub429\ub2c8\ub2e4. \ub370\uc774\ud130\ubca0\uc774\uc2a4 \ucd5c\uc801\ud654 \uc124\uc815 \ubaa8\ub2c8\ud130\ub9c1\uacfc \uc54c\ub78c \ub370\uc774\ud130 \uc790\ub3d9 \ubc31\uc5c5 \uc9c0\uc6d0 \uc6a9\uc774\ud55c \ucffc\ub9ac \ubd84\uc11d 2TB\uae4c\uc9c0 \uc790\ub3d9 \uc99d\uac00\ud558\ub294 \ub370\uc774\ud130 \uc2a4\ud1a0\ub9ac\uc9c0 \uc790\ub3d9 \ud398\uc77c\uc624\ubc84(Failover) \uae30\ubcf8 \uc81c\uacf5 \uc77d\uae30 \uc2ac\ub808\uc774\ube0c(Slave) \uc11c\ubc84 \uc81c\uacf5 VPC \uae30\uc900 \ub77c\uc774\uc13c\uc2a4\ub294 Standard Edition, Enterprise Edition\uc744 \uc9c0\uc6d0\ud558\uace0 \uc788\uc2b5\ub2c8\ub2e4. \u2193 \ubbfc\uac04\uc6a9 Cloud DB for MSSQL \ub9c1\ud06c \u2193 \uae08\uc735 Cloud DB for MSSQL \ub9c1\ud06c Functional Check \u203b DB Server \ud0c0\uc785 \u2014 \ucd08\uae30 \uc0dd\uc131 \uc2dc Standard \/ High Memory \uc120\ud0dd \ud6c4 DB \uc2a4\ud399 \ubcc0\uacbd \uc2dc \ucc98\uc74c \uc120\ud0dd\ud55c \ud0c0\uc785\uc5d0\uc11c\ub9cc \uc2a4\ud399 \ubcc0\uacbd\uc774 \uac00\ub2a5\ud569\ub2c8\ub2e4. (Standard \uc120\ud0dd \uc2dc Standard \ud06c\uae30\uc5d0\uc11c\ub9cc \ubcc0\uacbd \uac00\ub2a5, High Memory, High CPU\ub85c \ubcc0\uacbd \ubd88\uac00) \u203b \uc7ac\uc2dc\uc791 (Failover) \u2014 Without FailOver (NCP \uc124\uba85 : SSMS \ub85c \uc124\uc815\ud55c \ub0b4\uc6a9\uc774 \uadf8\ub300\ub85c \ubcf4\uc7a5\ub418\uc9c0\ub9cc, [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"advanced_seo_description":"[NCP] Cloud db for MSSQL\uc758 \ubaa8\ub4e0 \uac83","jetpack_seo_html_title":"","jetpack_seo_noindex":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[3],"tags":[626,627,633,632,32,413,628,631,629,634,418,153,635,89,202,398,630],"jetpack_sharing_enabled":true,"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/manvscloud.com\/index.php?rest_route=\/wp\/v2\/posts\/1635"}],"collection":[{"href":"https:\/\/manvscloud.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/manvscloud.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/manvscloud.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/manvscloud.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1635"}],"version-history":[{"count":11,"href":"https:\/\/manvscloud.com\/index.php?rest_route=\/wp\/v2\/posts\/1635\/revisions"}],"predecessor-version":[{"id":1915,"href":"https:\/\/manvscloud.com\/index.php?rest_route=\/wp\/v2\/posts\/1635\/revisions\/1915"}],"wp:attachment":[{"href":"https:\/\/manvscloud.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1635"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/manvscloud.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1635"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/manvscloud.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1635"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}