{"id":4940,"date":"2021-10-06T15:21:33","date_gmt":"2021-10-06T06:21:33","guid":{"rendered":"\/blog\/?p=4940"},"modified":"2023-09-21T09:26:28","modified_gmt":"2023-09-21T00:26:28","slug":"ms-sql-%eb%b0%b1%ec%97%85-%ec%8a%a4%ed%81%ac%eb%a6%bd%ed%8a%b8","status":"publish","type":"post","link":"https:\/\/hasu0707.duckdns.org\/blog\/?p=4940","title":{"rendered":"[MS-SQL] \ubc31\uc5c5 \uc2a4\ud06c\ub9bd\ud2b8"},"content":{"rendered":"\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"powershell\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"true\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">@ECHO OFF\nCHCP 65001 1> NUL 2> NUL\nREM #################################################################\nREM #\nREM # Microsoft SQL \ubc31\uc5c5 \uc2a4\ud06c\ub9bd\ud2b8\nREM #\nREM #################################################################\n\nREM #################################################################\nREM # \uba85\uba85\ub41c \ud30c\uc774\ud504 \uc624\ub958 \ubc1c\uc0dd \uc2dc...\nREM # SQLServerManager12.msc \uc2e4\ud589 \ud6c4 SQL Server \ub124\ud2b8\uc6cc\ud06c \uad6c\uc131 > MSSQLSERVER\uc5d0 \ub300\ud55c \ud504\ub85c\ud1a0\ucf5c > \uba85\uba85\ub41c \ud30c\uc774\ud504 (\uc0ac\uc6a9)\nREM #\nREM # \uc778\uc2a4\ud134\uc2a4 \uba85 \uc54c\uc544\ub0b4\uae30 (\ucd9c\ub825\uac12\uc758 \uc67c\ucabd \ubb38\uc790\uc5f4\uc774 \uc778\uc2a4\ud134\uc2a4 \uba85)\nREM # REG QUERY \"HKLM\\SOFTWARE\\Microsoft\\Microsoft SQL Server\\Instance Names\\SQL\"\nREM #################################################################\n\nREM #################################################################\nREM #\nREM # \ubcc0\uc218 \uc815\uc758\nREM #\nREM #################################################################\nSET \"INSTANCE_NAME=MSSQLSERVER\"\nSET \"DB_NAME=webinspect_1910\"\nSET \"BACKUP_DIR=C:\\db_backup\"\nSET \"SCHTASKS_NAME=db_backup\"\nSET \"TEMP_SQL=%TEMP%\\__tmp__.sql\"\n\nREM #################################################################\nREM #\nREM # \uc708\ub3c4\uc6b0 \uc2a4\ucf00\uc904\ub7ec \ub4f1\ub85d\nREM #\nREM #################################################################\nECHO SCHTASKS \/DELETE \/F \/TN \"%SCHTASKS_NAME%\"\nREM ------------------------------------------------------------------\nREM \ub9e4\uc8fc \uc77c\uc694\uc77c \uc624\uc804 01:00\uc5d0 \uc2e4\ud589 (\uad00\ub9ac\uc790 \uad8c\ud55c\uc73c\ub85c \uc2e4\ud589)\nREM ------------------------------------------------------------------\nSET SCHTASKS_RUN=%CD%\\%0\"\nECHO SCHTASKS \/CREATE \/F \/SC WEEKLY \/D SUN \/ST 01:00 \/TN \"%SCHTASKS_NAME%\" \/TR \"%SCHTASKS_RUN%\"\n\nREM #################################################################\nREM #\nREM # \ubc31\uc5c5 SQL \ubb38\uc744 \uc791\uc131\ud55c\ub2e4.\nREM #\nREM #################################################################\nECHO DECLARE @name NVARCHAR(256) -- database name > %TEMP_SQL%\nECHO DECLARE @path NVARCHAR(512) -- path for backup files >> %TEMP_SQL%\nECHO DECLARE @fileName NVARCHAR(512) -- filename for backup >> %TEMP_SQL%\nECHO DECLARE @fileDate NVARCHAR(40) -- used for file name >> %TEMP_SQL%\nECHO. >> %TEMP_SQL%\nECHO SET @name = '%DB_NAME%' >> %TEMP_SQL%\nECHO. >> %TEMP_SQL%\nECHO -- specify database backup directory >> %TEMP_SQL%\nECHO SET @path = '%BACKUP_DIR%\\' >> %TEMP_SQL%\nECHO. >> %TEMP_SQL%\nECHO -- specify filename format >> %TEMP_SQL%\nECHO SELECT @fileDate = CONVERT(NVARCHAR(20),GETDATE(),112) + '_' + REPLACE(CONVERT(NVARCHAR(20),GETDATE(),108),':','') >> %TEMP_SQL%\nECHO. >> %TEMP_SQL%\nECHO SET @fileName = @path + @name + '_' + @fileDate + '.bak' >> %TEMP_SQL%\nECHO BACKUP DATABASE @name TO DISK = @fileName WITH FORMAT, INIT, NAME = @fileDate, SKIP, REWIND, UNLOAD, STATS=10 >> %TEMP_SQL%\nECHO. >> %TEMP_SQL%\nECHO GO >> %TEMP_SQL%\n\nREM #################################################################\nREM #\nREM # \ubc31\uc5c5 SQL\uc744 \uc2e4\ud589 \uc2dc\ud0a8\ub2e4.\nREM #\nREM #################################################################\nREM SqlCmd -S \"HP-COMPAQ6000\\MSSQLSERVER\"\nREM SqlCmd -E -S \"%COMPUTERNAME%\\%INSTANCE_NAME%\" -l 30 -i \"%TEMP_SQL%\"\nSqlCmd -E -S \"%COMPUTERNAME%\" -l 30 -i \"%TEMP_SQL%\"\nDEL \/Q \/F \"%TEMP_SQL%\"<\/pre>\n","protected":false},"excerpt":{"rendered":"","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_import_markdown_pro_load_document_selector":0,"_import_markdown_pro_submit_text_textarea":"","site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[10],"tags":[],"class_list":["post-4940","post","type-post","status-publish","format-standard","hentry","category-computing_database"],"_links":{"self":[{"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=\/wp\/v2\/posts\/4940","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=4940"}],"version-history":[{"count":0,"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=\/wp\/v2\/posts\/4940\/revisions"}],"wp:attachment":[{"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=4940"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=4940"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=4940"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}