{"id":20,"date":"2009-10-09T13:26:53","date_gmt":"2009-10-09T13:26:53","guid":{"rendered":"http:\/\/anyons.net\/dev\/?p=20"},"modified":"2022-07-12T14:49:27","modified_gmt":"2022-07-12T05:49:27","slug":"sql-server-%eb%b0%b1%ec%97%85%ec%9d%84-%ed%95%98%ea%b2%8c-%ed%95%98%ea%b8%b0-%ec%9c%84%ed%95%9c-%ec%8a%a4%ed%81%ac%eb%a6%bd%ed%8a%b8","status":"publish","type":"post","link":"https:\/\/anyons.net\/?p=20","title":{"rendered":"sql server \ubc31\uc5c5\uc744 \ud558\uac8c \ud558\uae30 \uc704\ud55c \uc2a4\ud06c\ub9bd\ud2b8"},"content":{"rendered":"<pre class=\"lang:batch decode:true \">\"C:\\Program Files\\Microsoft SQL Server90\\Tools\\Binn\\sqlcmd\" -S localhost -i e:\\Backupbackup.sql<\/pre>\n<p>\ud480\ubc31\uc5c5<\/p>\n<pre class=\"lang:tsql decode:true \">declare @runtime nvarchar(10)\ndeclare @backupdevice nvarchar(100)\ndeclare @backupname nvarchar(100)\n\nset @runtime = substring(convert(nvarchar(20), getdate(), 8) ,1,2)\nset @backupdevice = N'e:\\Backupbackup_' + @runtime + N'.bak'\nset @backupname = N'backup_' + @runtime\n\nBACKUP DATABASE [TU] TO DISK = @backupdevice WITH NOFORMAT, INIT, NAME = @backupname, SKIP, NOREWIND, NOUNLOAD, STATS = 10<\/pre>\n<p>\uc99d\ubd84 \ubc31\uc5c5<\/p>\n<pre class=\"lang:tsql decode:true \">declare @runtime nvarchar(10)\ndeclare @backupdevice nvarchar(100)\ndeclare @backupname nvarchar(100)\n\nset @runtime = substring(convert(nvarchar(20), getdate(), 8) ,1,2)\nset @backupdevice = N'e:\\Backupbackup_' + @runtime + N'.bak'\nset @backupname = N'backup_' + @runtime\n\nBACKUP DATABASE [TU] TO DISK = @backupdevice WITH DIFFERENTIAL, NOFORMAT, INIT, NAME = @backupname, SKIP, NOREWIND, NOUNLOAD, STATS = 10<\/pre>\n<p>\u00a0<\/p>\n\n","protected":false},"excerpt":{"rendered":"<p>&#8220;C:\\Program Files\\Microsoft SQL Server90\\Tools\\Binn\\sqlcmd&#8221; -S localhost -i e:\\Backupbackup.sql <\/p>\n<p>\ud480\ubc31\uc5c5<\/p>\n<p> declare @runtime nvarchar(10) declare @backupdevice nvarchar(100) declare @backupname nvarchar(100) set @runtime = substring(convert(nvarchar(20), getdate(), 8) ,1,2) set @backupdevice = N&#8217;e:\\Backupbackup_&#8217; + @runtime + N&#8217;.bak&#8217; set @backupname = N&#8217;backup_&#8217; + @runtime BACKUP DATABASE [TU] TO DISK = @backupdevice WITH NOFORMAT, INIT, NAME = @backupname, SKIP, NOREWIND, NOUNLOAD, [&#8230;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_feature_clip_id":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2},"jetpack_post_was_ever_published":false},"categories":[93,94,96],"tags":[114,112],"class_list":["post-20","post","type-post","status-publish","format-standard","hentry","category-command","category-configuration","category-programming","tag-bat","tag-mssql","odd"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.8 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>sql server \ubc31\uc5c5\uc744 \ud558\uac8c \ud558\uae30 \uc704\ud55c \uc2a4\ud06c\ub9bd\ud2b8 - anydragon<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/anyons.net\/?p=20\" \/>\n<meta property=\"og:locale\" content=\"ko_KR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"sql server \ubc31\uc5c5\uc744 \ud558\uac8c \ud558\uae30 \uc704\ud55c \uc2a4\ud06c\ub9bd\ud2b8 - anydragon\" \/>\n<meta property=\"og:description\" content=\"&quot;C:Program FilesMicrosoft SQL Server90ToolsBinnsqlcmd&quot; -S localhost -i e:Backupbackup.sql \ud480\ubc31\uc5c5 declare @runtime nvarchar(10) declare @backupdevice nvarchar(100) declare @backupname nvarchar(100) set @runtime = substring(convert(nvarchar(20), getdate(), 8) ,1,2) set @backupdevice = N&#039;e:Backupbackup_&#039; + @runtime + N&#039;.bak&#039; set @backupname = N&#039;backup_&#039; + @runtime BACKUP DATABASE [TU] TO DISK = @backupdevice WITH NOFORMAT, INIT, NAME = @backupname, SKIP, NOREWIND, NOUNLOAD, [...]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/anyons.net\/?p=20\" \/>\n<meta property=\"og:site_name\" content=\"anydragon\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/anydragon\" \/>\n<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/anydragon\" \/>\n<meta property=\"article:published_time\" content=\"2009-10-09T13:26:53+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-07-12T05:49:27+00:00\" \/>\n<meta name=\"author\" content=\"anydragon\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@anydragon\" \/>\n<meta name=\"twitter:site\" content=\"@anydragon\" \/>\n<meta name=\"twitter:label1\" content=\"\uae00\uc4f4\uc774\" \/>\n\t<meta name=\"twitter:data1\" content=\"anydragon\" \/>\n\t<meta name=\"twitter:label2\" content=\"\uc608\uc0c1 \ub418\ub294 \ud310\ub3c5 \uc2dc\uac04\" \/>\n\t<meta name=\"twitter:data2\" content=\"1\ubd84\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/anyons.net\\\/?p=20#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/anyons.net\\\/?p=20\"},\"author\":{\"name\":\"anydragon\",\"@id\":\"https:\\\/\\\/anyons.net\\\/#\\\/schema\\\/person\\\/e848d5666536ff82e9ee531c70249f2b\"},\"headline\":\"sql server \ubc31\uc5c5\uc744 \ud558\uac8c \ud558\uae30 \uc704\ud55c \uc2a4\ud06c\ub9bd\ud2b8\",\"datePublished\":\"2009-10-09T13:26:53+00:00\",\"dateModified\":\"2022-07-12T05:49:27+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/anyons.net\\\/?p=20\"},\"wordCount\":2,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/anyons.net\\\/#\\\/schema\\\/person\\\/e848d5666536ff82e9ee531c70249f2b\"},\"keywords\":[\"bat\",\"MSSQL\"],\"articleSection\":[\"Command\",\"Configuration\",\"Programming\"],\"inLanguage\":\"ko-KR\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/anyons.net\\\/?p=20#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/anyons.net\\\/?p=20\",\"url\":\"https:\\\/\\\/anyons.net\\\/?p=20\",\"name\":\"sql server \ubc31\uc5c5\uc744 \ud558\uac8c \ud558\uae30 \uc704\ud55c \uc2a4\ud06c\ub9bd\ud2b8 - anydragon\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/anyons.net\\\/#website\"},\"datePublished\":\"2009-10-09T13:26:53+00:00\",\"dateModified\":\"2022-07-12T05:49:27+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/anyons.net\\\/?p=20#breadcrumb\"},\"inLanguage\":\"ko-KR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/anyons.net\\\/?p=20\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/anyons.net\\\/?p=20#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/anyons.net\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"sql server \ubc31\uc5c5\uc744 \ud558\uac8c \ud558\uae30 \uc704\ud55c \uc2a4\ud06c\ub9bd\ud2b8\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/anyons.net\\\/#website\",\"url\":\"https:\\\/\\\/anyons.net\\\/\",\"name\":\"anydragon\",\"description\":\"mac, linux, aws, c, c++, mysql, mssql, redis, csharp, nodejs, rust, golang\",\"publisher\":{\"@id\":\"https:\\\/\\\/anyons.net\\\/#\\\/schema\\\/person\\\/e848d5666536ff82e9ee531c70249f2b\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/anyons.net\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"ko-KR\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\\\/\\\/anyons.net\\\/#\\\/schema\\\/person\\\/e848d5666536ff82e9ee531c70249f2b\",\"name\":\"anydragon\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"ko-KR\",\"@id\":\"http:\\\/\\\/anyons.net\\\/wp-content\\\/uploads\\\/2022\\\/06\\\/bg3-scaled.jpeg\",\"url\":\"http:\\\/\\\/anyons.net\\\/wp-content\\\/uploads\\\/2022\\\/06\\\/bg3-scaled.jpeg\",\"contentUrl\":\"http:\\\/\\\/anyons.net\\\/wp-content\\\/uploads\\\/2022\\\/06\\\/bg3-scaled.jpeg\",\"width\":2560,\"height\":1440,\"caption\":\"anydragon\"},\"logo\":{\"@id\":\"http:\\\/\\\/anyons.net\\\/wp-content\\\/uploads\\\/2022\\\/06\\\/bg3-scaled.jpeg\"},\"sameAs\":[\"http:\\\/\\\/anyons.net\",\"https:\\\/\\\/www.facebook.com\\\/anydragon\",\"https:\\\/\\\/x.com\\\/anydragon\",\"https:\\\/\\\/www.youtube.com\\\/channel\\\/UCr78KWpvmk398vPfpUTWNLg\"],\"url\":\"https:\\\/\\\/anyons.net\\\/?author=1\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"sql server \ubc31\uc5c5\uc744 \ud558\uac8c \ud558\uae30 \uc704\ud55c \uc2a4\ud06c\ub9bd\ud2b8 - anydragon","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/anyons.net\/?p=20","og_locale":"ko_KR","og_type":"article","og_title":"sql server \ubc31\uc5c5\uc744 \ud558\uac8c \ud558\uae30 \uc704\ud55c \uc2a4\ud06c\ub9bd\ud2b8 - anydragon","og_description":"\"C:Program FilesMicrosoft SQL Server90ToolsBinnsqlcmd\" -S localhost -i e:Backupbackup.sql \ud480\ubc31\uc5c5 declare @runtime nvarchar(10) declare @backupdevice nvarchar(100) declare @backupname nvarchar(100) set @runtime = substring(convert(nvarchar(20), getdate(), 8) ,1,2) set @backupdevice = N'e:Backupbackup_' + @runtime + N'.bak' set @backupname = N'backup_' + @runtime BACKUP DATABASE [TU] TO DISK = @backupdevice WITH NOFORMAT, INIT, NAME = @backupname, SKIP, NOREWIND, NOUNLOAD, [...]","og_url":"https:\/\/anyons.net\/?p=20","og_site_name":"anydragon","article_publisher":"https:\/\/www.facebook.com\/anydragon","article_author":"https:\/\/www.facebook.com\/anydragon","article_published_time":"2009-10-09T13:26:53+00:00","article_modified_time":"2022-07-12T05:49:27+00:00","author":"anydragon","twitter_card":"summary_large_image","twitter_creator":"@anydragon","twitter_site":"@anydragon","twitter_misc":{"\uae00\uc4f4\uc774":"anydragon","\uc608\uc0c1 \ub418\ub294 \ud310\ub3c5 \uc2dc\uac04":"1\ubd84"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/anyons.net\/?p=20#article","isPartOf":{"@id":"https:\/\/anyons.net\/?p=20"},"author":{"name":"anydragon","@id":"https:\/\/anyons.net\/#\/schema\/person\/e848d5666536ff82e9ee531c70249f2b"},"headline":"sql server \ubc31\uc5c5\uc744 \ud558\uac8c \ud558\uae30 \uc704\ud55c \uc2a4\ud06c\ub9bd\ud2b8","datePublished":"2009-10-09T13:26:53+00:00","dateModified":"2022-07-12T05:49:27+00:00","mainEntityOfPage":{"@id":"https:\/\/anyons.net\/?p=20"},"wordCount":2,"commentCount":0,"publisher":{"@id":"https:\/\/anyons.net\/#\/schema\/person\/e848d5666536ff82e9ee531c70249f2b"},"keywords":["bat","MSSQL"],"articleSection":["Command","Configuration","Programming"],"inLanguage":"ko-KR","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/anyons.net\/?p=20#respond"]}]},{"@type":"WebPage","@id":"https:\/\/anyons.net\/?p=20","url":"https:\/\/anyons.net\/?p=20","name":"sql server \ubc31\uc5c5\uc744 \ud558\uac8c \ud558\uae30 \uc704\ud55c \uc2a4\ud06c\ub9bd\ud2b8 - anydragon","isPartOf":{"@id":"https:\/\/anyons.net\/#website"},"datePublished":"2009-10-09T13:26:53+00:00","dateModified":"2022-07-12T05:49:27+00:00","breadcrumb":{"@id":"https:\/\/anyons.net\/?p=20#breadcrumb"},"inLanguage":"ko-KR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/anyons.net\/?p=20"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/anyons.net\/?p=20#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/anyons.net\/"},{"@type":"ListItem","position":2,"name":"sql server \ubc31\uc5c5\uc744 \ud558\uac8c \ud558\uae30 \uc704\ud55c \uc2a4\ud06c\ub9bd\ud2b8"}]},{"@type":"WebSite","@id":"https:\/\/anyons.net\/#website","url":"https:\/\/anyons.net\/","name":"anydragon","description":"mac, linux, aws, c, c++, mysql, mssql, redis, csharp, nodejs, rust, golang","publisher":{"@id":"https:\/\/anyons.net\/#\/schema\/person\/e848d5666536ff82e9ee531c70249f2b"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/anyons.net\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"ko-KR"},{"@type":["Person","Organization"],"@id":"https:\/\/anyons.net\/#\/schema\/person\/e848d5666536ff82e9ee531c70249f2b","name":"anydragon","image":{"@type":"ImageObject","inLanguage":"ko-KR","@id":"http:\/\/anyons.net\/wp-content\/uploads\/2022\/06\/bg3-scaled.jpeg","url":"http:\/\/anyons.net\/wp-content\/uploads\/2022\/06\/bg3-scaled.jpeg","contentUrl":"http:\/\/anyons.net\/wp-content\/uploads\/2022\/06\/bg3-scaled.jpeg","width":2560,"height":1440,"caption":"anydragon"},"logo":{"@id":"http:\/\/anyons.net\/wp-content\/uploads\/2022\/06\/bg3-scaled.jpeg"},"sameAs":["http:\/\/anyons.net","https:\/\/www.facebook.com\/anydragon","https:\/\/x.com\/anydragon","https:\/\/www.youtube.com\/channel\/UCr78KWpvmk398vPfpUTWNLg"],"url":"https:\/\/anyons.net\/?author=1"}]}},"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack-related-posts":[{"id":270,"url":"https:\/\/anyons.net\/?p=270","url_meta":{"origin":20,"position":0},"title":"SQL Injection \ubc29\uc5b4","author":"anydragon","date":"2012\ub144 02\uc6d4 20\uc77c","format":false,"excerpt":"\ucd9c\ucc98 : http:\/\/forums.asp.net\/t\/1254125.aspx \ub97c \ubcf4\uba74 ASP.NET 1.1\uc774\ub0d0 2.0 \uc774\ub0d0\uc5d0 \ub530\ub77c \uac01\uac01 \uc774\ub807\uac8c \ud558\ub77c\uace0 \ud55c\ub2e4. \uc544\uc9c1\uc740 \ub09c web.config\uac00 \uc775\uc219\uce58 \uc54a\uc544\uc11c \uadf8\ub7f0\uc9c0 1.1 \ubc29\uc2dd\uc73c\ub85c \ud558\uba74 \uc798 \ub418\ub294\ub370 2.0 \ubc29\uc2dd\uc73c\ub85c\ub294 \uc798 \uc548\ub41c\ub2e4. -_- ASP.NET 1.1 C# global.asax using System.Globalization; \/\/Defines the set of characters that will be checked. \/\/You can add to this\u2026","rel":"","context":"&quot;Programming&quot;\uc5d0\uc11c","block_context":{"text":"Programming","link":"https:\/\/anyons.net\/?cat=96"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1266,"url":"https:\/\/anyons.net\/?p=1266","url_meta":{"origin":20,"position":1},"title":"mybatis.net \uc790\ub8cc\ud615","author":"anydragon","date":"2017\ub144 02\uc6d4 17\uc77c","format":false,"excerpt":"CLR Type Object\/Map Property Mapping Result Class\/Parameter Class** Type Alias** System.ArrayList Yes Yes list System.Boolean Yes Yes Boolean, bool System.Byte Yes Yes Byte, byte System.Char Yes Yes Char, char System.DateTime Yes Yes dateTime, date System.Decimal Yes Yes Decimal, decimal System.Double Yes Yes Double, double System.Guid Yes Yes guid System.Hashtable Yes\u2026","rel":"","context":"&quot;Programming&quot;\uc5d0\uc11c","block_context":{"text":"Programming","link":"https:\/\/anyons.net\/?cat=96"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":267,"url":"https:\/\/anyons.net\/?p=267","url_meta":{"origin":20,"position":2},"title":"ms sql \ub370\uc774\ud0c0\ubca0\uc774\uc2a4 \ubcf5\uc6d0\ubc29\ubc95","author":"anydragon","date":"2012\ub144 02\uc6d4 14\uc77c","format":false,"excerpt":"\ucd9c\ucc98 : http:\/\/nextstep.co.kr\/105 -- \ubc31\uc5c5\uc0dd\uc131(\uc788\uc73c\uba74 \uc0dd\ub7b5) BACKUP DATABASE Northwind TO DISK = 'c:\\Northwind.bak' --\ubc31\uc5c5\uc815\ubcf4\ud655\uc778(\ub17c\ub9ac\uc801\ud30c\uc77c\uba85, \ubb3c\ub9ac\uc801\uc800\uc7a5\uc704\uce58\ubc0f\ud30c\uc77c\uba85 \ud655\uc778) RESTORE FILELISTONLY FROM DISK = 'c:\\Northwind.bak' -- TestDB\ub77c\ub294 \uc0c8\ub85c\uc6b4 \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub85c \uc0c8\ub85c\uc6b4 \uacbd\ub85c(C:\\temptest*.*)\uc73c\ub85c \ubcf5\uc6d0 RESTORE DATABASE TestDB FROM DISK = 'c:\\Northwind.bak' WITH MOVE 'Northwind' TO 'c:\\testtestdb.mdf', MOVE 'Northwind_log' TO 'c:\\testtestdb.ldf'","rel":"","context":"&quot;Command&quot;\uc5d0\uc11c","block_context":{"text":"Command","link":"https:\/\/anyons.net\/?cat=93"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":2589,"url":"https:\/\/anyons.net\/?p=2589","url_meta":{"origin":20,"position":3},"title":"mac osx zsh neovim \ud658\uacbd\uc124\uc815","author":"anydragon","date":"2022\ub144 07\uc6d4 02\uc77c","format":false,"excerpt":"~\/.zshrc # Set name of the theme to load --- if set to \"random\", it will # load a random theme each time oh-my-zsh is loaded, in which case, # to know which specific one was loaded, run: echo $RANDOM_THEME # See https:\/\/github.com\/ohmyzsh\/ohmyzsh\/wiki\/Themes #ZSH_THEME=\"robbyrussell\" ZSH_THEME=\"agnoster\" # Uncomment the following line\u2026","rel":"","context":"&quot;Configuration&quot;\uc5d0\uc11c","block_context":{"text":"Configuration","link":"https:\/\/anyons.net\/?cat=94"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":2802,"url":"https:\/\/anyons.net\/?p=2802","url_meta":{"origin":20,"position":4},"title":"Azure OS Disk Size \ubd80\uc871\ud560\ub54c \uac00\uc7a5 \uc27d\uac8c SizeUp \ud558\ub294 \ubc29\ubc95","author":"anydragon","date":"2022\ub144 08\uc6d4 28\uc77c","format":false,"excerpt":"\ucc98\uc74c Auzre\uc5d0 VM\uc744 \ub9cc\ub4e4\uace0 \uc6b4\uc601\uc744 \ud558\ub2e4\ubcf4\uba74 \uc0dd\uac01\uce58\ub3c4 \uc54a\uac8c Disk Size \uac00 \ubd80\uc871\ud574 \uc9c8\ub54c\uac00 \uc788\ub2e4. \ud2b9\ud788 OS Disk \uac00 \ubd80\uc871\ud574 \uc9c0\uba74 \uc5ec\ub7ec\uac00\uc9c0 \ubc29\ubc95\uc744 \ucc3e\uc544\ubcf4\uace0\ub294 \"\uc808\ub9dd\" \ud55c\ub2e4 \uac00\uc7a5 \uc77c\ubc18\uc801\uc73c\ub85c Power Shell\ub85c \uc5b4\ucc0c \uc5b4\ucc0c \ud558\ub294 \ubc29\ubc95\uc774 \uc788\uc9c0\ub9cc..........\uc5b4\ub835\ub2e4. \uadf8\ub807\ub2e4\uace0 \uc0c8\ub85c \uc124\uce58\ud558\uae30\uc5d0\ub294 \ud560\uc77c\uc774 \ub9ce\uc544\ub3c4 \ub108\ubb34 \ub9ce\ub2e4. \uadf8\ub7ec\ub2e4\uac00 OS Disk Size\ub97c \ubc14\uafc0\uc218 \uc788\ub294 \uac00\uc7a5 \uc26c\uc6b4 \ubc29\ubc95\uc744\u2026","rel":"","context":"&quot;Configuration&quot;\uc5d0\uc11c","block_context":{"text":"Configuration","link":"https:\/\/anyons.net\/?cat=94"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/anyons.net\/wp-content\/uploads\/2022\/08\/%E1%84%89%E1%85%B3%E1%84%8F%E1%85%B3%E1%84%85%E1%85%B5%E1%86%AB%E1%84%89%E1%85%A3%E1%86%BA-2022-08-28-%E1%84%8B%E1%85%A9%E1%84%8C%E1%85%A5%E1%86%AB-10.50.49.png?resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/anyons.net\/wp-content\/uploads\/2022\/08\/%E1%84%89%E1%85%B3%E1%84%8F%E1%85%B3%E1%84%85%E1%85%B5%E1%86%AB%E1%84%89%E1%85%A3%E1%86%BA-2022-08-28-%E1%84%8B%E1%85%A9%E1%84%8C%E1%85%A5%E1%86%AB-10.50.49.png?resize=350%2C200 1x, https:\/\/i0.wp.com\/anyons.net\/wp-content\/uploads\/2022\/08\/%E1%84%89%E1%85%B3%E1%84%8F%E1%85%B3%E1%84%85%E1%85%B5%E1%86%AB%E1%84%89%E1%85%A3%E1%86%BA-2022-08-28-%E1%84%8B%E1%85%A9%E1%84%8C%E1%85%A5%E1%86%AB-10.50.49.png?resize=525%2C300 1.5x, https:\/\/i0.wp.com\/anyons.net\/wp-content\/uploads\/2022\/08\/%E1%84%89%E1%85%B3%E1%84%8F%E1%85%B3%E1%84%85%E1%85%B5%E1%86%AB%E1%84%89%E1%85%A3%E1%86%BA-2022-08-28-%E1%84%8B%E1%85%A9%E1%84%8C%E1%85%A5%E1%86%AB-10.50.49.png?resize=700%2C400 2x, https:\/\/i0.wp.com\/anyons.net\/wp-content\/uploads\/2022\/08\/%E1%84%89%E1%85%B3%E1%84%8F%E1%85%B3%E1%84%85%E1%85%B5%E1%86%AB%E1%84%89%E1%85%A3%E1%86%BA-2022-08-28-%E1%84%8B%E1%85%A9%E1%84%8C%E1%85%A5%E1%86%AB-10.50.49.png?resize=1050%2C600 3x"},"classes":[]},{"id":1235,"url":"https:\/\/anyons.net\/?p=1235","url_meta":{"origin":20,"position":5},"title":"MySQL \ud29c\ub2dd (from \ub098\ud504\ub2e4)","author":"anydragon","date":"2017\ub144 01\uc6d4 18\uc77c","format":false,"excerpt":"\uba3c\uc800 Subscription\uc744 \ubc1b\uc544\ub77c \uae30\uc220\uc9c0\uc6d0 \uc5c5\uccb4\uc5d0\uac8c \uc758\uc9c0\ud574\ub77c HW \uc758 \uc911\uc694\uc131 mysql community < mysql enterprize \uc4f0\ub808\ub4dc\ud480\uc774 \uc788\uace0 \uc5c6\uace0 \ucc28\uc774 (12 core \uc774\uc0c1\uc5d0\uc11c \uc131\ub2a5 \ucc28\uc774) -> maria DB\ub294 \uc4f0\ub808\ub4dc\ud480\uc774 \uc874\uc7ac \uc2a4\ud1a0\ub9ac\uc9c0 \uc5d4\uc9c4\uc774 \ub530\ub85c \uc788\ub2e4. my.cnf \ub97c \uc798 \uc368\ub77c default\ub85c \uc788\ub294 \uac83\uc740 \ub0ae\uc740 \uc2dc\uc2a4\ud15c\uc5d0\uc11c \ub3cc\ub9ac\uac8c\ub054 \ub418\uc5b4 \uc788\ub294 \uac83\uc774\ub2e4. \uc131\ub2a5 \ud55c\uacc4\uac00 \uc788\ub2e4. BMT \uc218\uce58\ub294\u2026","rel":"","context":"&quot;Configuration&quot;\uc5d0\uc11c","block_context":{"text":"Configuration","link":"https:\/\/anyons.net\/?cat=94"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/anyons.net\/index.php?rest_route=\/wp\/v2\/posts\/20","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/anyons.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/anyons.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/anyons.net\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/anyons.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=20"}],"version-history":[{"count":0,"href":"https:\/\/anyons.net\/index.php?rest_route=\/wp\/v2\/posts\/20\/revisions"}],"wp:attachment":[{"href":"https:\/\/anyons.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=20"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/anyons.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=20"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/anyons.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=20"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}