{"id":18614,"date":"2021-02-22T22:22:02","date_gmt":"2021-02-22T14:22:02","guid":{"rendered":"https:\/\/blog.pmail.idv.tw\/?p=18614"},"modified":"2021-02-22T22:22:02","modified_gmt":"2021-02-22T14:22:02","slug":"sql-2008-r2-%e9%82%84%e5%8e%9f%e7%b3%bb%e7%b5%b1%e8%b3%87%e6%96%99%e5%ba%ab%e7%b4%80%e9%8c%84","status":"publish","type":"post","link":"https:\/\/blog.pmail.idv.tw\/?p=18614","title":{"rendered":"SQL 2008 R2 \u9084\u539f\u7cfb\u7d71\u8cc7\u6599\u5eab\u7d00\u9304"},"content":{"rendered":"<p>\u7d00\u9304\u9084\u539fSQL master \u8cc7\u6599\u5eab<\/p>\n<p>&nbsp;<\/p>\n<p><!--more--><\/p>\n<p>\u9084\u539fmaster \u9700\u8981\u5728\u55ae\u4eba\u6a21\u5f0f<\/p>\n<p>\u5148\u628a\u670d\u52d9\u505c\u6b62<\/p>\n<p>net stop MSSQLSERVER \/Y<\/p>\n<p>\u5c07\u670d\u52d9\u555f\u52d5\u65bc\u55ae\u4eba\u6a21\u5f0f<\/p>\n<p>net start MSSQLSERVER \/m<\/p>\n<p>\u9032\u5165sql comman<\/p>\n<p>sqlcmd \u2013S localhost<\/p>\n<p>\u5f9e\u5099\u4efd\u6a94\u6848\u9084\u539f\uff0c\u6307\u4ee4\u5982\u4e0b<\/p>\n<p>RESTORE DATABASE master FROM DISK=\u2019d:\\master.bak\u2019WITH REPLACE<\/p>\n<p><a href=\"https:\/\/blog.pmail.idv.tw\/wp-content\/uploads\/2021\/02\/2021-02-18_114049.jpg\"><img loading=\"lazy\" decoding=\"async\" title=\"2021-02-18_114049\" style=\"border-left-width: 0px; border-right-width: 0px; background-image: none; border-bottom-width: 0px; padding-top: 0px; padding-left: 0px; display: inline; padding-right: 0px; border-top-width: 0px\" border=\"0\" alt=\"2021-02-18_114049\" src=\"https:\/\/blog.pmail.idv.tw\/wp-content\/uploads\/2021\/02\/2021-02-18_114049_thumb.jpg\" width=\"644\" height=\"421\"><\/a><\/p>\n<p>\u5c0f\u63d2\u66f2<\/p>\n<p>\u9084\u539f\u5f8c\u7121\u6cd5\u555f\u52d5\u8cc7\u6599\u5eab<\/p>\n<p><a href=\"https:\/\/blog.pmail.idv.tw\/wp-content\/uploads\/2021\/02\/2021-02-19_160600.jpg\"><img loading=\"lazy\" decoding=\"async\" title=\"2021-02-19_160600\" style=\"border-left-width: 0px; border-right-width: 0px; background-image: none; border-bottom-width: 0px; padding-top: 0px; padding-left: 0px; display: inline; padding-right: 0px; border-top-width: 0px\" border=\"0\" alt=\"2021-02-19_160600\" src=\"https:\/\/blog.pmail.idv.tw\/wp-content\/uploads\/2021\/02\/2021-02-19_160600_thumb.jpg\" width=\"644\" height=\"459\"><\/a><\/p>\n<p>\u67e5\u770b log<\/p>\n<p><a href=\"https:\/\/blog.pmail.idv.tw\/wp-content\/uploads\/2021\/02\/2021-02-19_160933.jpg\"><img loading=\"lazy\" decoding=\"async\" title=\"2021-02-19_160933\" style=\"border-left-width: 0px; border-right-width: 0px; background-image: none; border-bottom-width: 0px; padding-top: 0px; padding-left: 0px; display: inline; padding-right: 0px; border-top-width: 0px\" border=\"0\" alt=\"2021-02-19_160933\" src=\"https:\/\/blog.pmail.idv.tw\/wp-content\/uploads\/2021\/02\/2021-02-19_160933_thumb.jpg\" width=\"644\" height=\"263\"><\/a><\/p>\n<p>\u770b\u5230\u5b58\u53d6\u88ab\u62d2 <\/p>\n<p><a href=\"https:\/\/blog.pmail.idv.tw\/wp-content\/uploads\/2021\/02\/2021-02-19_161136.jpg\"><img loading=\"lazy\" decoding=\"async\" title=\"2021-02-19_161136\" style=\"border-left-width: 0px; border-right-width: 0px; background-image: none; border-bottom-width: 0px; padding-top: 0px; padding-left: 0px; display: inline; padding-right: 0px; border-top-width: 0px\" border=\"0\" alt=\"2021-02-19_161136\" src=\"https:\/\/blog.pmail.idv.tw\/wp-content\/uploads\/2021\/02\/2021-02-19_161136_thumb.jpg\" width=\"644\" height=\"73\"><\/a><\/p>\n<p>\u67e5\u770b\u672c\u6a5f\u7fa4\u7d44\u9084\u539f\u5f8cmaster\u8cc7\u6599\u5eab\u8def\u5f91\u8cc7\u6599\u593e\u9700\u8981\u628asql \u6b0a\u9650\u52a0\u5165(\u5982\u4e0b\u5716)<\/p>\n<p>SQL service account: SQLServerMSSQLUser$&lt;server&gt;$MSSQLSERVER<\/p>\n<p><a href=\"https:\/\/blog.pmail.idv.tw\/wp-content\/uploads\/2021\/02\/2021-02-19_161338.jpg\"><img loading=\"lazy\" decoding=\"async\" title=\"2021-02-19_161338\" style=\"border-left-width: 0px; border-right-width: 0px; background-image: none; border-bottom-width: 0px; padding-top: 0px; padding-left: 0px; display: inline; padding-right: 0px; border-top-width: 0px\" border=\"0\" alt=\"2021-02-19_161338\" src=\"https:\/\/blog.pmail.idv.tw\/wp-content\/uploads\/2021\/02\/2021-02-19_161338_thumb.jpg\" width=\"644\" height=\"432\"><\/a><\/p>\n<p><a href=\"https:\/\/blog.pmail.idv.tw\/wp-content\/uploads\/2021\/02\/2021-02-19_161302.jpg\"><img loading=\"lazy\" decoding=\"async\" title=\"2021-02-19_161302\" style=\"border-left-width: 0px; border-right-width: 0px; background-image: none; border-bottom-width: 0px; padding-top: 0px; padding-left: 0px; display: inline; padding-right: 0px; border-top-width: 0px\" border=\"0\" alt=\"2021-02-19_161302\" src=\"https:\/\/blog.pmail.idv.tw\/wp-content\/uploads\/2021\/02\/2021-02-19_161302_thumb.jpg\" width=\"402\" height=\"484\"><\/a><\/p>\n<p>\u6700\u5f8c\u4f7f\u7528ssms \u628amodel \u3001msdb \u7cfb\u7d71\u8cc7\u6599\u5eab\u9084\u539f<\/p>\n<p>&nbsp;<\/p>\n<p><a href=\"https:\/\/blog.pmail.idv.tw\/wp-content\/uploads\/2021\/02\/2021-02-19_161536.jpg\"><img loading=\"lazy\" decoding=\"async\" title=\"2021-02-19_161536\" style=\"border-left-width: 0px; border-right-width: 0px; background-image: none; border-bottom-width: 0px; padding-top: 0px; padding-left: 0px; display: inline; padding-right: 0px; border-top-width: 0px\" border=\"0\" alt=\"2021-02-19_161536\" src=\"https:\/\/blog.pmail.idv.tw\/wp-content\/uploads\/2021\/02\/2021-02-19_161536_thumb.jpg\" width=\"534\" height=\"484\"><\/a><\/p>\n<p><a href=\"https:\/\/blog.pmail.idv.tw\/wp-content\/uploads\/2021\/02\/2021-02-19_161605.jpg\"><img loading=\"lazy\" decoding=\"async\" title=\"2021-02-19_161605\" style=\"border-left-width: 0px; border-right-width: 0px; background-image: none; border-bottom-width: 0px; padding-top: 0px; padding-left: 0px; display: inline; padding-right: 0px; border-top-width: 0px\" border=\"0\" alt=\"2021-02-19_161605\" src=\"https:\/\/blog.pmail.idv.tw\/wp-content\/uploads\/2021\/02\/2021-02-19_161605_thumb.jpg\" width=\"563\" height=\"484\"><\/a><\/p>\n<p>\u6703\u6709\u5c0f\u63d2\u66f2\u539f\u56e0\u662f\u56e0\u70ba\uff0c\u9084\u539fmaster \u5230\u65b0DB\u4e3b\u6a5f\u5f8c\u56e0\u70ba\u7cfb\u7d71\u8def\u5f91\u90fd\u8981\u8207\u539f\u4f86DB\u4e3b\u6a5f\u90fd\u8981\u76f8\u540c\u6240\u4ee5\u624d\u6703\u6709\u7121\u6cd5\u555f\u52d5\u554f\u984c\uff0c\u4e14\u56e0\u70ba\u8def\u5f91\u4e0d\u540c\u6240\u4ee5\u4e5f\u8981\u6ce8\u610f\u8a72\u8cc7\u6599\u593e\u6b0a\u9650\u554f\u984c\u3002<\/p>\n<p>\u5c0f\u5f1f\u4e0d\u662fDBA&nbsp; \uff0c\u6240\u4ee5\u4ee5\u4e0a\u50c5\u4f9b\u53c3\u8003<\/p>\n<div class=\"21cd169d3c0f71e95b84db320302cb4a\" data-index=\"1\" style=\"float: right; margin:10px 0 10px 10px;\">\n<script async src=\"https:\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js?client=ca-pub-8711325745898650\"\r\n     crossorigin=\"anonymous\"><\/script>\n<\/div>\n\n<div style=\"font-size: 0px; height: 0px; line-height: 0px; margin: 0; padding: 0; clear: both;\"><\/div>","protected":false},"excerpt":{"rendered":"<p>\u7d00\u9304\u9084\u539fSQL master \u8cc7\u6599\u5eab &nbsp;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"ngg_post_thumbnail":0,"footnotes":""},"categories":[103],"tags":[],"class_list":["post-18614","post","type-post","status-publish","format-standard","hentry","category-mssql"],"_links":{"self":[{"href":"https:\/\/blog.pmail.idv.tw\/index.php?rest_route=\/wp\/v2\/posts\/18614","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.pmail.idv.tw\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.pmail.idv.tw\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.pmail.idv.tw\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.pmail.idv.tw\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=18614"}],"version-history":[{"count":1,"href":"https:\/\/blog.pmail.idv.tw\/index.php?rest_route=\/wp\/v2\/posts\/18614\/revisions"}],"predecessor-version":[{"id":18615,"href":"https:\/\/blog.pmail.idv.tw\/index.php?rest_route=\/wp\/v2\/posts\/18614\/revisions\/18615"}],"wp:attachment":[{"href":"https:\/\/blog.pmail.idv.tw\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=18614"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.pmail.idv.tw\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=18614"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.pmail.idv.tw\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=18614"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}