{"id":525,"date":"2025-07-28T09:25:50","date_gmt":"2025-07-28T00:25:50","guid":{"rendered":"https:\/\/sejiwon.com\/?p=525"},"modified":"2025-07-28T09:25:50","modified_gmt":"2025-07-28T00:25:50","slug":"repl-snapshot-%ec%97%90%eb%9f%ac-%ec%9b%90%ec%9d%b8%ea%b3%bc-%ed%95%b4%ea%b2%b0%eb%b0%a9%eb%b2%95","status":"publish","type":"post","link":"https:\/\/sejiwon.com\/?p=525","title":{"rendered":"REPL SNAPSHOT \uc5d0\ub7ec \uc6d0\uc778\uacfc \ud574\uacb0\ubc29\ubc95"},"content":{"rendered":"\n<p><code>REPL SNAPSHOT<\/code> \uc791\uc5c5(= <strong>Snapshot Agent<\/strong>)\uc774 \uc2e4\ud328\ud558\ub294 \uacbd\uc6b0\ub294 <strong>\uad8c\ud55c \ubb38\uc81c, \ub514\uc2a4\ud06c \uacbd\ub85c \ubb38\uc81c, \ub370\uc774\ud130 \ubb38\uc81c, \ub9ac\ud50c\ub9ac\ucf00\uc774\uc158 \uc124\uc815 \uc624\ub958<\/strong> \ub4f1 \ub2e4\uc591\ud55c \uc774\uc720\ub85c \ubc1c\uc0dd\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<p>\uc774 \uc791\uc5c5\uc740 <strong>\ucd08\uae30 \uc2a4\ub0c5\uc0f7 \ud30c\uc77c(\ud14c\uc774\ube14 \uc2a4\ud0a4\ub9c8 + \ub370\uc774\ud130)\uc744 \uc0dd\uc131<\/strong>\ud574\uc11c \uad6c\ub3c5\uc790\uc5d0\uac8c \ubc30\ud3ec\ud560 \uc900\ube44\ub97c \ud558\ub294 \ud575\uc2ec \ud504\ub85c\uc138\uc2a4\uc785\ub2c8\ub2e4. \uc544\ub798\uc5d0 <strong>\uc790\uc8fc \ubc1c\uc0dd\ud558\ub294 \uc6d0\uc778\uacfc \ud574\uacb0 \ubc29\ubc95<\/strong>\uc744 \uc815\ub9ac\ud574 \ub4dc\ub9b4\uac8c\uc694.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">\u2705 Snapshot Agent \uc2e4\ud328 \uc8fc\uc694 \uc6d0\uc778 \ubc0f \ud574\uacb0 \ubc29\ubc95<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">1. <strong>\uad8c\ud55c \ubb38\uc81c (\uac00\uc7a5 \ud754\ud568)<\/strong><\/h3>\n\n\n\n<h4 class=\"wp-block-heading\">\uc608:<\/h4>\n\n\n\n<ul>\n<li><code>Access is denied.<\/code><\/li>\n\n\n\n<li><code>The process could not read file ...<\/code><\/li>\n\n\n\n<li><code>The process could not connect to Subscriber ...<\/code><\/li>\n<\/ul>\n\n\n\n<p>\ud83d\udee0\ufe0f \ud574\uacb0 \ubc29\ubc95:<\/p>\n\n\n\n<ul>\n<li>Snapshot Agent \uacc4\uc815(SQL Server Agent\uc5d0\uc11c \uc2e4\ud589\ub418\ub294 \uacc4\uc815)\uc774 <strong>\uc2a4\ub0c5\uc0f7 \ud3f4\ub354\uc5d0 \uc77d\uae30\/\uc4f0\uae30 \uad8c\ud55c<\/strong>\uc774 \uc788\ub294\uc9c0 \ud655\uc778.\n<ul>\n<li>\uc2a4\ub0c5\uc0f7 \ud3f4\ub354 \uc608: <code>\\\\SERVER\\ReplData<\/code><\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>\ud3f4\ub354\uac00 \ub124\ud2b8\uc6cc\ud06c \uacf5\uc720\uac00 \ub418\uc5b4 \uc788\uc5b4\uc57c \ud568.<\/li>\n\n\n\n<li>Snapshot Agent \uacc4\uc815\uc774 <strong>Publisher\uc640 Distributor \uc11c\ubc84 \ub458 \ub2e4\uc5d0 \uc811\uadfc \uac00\ub2a5\ud55c \ub85c\uceec \uad00\ub9ac\uc790 or \ub3c4\uba54\uc778 \uacc4\uc815<\/strong>\uc778\uc9c0 \ud655\uc778.<\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3 class=\"wp-block-heading\">2. <strong>\uc2a4\ub0c5\uc0f7 \ud3f4\ub354 \uacf5\uc720 \ubb38\uc81c<\/strong><\/h3>\n\n\n\n<h4 class=\"wp-block-heading\">\uc608:<\/h4>\n\n\n\n<ul>\n<li><code>The process could not access the file because it is being used by another process.<\/code><\/li>\n\n\n\n<li><code>The snapshot folder path is invalid or inaccessible.<\/code><\/li>\n<\/ul>\n\n\n\n<p>\ud83d\udee0\ufe0f \ud574\uacb0 \ubc29\ubc95:<\/p>\n\n\n\n<ul>\n<li>SSMS \u2192 \ud37c\ube14\ub9ac\uc154 \u2192 Publications \u2192 \ud574\ub2f9 Publication \uc6b0\ud074\ub9ad \u2192 <strong>Properties<\/strong> \u2192 Snapshot \u2192 <strong>Snapshot Folder \uacbd\ub85c \ud655\uc778<\/strong><\/li>\n\n\n\n<li>\uacf5\uc720 \ud3f4\ub354\uc778\uc9c0(<code>\\\\\uc11c\ubc84\uc774\ub984\\\ud3f4\ub354<\/code>) \ud655\uc778\ud558\uace0, Snapshot Agent \uacc4\uc815\uc5d0 \uc811\uadfc \uad8c\ud55c\uc774 \uc788\ub294\uc9c0 \ud655\uc778<\/li>\n\n\n\n<li>\uc2e4\uc81c \uacbd\ub85c\uc5d0 \uc811\uadfc\ud574\uc11c \uc218\ub3d9\uc73c\ub85c \ud14c\uc2a4\ud2b8\ud574 \ubcf4\uae30<\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3 class=\"wp-block-heading\">3. <strong>\ub300\ub7c9\uc758 \ub370\uc774\ud130\/\ud14c\uc774\ube14\ub85c \uc778\ud55c Timeout \ub610\ub294 \uba54\ubaa8\ub9ac \ucd08\uacfc<\/strong><\/h3>\n\n\n\n<h4 class=\"wp-block-heading\">\uc608:<\/h4>\n\n\n\n<ul>\n<li><code>Timeout expired<\/code><\/li>\n\n\n\n<li><code>There is insufficient system memory in resource pool 'internal' to run this query.<\/code><\/li>\n<\/ul>\n\n\n\n<p>\ud83d\udee0\ufe0f \ud574\uacb0 \ubc29\ubc95:<\/p>\n\n\n\n<ul>\n<li>\uc2a4\ub0c5\uc0f7 \uc0dd\uc131 \uc2dc\uac04 \uc5f0\uc7a5 (<code>-QueryTimeout<\/code> \uc635\uc158 \ub298\ub9ac\uae30)<\/li>\n\n\n\n<li>\ub300\ub7c9 \ub370\uc774\ud130\ub294 \ucd08\uae30\uc5d0\ub294 \ud544\ud130\ub9c1\ud558\uac70\ub098 \ud14c\uc774\ube14 \ub2e8\uc704\ub85c \ub098\ub220\uc11c \ubcf5\uc81c<\/li>\n\n\n\n<li>\ud544\uc694 \uc2dc \uc11c\ubc84 \uba54\ubaa8\ub9ac\/\ub514\uc2a4\ud06c \uc790\uc6d0 \ud655\uc778<\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3 class=\"wp-block-heading\">4. <strong>\uc2a4\ud0a4\ub9c8 \ubb38\uc81c (\uc608: \uc81c\uc57d \uc870\uac74, FK \uc21c\uc11c \uc624\ub958)<\/strong><\/h3>\n\n\n\n<h4 class=\"wp-block-heading\">\uc608:<\/h4>\n\n\n\n<ul>\n<li><code>Violation of PRIMARY KEY<\/code>, <code>Cannot insert duplicate key<\/code><\/li>\n\n\n\n<li><code>Error converting data type<\/code><\/li>\n<\/ul>\n\n\n\n<p>\ud83d\udee0\ufe0f \ud574\uacb0 \ubc29\ubc95:<\/p>\n\n\n\n<ul>\n<li>Foreign Key \uc81c\uc57d\uc774 \uc798 \uc815\uc758\ub418\uc5b4 \uc788\ub294\uc9c0 \ud655\uc778<\/li>\n\n\n\n<li>Circular FK\uac00 \uc788\uc73c\uba74 Publication \uc124\uc815\uc5d0\uc11c <strong>&#8220;\uc9c0\uc5f0\ub41c FK \uc801\uc6a9&#8221;<\/strong> \uc635\uc158 \uc0ac\uc6a9<\/li>\n\n\n\n<li>\ucd08\uae30 \ub370\uc774\ud130\uac00 \ubb38\uc81c\ub420 \uc218 \uc788\uc73c\ub2c8, \ud074\ub9b0 DB\uc5d0\uc11c \ud14c\uc2a4\ud2b8<\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3 class=\"wp-block-heading\">5. <strong>\ub9ac\ud50c\ub9ac\ucf00\uc774\uc158 \uad6c\uc131 \uc624\ub958<\/strong><\/h3>\n\n\n\n<h4 class=\"wp-block-heading\">\uc608:<\/h4>\n\n\n\n<ul>\n<li><code>The process could not execute 'sp_replcmds'<\/code><\/li>\n\n\n\n<li><code>Publication does not exist<\/code><\/li>\n\n\n\n<li><code>The snapshot agent failed to prepare the snapshot folder.<\/code><\/li>\n<\/ul>\n\n\n\n<p>\ud83d\udee0\ufe0f \ud574\uacb0 \ubc29\ubc95:<\/p>\n\n\n\n<ul>\n<li>Publication \ubc0f \uad6c\ub3c5 \uad6c\uc131 \ud655\uc778<\/li>\n\n\n\n<li>Publication \uc7ac\uc0dd\uc131 (\uc911\uc694\ud55c \uacbd\uc6b0 \uc2a4\ud06c\ub9bd\ud2b8 \ubc31\uc5c5 \uba3c\uc800!)<\/li>\n\n\n\n<li>\ubc30\ud3ec\uc790(distributor) \ucd08\uae30\ud654 \uc7ac\uc124\uc815 \uace0\ub824<\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">\ud83d\udd0d \uc9c4\ub2e8\uc744 \uc704\ud55c \uc5d0\uc774\uc804\ud2b8 \ub85c\uadf8 \ud655\uc778 \ubc29\ubc95<\/h2>\n\n\n\n<ol>\n<li>SSMS \u2192 SQL Server Agent \u2192 Jobs \u2192 <code>\"Snapshot Agent - &lt;PublicationName&gt;\"<\/code> \uc120\ud0dd<\/li>\n\n\n\n<li>\ub9c8\uc6b0\uc2a4 \uc624\ub978\ucabd \u2192 View History<\/li>\n\n\n\n<li>\uc624\ub958 \uba54\uc2dc\uc9c0 \ubc0f \uc2a4\ud15d \uc2e4\ud328 \uc704\uce58 \ud655\uc778<\/li>\n<\/ol>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">\u2705 Snapshot Agent \uc218\ub3d9 \uc2e4\ud589 \ud14c\uc2a4\ud2b8 (\uc5d0\ub7ec \ub85c\uadf8 \uc9c1\uc811 \ud655\uc778)<\/h2>\n\n\n\n<pre class=\"wp-block-preformatted\"><code>replsnapshot.exe -Publisher [PublisherName] -PublisherDB [DBName] -Publication [PublicationName] -Distributor [DistributorName] -DistributorSecurityMode 1\n<\/code><\/pre>\n\n\n\n<blockquote class=\"wp-block-quote\">\n<p>\uc774 \uba85\ub839\uc5b4\ub294 \uba85\ub839\uc904\uc5d0\uc11c Snapshot Agent\ub97c \uc218\ub3d9\uc73c\ub85c \uc2e4\ud589\ud558\uba70, \uad6c\uccb4\uc801\uc778 \uc624\ub958 \uba54\uc2dc\uc9c0\ub97c \ub354 \uc790\uc138\ud788 \ubcf4\uc5ec\uc90d\ub2c8\ub2e4.<\/p>\n<\/blockquote>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">\u2733\ufe0f Snapshot Agent \uc124\uc815 \ud655\uc778 \uacbd\ub85c<\/h2>\n\n\n\n<ul>\n<li>SSMS \u2192 Replication \u2192 Local Publications \u2192 \ud574\ub2f9 Publication \uc6b0\ud074\ub9ad \u2192 <strong>Properties<\/strong>\n<ul>\n<li>Snapshot \u2192 Folder<\/li>\n\n\n\n<li>Agent Security \u2192 <strong>Snapshot Agent \uc2e4\ud589 \uacc4\uc815<\/strong><\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>SQL Server Agent \u2192 Job \u2192 Snapshot Agent \u2192 Steps \u2192 \uc2e4\ud589 \uba85\ub839 \ud655\uc778<\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">\ud83d\udccc \uc694\uc57d: \uac00\uc7a5 \ud754\ud55c \uc6d0\uc778 &amp; \ube60\ub978 \uc810\uac80 \uc21c\uc11c<\/h2>\n\n\n\n<figure class=\"wp-block-table\"><table><thead><tr><th>\uc6b0\uc120\uc21c\uc704<\/th><th>\uc810\uac80 \ud56d\ubaa9<\/th><th>\uc124\uba85<\/th><\/tr><\/thead><tbody><tr><td>\u2705 1<\/td><td>Snapshot Agent \uacc4\uc815 \uad8c\ud55c<\/td><td>\uc2a4\ub0c5\uc0f7 \ud3f4\ub354 \uc811\uadfc \uac00\ub2a5\ud55c\uc9c0 \ud655\uc778<\/td><\/tr><tr><td>\u2705 2<\/td><td>\uc2a4\ub0c5\uc0f7 \ud3f4\ub354 \uc720\ud6a8\uc131<\/td><td>\uacf5\uc720\ub41c \ub124\ud2b8\uc6cc\ud06c \uacbd\ub85c\uc778\uc9c0 \ud655\uc778<\/td><\/tr><tr><td>\u2705 3<\/td><td>SQL Agent Job \ud788\uc2a4\ud1a0\ub9ac<\/td><td>\uad6c\uccb4\uc801\uc778 \uc5d0\ub7ec \uba54\uc2dc\uc9c0 \ud655\uc778<\/td><\/tr><tr><td>\u2705 4<\/td><td>Publication \uc124\uc815<\/td><td>\uc81c\uc57d \uc870\uac74, FK, \ub300\uc6a9\ub7c9 \ub370\uc774\ud130 \uc5ec\ubd80 \ud655\uc778<\/td><\/tr><tr><td>\u2705 5<\/td><td>\uc11c\ubc84 \ub9ac\uc18c\uc2a4<\/td><td>\uba54\ubaa8\ub9ac, \ub514\uc2a4\ud06c, \ub124\ud2b8\uc6cc\ud06c \uc0ac\uc6a9\ub960 \ud655\uc778<\/td><\/tr><\/tbody><\/table><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>REPL SNAPSHOT \uc791\uc5c5(= Snapshot Agent)\uc774 \uc2e4\ud328\ud558\ub294 \uacbd\uc6b0\ub294 \uad8c\ud55c \ubb38\uc81c, \ub514\uc2a4\ud06c \uacbd\ub85c \ubb38\uc81c, \ub370\uc774\ud130 \ubb38\uc81c, \ub9ac\ud50c\ub9ac\ucf00\uc774\uc158 \uc124\uc815 \uc624\ub958 \ub4f1 \ub2e4\uc591\ud55c \uc774\uc720\ub85c \ubc1c\uc0dd\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc774 \uc791\uc5c5\uc740 \ucd08\uae30 \uc2a4\ub0c5\uc0f7 \ud30c\uc77c(\ud14c\uc774\ube14 \uc2a4\ud0a4\ub9c8 + \ub370\uc774\ud130)\uc744 \uc0dd\uc131\ud574\uc11c \uad6c\ub3c5\uc790\uc5d0\uac8c \ubc30\ud3ec\ud560 \uc900\ube44\ub97c \ud558\ub294 \ud575\uc2ec \ud504\ub85c\uc138\uc2a4\uc785\ub2c8\ub2e4. \uc544\ub798\uc5d0 \uc790\uc8fc \ubc1c\uc0dd\ud558\ub294 \uc6d0\uc778\uacfc \ud574\uacb0 \ubc29\ubc95\uc744 \uc815\ub9ac\ud574 \ub4dc\ub9b4\uac8c\uc694. \u2705 Snapshot Agent \uc2e4\ud328 \uc8fc\uc694 \uc6d0\uc778 \ubc0f \ud574\uacb0 \ubc29\ubc95\u2026 <span class=\"read-more\"><a href=\"https:\/\/sejiwon.com\/?p=525\">Read More &raquo;<\/a><\/span><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[11],"tags":[],"_links":{"self":[{"href":"https:\/\/sejiwon.com\/index.php?rest_route=\/wp\/v2\/posts\/525"}],"collection":[{"href":"https:\/\/sejiwon.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sejiwon.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sejiwon.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/sejiwon.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=525"}],"version-history":[{"count":1,"href":"https:\/\/sejiwon.com\/index.php?rest_route=\/wp\/v2\/posts\/525\/revisions"}],"predecessor-version":[{"id":527,"href":"https:\/\/sejiwon.com\/index.php?rest_route=\/wp\/v2\/posts\/525\/revisions\/527"}],"wp:attachment":[{"href":"https:\/\/sejiwon.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=525"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sejiwon.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=525"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sejiwon.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=525"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}