{"id":2611,"date":"2024-01-31T19:03:09","date_gmt":"2024-01-31T10:03:09","guid":{"rendered":"https:\/\/manvscloud.com\/?p=2611"},"modified":"2024-02-01T00:36:55","modified_gmt":"2024-01-31T15:36:55","slug":"ncloud-cloud-db-for-mssql-%ec%8b%9c%ea%b0%84-%eb%8b%a8%ec%9c%84%eb%a1%9c-%eb%b0%b1%ec%97%85%ed%95%98%ea%b8%b0","status":"publish","type":"post","link":"https:\/\/manvscloud.com\/?p=2611","title":{"rendered":"[NCLOUD] Cloud DB for MSSQL \uc2dc\uac04 \ub2e8\uc704\ub85c \ubc31\uc5c5\ud558\uae30"},"content":{"rendered":"\n<p>\uc548\ub155\ud558\uc138\uc694 MANVSCLOUD \uae40\uc218\ud604\uc785\ub2c8\ub2e4.<\/p>\n\n\n\n<p>\ub370\uc774\ud130\ub294 \ud604\ub300 \ube44\uc988\ub2c8\uc2a4\uc758 \uc2ec\uc7a5\uacfc\ub3c4 \uac19\uc2b5\ub2c8\ub2e4. \uae30\uc5c5\ub4e4\uc740 \uace0\uac1d \uc815\ubcf4, \uac70\ub798 \ub0b4\uc5ed, \uc6b4\uc601 \ub370\uc774\ud130 \ub4f1\uc744 \uc2e4\uc2dc\uac04\uc73c\ub85c \ucc98\ub9ac\ud558\uace0 \uc774 \ub370\uc774\ud130\ub294 \uadf8\ub4e4\uc758 \uc758\uc0ac\uacb0\uc815\uacfc \uc11c\ube44\uc2a4 \ud488\uc9c8\uc744 \uacb0\uc815\uc9d3\ub294 \uc911\uc694\ud55c \uc694\uc18c\uac00 \ub418\uace0 \uc788\uc2b5\ub2c8\ub2e4. \uadf8\ub798\uc11c \ub370\uc774\ud130\uc758 \uc548\uc804\ud55c \ubcf4\uad00\uacfc \uc2e0\uc18d\ud55c \ubcf5\uad6c\ub294 \uc5b4\ub290 \ub54c\ubcf4\ub2e4 \uc911\uc694\ud55c \uacfc\uc81c\uac00 \ub418\uc5c8\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<p>\ub124\uc774\ubc84 \ud074\ub77c\uc6b0\ub4dc\ubfd0\ub9cc \uc544\ub2c8\ub77c AWS \ub4f1 \uad00\ub9ac\ud615 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc11c\ube44\uc2a4 \uc790\uccb4 \uae30\ub2a5\uc5d0\uc11c\ub294 \uae30\ubcf8\uc801\uc73c\ub85c \ud558\ub8e8 \ud2b9\uc815 \uc2dc\uac04\uc5d0 1\ud68c \ubc31\uc5c5\uc774 \uc9c4\ud589\ub418\ub3c4\ub85d \uc124\uc815\uc774 \uac00\ub2a5\ud55c\ub370\uc694.<\/p>\n\n\n\n<p>\uc694\uad6c \uc0ac\ud56d\uc5d0 \ub530\ub77c \ud558\ub8e8\uc5d0 \ud55c \ubc88\uc758 \ubc31\uc5c5\uc774 \ucda9\ubd84\ud558\uc9c0 \uc54a\uc744 \uc218 \uc788\uc2b5\ub2c8\ub2e4. <br>\uc608\ub97c \ub4e4\uc5b4 \ub9e4\uc6b0 \ube48\ubc88\ud558\uac8c \ub370\uc774\ud130\uac00 \ubcc0\uacbd\ub418\uac70\ub098 \uc2e4\uc2dc\uac04 \ub370\uc774\ud130 \ucc98\ub9ac\uac00 \uc911\uc694\ud55c \ube44\uc988\ub2c8\uc2a4\uc5d0\uc11c\ub294 \ub354 \uc790\uc8fc \ub370\uc774\ud130\ub97c \ubc31\uc5c5\ud560 \ud544\uc694\uac00 \uc788\uc2b5\ub2c8\ub2e4. <\/p>\n\n\n\n<p>\uc624\ub298  \ud3ec\uc2a4\ud305\uc740 \ub124\uc774\ubc84 \ud074\ub77c\uc6b0\ub4dc\uc758 Cloud DB For MSSQL \uc11c\ube44\uc2a4\uc5d0\uc11c \uc2dc\uac04 \ub2e8\uc704\ub85c \ub370\uc774\ud130\ub97c \ubc31\uc5c5\ud558\ub294 \ubc29\ubc95\uc744 \uc18c\uac1c\ud558\ub824\uace0 \ud569\ub2c8\ub2e4. \uc774\ub294 \uc7a5\uc560 \ubc1c\uc0dd \uc2dc \ub370\uc774\ud130 \ubcf5\uad6c \uc2dc\uc810\uc758 \uc815\ud655\uc131\uc744 \ub192\uc774\uace0 \ub370\uc774\ud130 \uc190\uc2e4\uc758 \uc704\ud5d8\uc744 \ucd5c\uc18c\ud654\ud558\ub294 \ub370 \ub3c4\uc6c0\uc774 \ub418\uba70 \uc774\ub7ec\ud55c \ubc31\uc5c5 \uc804\ub7b5\uc740 \ube44\uc988\ub2c8\uc2a4 \uc5f0\uc18d\uc131\uacfc \ub370\uc774\ud130 \ubb34\uacb0\uc131\uc744 \ubcf4\uc7a5\ud558\ub294 \ub370 \ud575\uc2ec\uc801\uc778 \uc694\uc18c\uac00 \ub420 \uac83\uc785\ub2c8\ub2e4.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3 class=\"wp-block-heading has-white-color has-vivid-green-cyan-background-color has-text-color has-background\"> \uc2dc\uc791\ud558\uae30 \uc804\uc5d0&#8230;<\/h3>\n\n\n\n<ol>\n<li class=\"has-medium-font-size\">\uc774 \ud3ec\uc2a4\ud305\uc5d0\uc11c\ub294 VPC, Server, Cloud DB for MSSQL, Object Storage \uc0dd\uc131\uc5d0 \uad00\ub828\ud574\uc11c\ub294 \uc124\uba85\ud558\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4.<\/li>\n\n\n\n<li class=\"has-medium-font-size\">\uc544\ub798 URL(\ub370\uc774\ud130 \ub9c8\uc774\uadf8\ub808\uc774\uc158(\ubc31\uc5c5 \ubcf5\uad6c))\ub97c \uba3c\uc800 \ud655\uc778\ud560 \uacbd\uc6b0 \uc774\ud574\ud558\uae30 \uc27d\uc2b5\ub2c8\ub2e4.<\/li>\n<\/ol>\n\n\n\n<p><a href=\"https:\/\/guide.ncloud-docs.com\/docs\/clouddbformssql-start-vpc#%EB%8D%B0%EC%9D%B4%ED%84%B0-%EB%A7%88%EC%9D%B4%EA%B7%B8%EB%A0%88%EC%9D%B4%EC%85%98%EB%B0%B1%EC%97%85-%EB%B3%B5%EA%B5%AC\">https:\/\/guide.ncloud-docs.com\/docs\/clouddbformssql-start-vpc#%EB%8D%B0%EC%9D%B4%ED%84%B0-%EB%A7%88%EC%9D%B4%EA%B7%B8%EB%A0%88%EC%9D%B4%EC%85%98%EB%B0%B1%EC%97%85-%EB%B3%B5%EA%B5%AC<\/a><\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3 class=\"wp-block-heading has-white-color has-vivid-green-cyan-background-color has-text-color has-background\"> Cloud DB for MSSQL \ubc31\uc5c5 \uc11c\ubc84 \uad6c\uc131<\/h3>\n\n\n\n<p>\uc704 \ub370\uc774\ud130 \ub9c8\uc774\uadf8\ub808\uc774\uc158(\ubc31\uc5c5 \ubcf5\uad6c) \uac00\uc774\ub4dc\uc5d0\uc11c\ub3c4 \ub098\uc640\uc788\ub4ef\uc774 \ubc31\uc5c5\uc6a9 \uc11c\ubc84\uac00 \ub530\ub85c \ud544\uc694\ud569\ub2c8\ub2e4. <br> \u2192 Cloud DB For MSSQL\uc5d0\uc11c\ub294 \uc77c\ubcc4 \ub2e8\uc704 \ubc31\uc5c5\ub9cc \uac00\ub2a5\ud558\uae30 \ub54c\ubb38.<\/p>\n\n\n\n<p>\ubc31\uc5c5 \uc11c\ubc84\ub97c  \ub530\ub85c \uad6c\uc131\ud558\ub294 \uac83\uae4c\uc9c0\ub294 \uac00\uc774\ub4dc\uc640 \ub3d9\uc77c\ud558\uc9c0\ub9cc \ube44\uc6a9 \ucd5c\uc801\ud654\ub97c \uc704\ud574 OS \ubc0f \uc800\uc7a5 \ubc29\uc2dd \ub4f1\uc744 \ub2e4\uc591\ud558\uac8c \uace0\ub824\ud558\uc600\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<p><strong>1) \uc11c\ubc84 \uc0dd\uc131<\/strong><br><strong>OS :<\/strong> Ubuntu 20.04 (KVM)<br><strong>\uc2a4\ud399<\/strong> : Micro (mi1-g3)<\/p>\n\n\n\n<p>Windows \uc11c\ubc84\uc5d0 High-CPU \ucd5c\uc18c \uc2a4\ud399\uc778 2vCPU, 4Memory \uc11c\ubc84\ub97c \ucd94\uac00\ud55c\ub2e4\uba74 MSSQL \ubc31\uc5c5\ub54c\ubb38\uc5d0 \uc6d4 10\ub9cc\uc6d0\uc758 \ube44\uc6a9\uc774 \ucd94\uac00\ub85c \ubc1c\uc0dd\ud558\uac8c \ub420 \uac83\uc785\ub2c8\ub2e4. \ub530\ub77c\uc11c \uc774\ub97c \ucd5c\uc18c\ud654\ud558\uae30 \uc704\ud574 OS\ub97c Ubuntu\ub97c \uc0ac\uc6a9\ud558\uae30\ub85c \ud588\uace0 Micro Type\uc73c\ub85c \uc0dd\uc131\ud558\uc600\uc2b5\ub2c8\ub2e4.<br> \u2192 High-CPU \ud0c0\uc785\uc5d0 Windows\ub85c \uc0dd\uc131\ud55c\ub2e4\uba74 \uc6d4 \uc57d 10\ub9cc\uc6d0, Micro \ud0c0\uc785\uc5d0 Ubuntu\ub85c \uc0dd\uc131 \uc2dc \uc6d4 1\ub9cc\uc6d0\ub300\uc5d0\uc11c \ud574\uacb0 \uac00\ub2a5<br> \u2192 \ubb3c\ub860 \uc544\ub798 \ubaa8\ub4e0 \ubc31\uc5c5 \uacfc\uc815\uc744 \uc11c\ubc84 \uc2dc\uc791 \uc2dc\uc5d0 \ub3d9\uc791\ud558\uac8c\ud558\uace0 \ubc31\uc5c5\uc774 \ub05d\ub098\uba74 \uc11c\ubc84\ub97c \uc885\ub8cc\ub418\ub3c4\ub85d \ud558\uaca0\ub2e4\ub77c\uace0 \ud55c\ub2e4\uba74 \uc11c\ubc84 \uc2a4\ud399\uc744 High-CPU\ub85c \ubcc0\uacbd\ud558\uc5ec \uc0ac\uc6a9\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<br>(Micro Type\uc740 \uc2dc\uac04 \uc694\uae08\uc81c\uac00 \ubd88\uac00\ub2a5\ud558\ubbc0\ub85c High-CPU\ub85c \uc120\ud0dd\ud574\uc57c \uc2dc\uac04 \uc694\uae08\uc81c \uac00\ub2a5)<\/p>\n\n\n\n<p><strong>2) Samba \uad6c\ucd95<\/strong><\/p>\n\n\n\n<ul>\n<li>Samba \uc124\uce58<\/li>\n<\/ul>\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=\"\">apt update\napt install samba<\/pre>\n\n\n\n<ul>\n<li>Samba \uc124\uc815<\/li>\n<\/ul>\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=\"\">cp -avp \/etc\/samba\/smb.conf \/etc\/samba\/smb.conf_org\nvi \/etc\/samba\/smb.conf<\/pre>\n\n\n\n<p>cmb.conf\uc5d0 \uc544\ub798 \ub0b4\uc6a9 \ucd94\uac00<\/p>\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=\"\">[backup]\npath = \/backup\nbrowsable = yes\nwritable = yes\nguest ok = yes\ncreate mask = 0777\ndirectory mask = 0777<\/pre>\n\n\n\n<ul>\n<li>\uacf5\uc720\ud560 \ub514\ub809\ud1a0\ub9ac \uc0dd\uc131 \ubc0f \uad8c\ud55c \ucd94\uac00<\/li>\n<\/ul>\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=\"\">mkdir \/backup\nchmod 777 \/backup<\/pre>\n\n\n\n<ul>\n<li>Samba \uc7ac\uc2dc\uc791<\/li>\n<\/ul>\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=\"\">systemctl restart smbd<\/pre>\n\n\n\n<p><strong>3) aws cli \uc0ac\uc804 \uc900\ube44<\/strong><\/p>\n\n\n\n<ul>\n<li>aws cli \uc124\uce58<\/li>\n<\/ul>\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=\"\">apt install pip\npip install awscli==1.15.85<\/pre>\n\n\n\n<ul>\n<li>\uc778\uc99d \uc815\ubcf4 \uc124\uc815<\/li>\n<\/ul>\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=\"\">aws configure\nAWS Access Key ID [None]: ACCESS_KEY_ID\nAWS Secret Access Key [None]: SECRET_KEY\nDefault region name [None]:\nDefault output format [None]:<\/pre>\n\n\n\n<p><strong>4) sqlcmd \uc124\uce58<\/strong><\/p>\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=\"\">wget -qO- https:\/\/packages.microsoft.com\/keys\/microsoft.asc | sudo apt-key add -\nadd-apt-repository \"$(wget -qO- https:\/\/packages.microsoft.com\/config\/ubuntu\/20.04\/mssql-server-2019.list)\"<\/pre>\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=\"\">curl https:\/\/packages.microsoft.com\/keys\/microsoft.asc | sudo apt-key add -\ncurl https:\/\/packages.microsoft.com\/config\/ubuntu\/20.04\/prod.list | sudo tee \/etc\/apt\/sources.list.d\/msprod.list<\/pre>\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=\"\">apt install mssql-tools unixodbc-dev<\/pre>\n\n\n\n<p><strong>5) ACG(Access Control Group) \uc124\uc815<\/strong><\/p>\n\n\n\n<ul>\n<li>Backup \uc11c\ubc84 ACG \uc124\uc815<br>\uc544\ub798\uc640 \uac19\uc774 Cloud DB for MSSQL \uc11c\ubc84\uc5d0\uc11c Backup \uc11c\ubc84\ub85c TCP 445 Inbound \ud1b5\uc2e0\uc774 \uac00\ub2a5\ud558\ub3c4\ub85d \ucd94\uac00\ud574\uc90d\ub2c8\ub2e4. (Backup \uc11c\ubc84\uc5d0 \uc5f0\uacb0\ub41c ACG\uc5d0\uc11c \uc124\uc815)<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"999\" height=\"228\" src=\"https:\/\/cdn.manvscloud.com\/wp-content\/uploads\/2024\/01\/31222236\/image-5.png\" alt=\"\" class=\"wp-image-2625\" srcset=\"https:\/\/cdn.manvscloud.com\/wp-content\/uploads\/2024\/01\/31222236\/image-5.png 999w, https:\/\/cdn.manvscloud.com\/wp-content\/uploads\/2024\/01\/31222236\/image-5-300x68.png 300w, https:\/\/cdn.manvscloud.com\/wp-content\/uploads\/2024\/01\/31222236\/image-5-768x175.png 768w\" sizes=\"(max-width: 999px) 100vw, 999px\" \/><\/figure>\n\n\n\n<ul>\n<li>Cloud DB for MSSQL ACG \uc124\uc815<br>\uc544\ub798\uc640 \uac19\uc774 Cloud DB for MSSQL \uc11c\ubc84\uc5d0\uc11c Backup \uc11c\ubc84\ub85c TCP 445 Outbound \ud1b5\uc2e0\uc774 \uac00\ub2a5\ud558\ub3c4\ub85d \ucd94\uac00\ud574\uc90d\ub2c8\ub2e4. (Cloud DB for MSSQL \uc11c\ubc84\uc5d0 \uc5f0\uacb0\ub41c ACG\uc5d0\uc11c \uc124\uc815)<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"959\" height=\"214\" src=\"https:\/\/cdn.manvscloud.com\/wp-content\/uploads\/2024\/01\/31222450\/image-6.png\" alt=\"\" class=\"wp-image-2626\" srcset=\"https:\/\/cdn.manvscloud.com\/wp-content\/uploads\/2024\/01\/31222450\/image-6.png 959w, https:\/\/cdn.manvscloud.com\/wp-content\/uploads\/2024\/01\/31222450\/image-6-300x67.png 300w, https:\/\/cdn.manvscloud.com\/wp-content\/uploads\/2024\/01\/31222450\/image-6-768x171.png 768w\" sizes=\"(max-width: 959px) 100vw, 959px\" \/><\/figure>\n\n\n\n<p><strong>6) \uc2a4\ud06c\ub9bd\ud2b8 \uc791\uc131<\/strong><\/p>\n\n\n\n<ul>\n<li>\uc258 \uc2a4\ud06c\ub9bd\ud2b8 \uc0dd\uc131<\/li>\n<\/ul>\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=\"\">vi ms_backup.sh<\/pre>\n\n\n\n<p>\uc544\ub798 \uc0d8\ud50c \uc2a4\ud06c\ub9bd\ud2b8\ub97c \ucc38\uace0\ud558\uc5ec \uc791\uc131<\/p>\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=\"\">#!\/bin\/bash\n\n# Slack Webhook URL\nSLACK_WEBHOOK_URL=\"WEBHOOK_URL\"\n\n\n# SQL Server \uc811\uc18d \uc815\ubcf4\nSERVER='MSSQL_PRIVATE_DOMAIN'\nDATABASE='DATABASE_NAME'\nUSER='USERNAME'\nPASSWORD='PASSWORD'\n\n# \ubc31\uc5c5 \ud30c\uc77c \uacbd\ub85c \uc124\uc815\nBACKUP_PATH='\\\\BACKUP_SERVER_IP\\backup\\'\nBACKUP_FILE_NAME=\"manvscloud_$(date +%Y%m%d_%H%M%S).bak\"\nBACKUP_FILE_FULL_PATH=\"${BACKUP_PATH}${BACKUP_FILE_NAME}\"\nLOCAL_BACKUP_PATH='\/backup\/'\nLOCAL_FILE_FULL_PATH=\"${LOCAL_BACKUP_PATH}${BACKUP_FILE_NAME}\"\n\n# Object Storage \uacbd\ub85c\nS3_PATH=\"s3:\/\/OBJECT_STORAGE_NAME\/$(date +%Y)\/${BACKUP_FILE_NAME}\"\n\n# SQL Server \ubc31\uc5c5 \uba85\ub839\nSQLCMD=\"\/opt\/mssql-tools\/bin\/sqlcmd\"\nQUERY=\"BACKUP DATABASE [$DATABASE] TO DISK = N'$BACKUP_FILE_FULL_PATH'\"\n\n# \ubc31\uc5c5 \uc2e4\ud589\n$SQLCMD -S $SERVER -U $USER -P $PASSWORD -Q \"$QUERY\"\n\n# \ubc31\uc5c5 \uc131\uacf5 \ud655\uc778 \ubc0f Object Storage\ub85c \uc774\ub3d9\nif [ $? -eq 0 ]; then\n    # AWS CLI\ub97c \uc0ac\uc6a9\ud558\uc5ec \ubc31\uc5c5 \ud30c\uc77c\uc744 Object Storage\ub85c \uc804\uc1a1\n    aws --endpoint-url=https:\/\/kr.object.ncloudstorage.com s3 cp \"$LOCAL_FILE_FULL_PATH\" \"$S3_PATH\"\n    if [ $? -eq 0 ]; then\n        curl -X POST --data-urlencode \"payload={\\\"text\\\": \\\"\ubc31\uc5c5 \ubc0f \ud30c\uc77c \uc5c5\ub85c\ub4dc\uac00 \uc815\uc0c1\uc801\uc73c\ub85c \uc644\ub8cc\ub418\uc5c8\uc2b5\ub2c8\ub2e4.\\\"}\" $SLACK_WEBHOOK_URL\n        rm -f \"$LOCAL_FILE_FULL_PATH\"\n    else\n        curl -X POST --data-urlencode \"payload={\\\"text\\\": \\\"\ubc31\uc5c5\uc5d0 \uc131\uacf5\ud588\uc73c\ub098 Object Storage\ub85c \ud30c\uc77c \uc5c5\ub85c\ub4dc\uac00 \uc2e4\ud328\ud588\uc2b5\ub2c8\ub2e4.\\\"}\" $SLACK_WEBHOOK_URL\n    fi\nelse\n    curl -X POST --data-urlencode \"payload={\\\"text\\\": \\\"\ubc31\uc5c5\uc5d0 \uc2e4\ud328\ud588\uc2b5\ub2c8\ub2e4.\\\"}\" $SLACK_WEBHOOK_URL\nfi\n<\/pre>\n\n\n\n<p>WEBHOOK_URL, MSSQL_PRIVATE_DOMAIN, DATABASE_NAME, USERNAME, PASSWORD, BACKUP_SERVER_IP, OBJECT_STORAGE_NAME \uc744 \uac01\uc790 \ud658\uacbd\uc5d0 \ub9de\uac8c \uc785\ub825\ud574\uc918\uc57c\ud569\ub2c8\ub2e4.<\/p>\n\n\n\n<p>\ub610\ud55c S3_PATH \ubd80\ubd84\uc5d0\uc11c $(date +%Y)\ub294 \uc81c\uac00 Object Storage\uc5d0\uc11c \uc544\ub798 \uc774\ubbf8\uc9c0\uc640 \uac19\uc774 \uc5f0\ub3c4\ubcc4 \ud3f4\ub354\ub97c \ub9cc\ub4e4\uc5b4\ub480\uae30\ub54c\ubb38\uc785\ub2c8\ub2e4.<\/p>\n\n\n\n<p>\uc2a4\ud06c\ub9bd\ud2b8\ub97c \uc218\uc815\ud558\uc5ec \uc5f0\ub3c4\ubcc4, \uc6d4\ubcc4 \ub4f1 \uc138\ubd84\ud654\ud558\uace0 \ud3f4\ub354\uac00 \uc5c6\uc744 \uacbd\uc6b0 \ud3f4\ub354\ub97c \uc0dd\uc131\ud558\ub3c4\ub85d \ud560 \uc218\ub3c4 \uc788\uc2b5\ub2c8\ub2e4. <\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"774\" height=\"346\" src=\"https:\/\/cdn.manvscloud.com\/wp-content\/uploads\/2024\/01\/31173847\/image-2.png\" alt=\"\" class=\"wp-image-2617\" srcset=\"https:\/\/cdn.manvscloud.com\/wp-content\/uploads\/2024\/01\/31173847\/image-2.png 774w, https:\/\/cdn.manvscloud.com\/wp-content\/uploads\/2024\/01\/31173847\/image-2-300x134.png 300w, https:\/\/cdn.manvscloud.com\/wp-content\/uploads\/2024\/01\/31173847\/image-2-768x343.png 768w\" sizes=\"(max-width: 774px) 100vw, 774px\" \/><\/figure>\n\n\n\n<p><strong>7) \uc2a4\ud06c\ub9bd\ud2b8 \uc2e4\ud589 \ubc0f \ud655\uc778<\/strong><\/p>\n\n\n\n<ul>\n<li>\uc2a4\ud06c\ub9bd\ud2b8 \uc2e4\ud589<\/li>\n<\/ul>\n\n\n\n<p>\uc2a4\ud06c\ub9bd\ud2b8\uac00 \uc791\uc131\ub418\uc5c8\ub2e4\uba74 \uc2a4\ud06c\ub9bd\ud2b8\ub97c \uc2e4\ud589\ud569\ub2c8\ub2e4.<\/p>\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=\"\">sh ms_backup.sh<\/pre>\n\n\n\n<p>\uc2a4\ud06c\ub9bd\ud2b8 \uc2e4\ud589 \uc2dc \ubc31\uc5c5 \ubc0f \ud30c\uc77c \uc5c5\ub85c\ub4dc\uac00 \uc9c4\ud589\ub418\uba70 \uc131\uacf5\/\uc2e4\ud328\uc5d0 \ub300\ud574\uc11c \uc544\ub798\uc640 \uac19\uc774 Slack\uc73c\ub85c \uc54c\ub9bc\ub3c4 \ubc1b\uc744 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"878\" height=\"261\" src=\"https:\/\/cdn.manvscloud.com\/wp-content\/uploads\/2024\/01\/31173940\/image-3.png\" alt=\"\" class=\"wp-image-2619\" srcset=\"https:\/\/cdn.manvscloud.com\/wp-content\/uploads\/2024\/01\/31173940\/image-3.png 878w, https:\/\/cdn.manvscloud.com\/wp-content\/uploads\/2024\/01\/31173940\/image-3-300x89.png 300w, https:\/\/cdn.manvscloud.com\/wp-content\/uploads\/2024\/01\/31173940\/image-3-768x228.png 768w\" sizes=\"(max-width: 878px) 100vw, 878px\" \/><\/figure>\n\n\n\n<p>\uc815\ub9d0 \ubc31\uc5c5\uc774 \ub418\uc5c8\ub294\uc9c0, \ud30c\uc77c \uc5c5\ub85c\ub4dc\uac00 \ub418\uc5c8\ub294\uc9c0\ub3c4 Object Storage \ubc84\ud0b7\uc5d0\uc11c \ud655\uc778\ud574\ubcf4\uba74 \uc544\ub798\uc640 \uac19\uc774 \ubc31\uc5c5 \ud30c\uc77c\uc774 \uc5c5\ub85c\ub4dc\ub418\uc5b4 \uc788\ub294 \uac83\uc744 \ud655\uc778\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"581\" src=\"https:\/\/cdn.manvscloud.com\/wp-content\/uploads\/2024\/01\/31175947\/image-4-1024x581.png\" alt=\"\" class=\"wp-image-2621\" srcset=\"https:\/\/cdn.manvscloud.com\/wp-content\/uploads\/2024\/01\/31175947\/image-4-1024x581.png 1024w, https:\/\/cdn.manvscloud.com\/wp-content\/uploads\/2024\/01\/31175947\/image-4-300x170.png 300w, https:\/\/cdn.manvscloud.com\/wp-content\/uploads\/2024\/01\/31175947\/image-4-768x436.png 768w, https:\/\/cdn.manvscloud.com\/wp-content\/uploads\/2024\/01\/31175947\/image-4-1080x613.png 1080w, https:\/\/cdn.manvscloud.com\/wp-content\/uploads\/2024\/01\/31175947\/image-4.png 1255w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>\uc774\uc81c \ud574\ub2f9 \uc2a4\ud06c\ub9bd\ud2b8\ub97c crontab\uc744 \uc774\uc6a9\ud558\uc5ec \uc6d0\ud558\ub294 \uc2dc\uac04\ub300\ub9c8\ub2e4 \uc2e4\ud589\ub418\ub3c4\ub85d \uc124\uc815\ud574\uc8fc\uba74 \uc2dc\uac04\ubcc4 \ubc31\uc5c5\uc774 \uac00\ub2a5\ud569\ub2c8\ub2e4. \ub610\ud55c Object Storage\uc758 LifeCycle Management \uae30\ub2a5\uc744 \uc774\uc6a9\ud558\uc5ec \uc624\ub798\ub41c \ubc31\uc5c5 \ud30c\uc77c\uc740 \uc0ad\uc81c\ub418\ub3c4\ub85d \uad00\ub9ac\ub3c4 \ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<ul>\n<li>crontab \uc608\uc2dc<\/li>\n<\/ul>\n\n\n\n<p>\ub9e4\uc77c 3\uc2dc\uac04\ub9c8\ub2e4 \/root\/ms_backup.sh \uc2a4\ud06c\ub9bd\ud2b8 \uc2e4\ud589<\/p>\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=\"\">0 *\/3 * * * root sh \/root\/ms_backup.sh<\/pre>\n\n\n\n<p>Block Storage\uc5d0 \ube44\ud574 Object Storage\uac00 \ub370\uc774\ud130 \uc800\uc7a5 \ube44\uc6a9\uc774 \uc2f8\uace0 Block Storage\uc758 \uacbd\uc6b0 \uace0\uc815 \ucd5c\ub300 \uc6a9\ub7c9\uc744 \uacc4\uc18d \uc720\uc9c0\ud558\uc5ec \ube44\uc6a9\uc774 \ub098\uac00\ub294 \ubc18\uba74 Object Storage\ub294 \uc0ac\uc6a9\ud55c \ub370\uc774\ud130 \uc800\uc7a5\ub7c9\ub9cc\ud07c \ube44\uc6a9\uc774 \ubc1c\uc0dd\ud558\uae30\ub54c\ubb38\uc5d0 \ube44\uc6a9\uc744 \ub354\uc6b1 \ucd5c\uc801\ud654\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<p>\ub9c8\uc9c0\ub9c9\uc73c\ub85c \uc0dd\uc131\ub41c \ubc31\uc5c5 \ud30c\uc77c\uc744 \uc774\uc6a9\ud558\uc5ec \ubcf5\uad6c\ub97c \uc9c4\ud589\ud574\ubcf4\uace0 \uc2f6\uc73c\uc2dc\ub2e4\uba74 \ub370\uc774\ud130 \ub9c8\uc774\uadf8\ub808\uc774\uc158(\ubc31\uc5c5 \ubcf5\uad6c) \uac00\uc774\ub4dc\ub97c \ucc38\uace0\ud558\uc5ec \uc9c4\ud589\ud574\ubcf4\uc2dc\uba74 \ub420 \uac83\uac19\uc2b5\ub2c8\ub2e4.<br>(\uac1c\uc778\uc801\uc73c\ub85c \ubcf5\uad6c \ud14c\uc2a4\ud2b8 \uc2dc \uc815\uc0c1 \ubcf5\uad6c\ub418\uc5c8\uc2b5\ub2c8\ub2e4.)<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3 class=\"wp-block-heading has-white-color has-cyan-bluish-gray-background-color has-text-color has-background\"> Personal Comments<\/h3>\n\n\n\n<p>\ub370\uc774\ud130\ub294 \ubaa8\ub4e0 \ube44\uc988\ub2c8\uc2a4\uc758 \ud575\uc2ec\uc774\uba70 \uadf8 \ubcf4\ud638\ub294 \ud544\uc218\uc801\uc785\ub2c8\ub2e4. \uc774 \ud3ec\uc2a4\ud305\uc5d0\uc11c \ub9d0\ud558\uace0\uc790\ud558\ub294 \uc790\ub3d9 \ubc31\uc5c5 \ubc0f \uc54c\ub9bc \uc2dc\uc2a4\ud15c\uc740 \ub370\uc774\ud130\ub97c \uc548\uc804\ud558\uac8c \uc720\uc9c0\ud558\ub294 \ub370 \uc911\uc694\ud55c \uc5ed\ud560\uc744 \ud560 \uac83\uc785\ub2c8\ub2e4. \uc774 \uae00\uc5d0 \uc791\uc131\ub41c \uc2dc\uac04 \ub2e8\uc704 \ubc31\uc5c5 \ubc29\ubc95\uc774 \uc815\ub2f5\uc740 \uc544\ub2c8\uc9c0\ub9cc \uc120\ud0dd\ud560 \uc218 \uc788\ub294 \ud558\ub098\uc758 \ubc29\ubc95\uc774 \ub418\uae38 \ubc14\ub78d\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-alpha-channel-opacity\"\/>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"800\" height=\"137\" src=\"https:\/\/cdn.manvscloud.com\/wp-content\/uploads\/2021\/08\/10202040\/ncloud-master.png\" alt=\"\" class=\"wp-image-1221\" srcset=\"https:\/\/cdn.manvscloud.com\/wp-content\/uploads\/2021\/08\/10202040\/ncloud-master.png 800w, https:\/\/cdn.manvscloud.com\/wp-content\/uploads\/2021\/08\/10202040\/ncloud-master-300x51.png 300w, https:\/\/cdn.manvscloud.com\/wp-content\/uploads\/2021\/08\/10202040\/ncloud-master-768x132.png 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>\uc548\ub155\ud558\uc138\uc694 MANVSCLOUD \uae40\uc218\ud604\uc785\ub2c8\ub2e4. \ub370\uc774\ud130\ub294 \ud604\ub300 \ube44\uc988\ub2c8\uc2a4\uc758 \uc2ec\uc7a5\uacfc\ub3c4 \uac19\uc2b5\ub2c8\ub2e4. \uae30\uc5c5\ub4e4\uc740 \uace0\uac1d \uc815\ubcf4, \uac70\ub798 \ub0b4\uc5ed, \uc6b4\uc601 \ub370\uc774\ud130 \ub4f1\uc744 \uc2e4\uc2dc\uac04\uc73c\ub85c \ucc98\ub9ac\ud558\uace0 \uc774 \ub370\uc774\ud130\ub294 \uadf8\ub4e4\uc758 \uc758\uc0ac\uacb0\uc815\uacfc \uc11c\ube44\uc2a4 \ud488\uc9c8\uc744 \uacb0\uc815\uc9d3\ub294 \uc911\uc694\ud55c \uc694\uc18c\uac00 \ub418\uace0 \uc788\uc2b5\ub2c8\ub2e4. \uadf8\ub798\uc11c \ub370\uc774\ud130\uc758 \uc548\uc804\ud55c \ubcf4\uad00\uacfc \uc2e0\uc18d\ud55c \ubcf5\uad6c\ub294 \uc5b4\ub290 \ub54c\ubcf4\ub2e4 \uc911\uc694\ud55c \uacfc\uc81c\uac00 \ub418\uc5c8\uc2b5\ub2c8\ub2e4. \ub124\uc774\ubc84 \ud074\ub77c\uc6b0\ub4dc\ubfd0\ub9cc \uc544\ub2c8\ub77c AWS \ub4f1 \uad00\ub9ac\ud615 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc11c\ube44\uc2a4 \uc790\uccb4 \uae30\ub2a5\uc5d0\uc11c\ub294 \uae30\ubcf8\uc801\uc73c\ub85c \ud558\ub8e8 \ud2b9\uc815 \uc2dc\uac04\uc5d0 1\ud68c \ubc31\uc5c5\uc774 \uc9c4\ud589\ub418\ub3c4\ub85d \uc124\uc815\uc774 \uac00\ub2a5\ud55c\ub370\uc694. \uc694\uad6c \uc0ac\ud56d\uc5d0 \ub530\ub77c \ud558\ub8e8\uc5d0 \ud55c \ubc88\uc758 \ubc31\uc5c5\uc774 \ucda9\ubd84\ud558\uc9c0 \uc54a\uc744 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc608\ub97c \ub4e4\uc5b4 \ub9e4\uc6b0 \ube48\ubc88\ud558\uac8c \ub370\uc774\ud130\uac00 \ubcc0\uacbd\ub418\uac70\ub098 \uc2e4\uc2dc\uac04 \ub370\uc774\ud130 \ucc98\ub9ac\uac00 \uc911\uc694\ud55c \ube44\uc988\ub2c8\uc2a4\uc5d0\uc11c\ub294 \ub354 \uc790\uc8fc \ub370\uc774\ud130\ub97c \ubc31\uc5c5\ud560 \ud544\uc694\uac00 \uc788\uc2b5\ub2c8\ub2e4. \uc624\ub298 \ud3ec\uc2a4\ud305\uc740 \ub124\uc774\ubc84 \ud074\ub77c\uc6b0\ub4dc\uc758 Cloud DB For MSSQL \uc11c\ube44\uc2a4\uc5d0\uc11c \uc2dc\uac04 \ub2e8\uc704\ub85c \ub370\uc774\ud130\ub97c \ubc31\uc5c5\ud558\ub294 \ubc29\ubc95\uc744 \uc18c\uac1c\ud558\ub824\uace0 \ud569\ub2c8\ub2e4. \uc774\ub294 \uc7a5\uc560 \ubc1c\uc0dd \uc2dc \ub370\uc774\ud130 \ubcf5\uad6c \uc2dc\uc810\uc758 \uc815\ud655\uc131\uc744 \ub192\uc774\uace0 \ub370\uc774\ud130 \uc190\uc2e4\uc758 \uc704\ud5d8\uc744 \ucd5c\uc18c\ud654\ud558\ub294 \ub370 \ub3c4\uc6c0\uc774 \ub418\uba70 \uc774\ub7ec\ud55c \ubc31\uc5c5 \uc804\ub7b5\uc740 \ube44\uc988\ub2c8\uc2a4 \uc5f0\uc18d\uc131\uacfc \ub370\uc774\ud130 \ubb34\uacb0\uc131\uc744 \ubcf4\uc7a5\ud558\ub294 \ub370 \ud575\uc2ec\uc801\uc778 \uc694\uc18c\uac00 \ub420 \uac83\uc785\ub2c8\ub2e4. \uc2dc\uc791\ud558\uae30 \uc804\uc5d0&#8230; https:\/\/guide.ncloud-docs.com\/docs\/clouddbformssql-start-vpc#%EB%8D%B0%EC%9D%B4%ED%84%B0-%EB%A7%88%EC%9D%B4%EA%B7%B8%EB%A0%88%EC%9D%B4%EC%85%98%EB%B0%B1%EC%97%85-%EB%B3%B5%EA%B5%AC Cloud DB for MSSQL \ubc31\uc5c5 \uc11c\ubc84 \uad6c\uc131 \uc704 \ub370\uc774\ud130 \ub9c8\uc774\uadf8\ub808\uc774\uc158(\ubc31\uc5c5 \ubcf5\uad6c) \uac00\uc774\ub4dc\uc5d0\uc11c\ub3c4 \ub098\uc640\uc788\ub4ef\uc774 \ubc31\uc5c5\uc6a9 \uc11c\ubc84\uac00 \ub530\ub85c \ud544\uc694\ud569\ub2c8\ub2e4. \u2192 Cloud DB For MSSQL\uc5d0\uc11c\ub294 \uc77c\ubcc4 \ub2e8\uc704 \ubc31\uc5c5\ub9cc \uac00\ub2a5\ud558\uae30 \ub54c\ubb38. \ubc31\uc5c5 \uc11c\ubc84\ub97c \ub530\ub85c \uad6c\uc131\ud558\ub294 \uac83\uae4c\uc9c0\ub294 \uac00\uc774\ub4dc\uc640 \ub3d9\uc77c\ud558\uc9c0\ub9cc \ube44\uc6a9 \ucd5c\uc801\ud654\ub97c \uc704\ud574 OS \ubc0f \uc800\uc7a5 \ubc29\uc2dd \ub4f1\uc744 \ub2e4\uc591\ud558\uac8c \uace0\ub824\ud558\uc600\uc2b5\ub2c8\ub2e4. 1) \uc11c\ubc84 \uc0dd\uc131OS : Ubuntu 20.04 (KVM)\uc2a4\ud399 : Micro (mi1-g3) Windows \uc11c\ubc84\uc5d0 High-CPU \ucd5c\uc18c \uc2a4\ud399\uc778 2vCPU, 4Memory \uc11c\ubc84\ub97c \ucd94\uac00\ud55c\ub2e4\uba74 MSSQL \ubc31\uc5c5\ub54c\ubb38\uc5d0 [&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":"","jetpack_seo_html_title":"","jetpack_seo_noindex":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[3],"tags":[505,32,87,91,17,90,16,935,89,202,398,509,711],"jetpack_sharing_enabled":true,"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/manvscloud.com\/index.php?rest_route=\/wp\/v2\/posts\/2611"}],"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=2611"}],"version-history":[{"count":10,"href":"https:\/\/manvscloud.com\/index.php?rest_route=\/wp\/v2\/posts\/2611\/revisions"}],"predecessor-version":[{"id":2627,"href":"https:\/\/manvscloud.com\/index.php?rest_route=\/wp\/v2\/posts\/2611\/revisions\/2627"}],"wp:attachment":[{"href":"https:\/\/manvscloud.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2611"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/manvscloud.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2611"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/manvscloud.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2611"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}