{"id":1199,"date":"2019-07-07T10:04:00","date_gmt":"2019-07-07T02:04:00","guid":{"rendered":"https:\/\/freesilo.com\/?p=1199"},"modified":"2019-07-07T10:04:00","modified_gmt":"2019-07-07T02:04:00","slug":"%e9%80%9a%e8%bf%87sql%e8%84%9a%e6%9c%ac%e8%bf%98%e5%8e%9fsqlserver%e6%95%b0%e6%8d%ae%e5%ba%93%e7%9a%84bak%e5%a4%87%e4%bb%bd%e6%96%87%e4%bb%b6","status":"publish","type":"post","link":"https:\/\/freesilo.com\/?p=1199","title":{"rendered":"\u901a\u8fc7SQL\u811a\u672c\u8fd8\u539fSQLServer\u6570\u636e\u5e93\u7684BAK\u5907\u4efd\u6587\u4ef6"},"content":{"rendered":"<p>\u6700\u8fd1\u64cd\u4f5c\u6570\u636e\u5e93SQLServer\u6bd4\u8f83\u591a\uff0c\u5176\u4e2d\u6709\u4e00\u4e2a\u64cd\u4f5c\u6bd4\u8f83\u9ebb\u70e6\uff0c\u5c31\u662f\u9700\u8981\u901a\u8fc7\u4e00\u4e2a\u6570\u636e\u5e93\u8fd8\u539f\u6210\u5176\u4ed6\u6570\u636e\u5e93\uff0c\u5e76\u4e14\u521b\u5efa\u76f8\u5bf9\u5e94\u7684\u7528\u6237\u4e0e\u5bc6\u7801\u3002\u624b\u52a8\u64cd\u4f5c\u80af\u5b9a\u592a\u9ebb\u70e6\uff0c\u7528\u4e0b\u9762\u7684\u811a\u672c\u5373\u53ef\u65b9\u4fbf\u5b8c\u6210~<\/p>\n<pre class=\"brush: sql; title: ; notranslate\" title=\"\">\r\n--\u901a\u8fc7\u4e00\u4e2a\u6570\u636e\u5e93\u8fd8\u539f\u6210\u5176\u4ed6\u6570\u636e\u5e93\r\nRESTORE DATABASE &#x5B;DBName_XXX] \r\nFROM DISK = N'C:\\DBbak\\TestDBbackup.bak' WITH\r\nMOVE N'TestDB' TO N'C:\\DB\\DBName_XXX.mdf', \r\nMOVE N'TestDB_log' TO N'C:\\DB\\DBName_XXX_log.ldf',\r\nFILE = 1, NOUNLOAD, STATS = 10\r\n \r\n--\u521b\u5efa\u76f8\u5bf9\u5e94\u7684\u7528\u6237\u4e0e\u5bc6\u7801\r\nUSE &#x5B;master]\r\nGO\r\nCREATE LOGIN user_XXX WITH\r\nPASSWORD = N'pwd_XXX'\r\n, DEFAULT_DATABASE = DBName_XXX, CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF\r\nGO\r\nPRINT 'CREATE LOGIN OK.'\r\n \r\nUSE DBName_XXX\r\nGO\r\nCREATE USER user_XXX FOR LOGIN user_XXX WITH DEFAULT_SCHEMA = &#x5B;dbo] \r\nGO\r\nEXEC sp_addrolemember N'db_owner', N'user_XXX'\r\nGO\r\nPRINT 'CREATE USER OK.'\r\n<\/pre>\n<p>\u53ea\u9700\u5c06\u4ee5\u4e0a\u4ee3\u7801\u4e2d\u7684\u53d8\u91cf\u66ff\u6362\u5373\u53ef\uff1a<\/p>\n<blockquote><p>\n\u5c06\u201cC:\\DBbak\\TestDBbackup.bak\u201d\u66ff\u6362\u4e3a\u4f60\u6570\u636e\u5e93\u5907\u4efd\u7684\u6587\u4ef6\u8def\u5f84<br \/>\nDBName_XXX\uff1a\u6570\u636e\u5e93\u540d<br \/>\nuser_XXX\uff1a\u6570\u636e\u5e93\u767b\u5f55\u7528\u6237\u540d<br \/>\npwd_XXX\uff1a\u6570\u636e\u5e93\u767b\u5f55\u7528\u6237\u5bc6\u7801\n<\/p><\/blockquote>\n","protected":false},"excerpt":{"rendered":"<p>\u6700\u8fd1\u64cd\u4f5c\u6570\u636e\u5e93SQLServer\u6bd4\u8f83\u591a\uff0c\u5176\u4e2d\u6709\u4e00\u4e2a\u64cd\u4f5c\u6bd4\u8f83\u9ebb\u70e6\uff0c\u5c31\u662f\u9700\u8981\u901a\u8fc7\u4e00\u4e2a&#8230;<br \/><a class=\"read-more-button\" href=\"https:\/\/freesilo.com\/?p=1199\">Read more<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8],"tags":[],"class_list":["post-1199","post","type-post","status-publish","format-standard","hentry","category-sql-server"],"_links":{"self":[{"href":"https:\/\/freesilo.com\/index.php?rest_route=\/wp\/v2\/posts\/1199","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/freesilo.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/freesilo.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/freesilo.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/freesilo.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1199"}],"version-history":[{"count":1,"href":"https:\/\/freesilo.com\/index.php?rest_route=\/wp\/v2\/posts\/1199\/revisions"}],"predecessor-version":[{"id":1200,"href":"https:\/\/freesilo.com\/index.php?rest_route=\/wp\/v2\/posts\/1199\/revisions\/1200"}],"wp:attachment":[{"href":"https:\/\/freesilo.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1199"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/freesilo.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1199"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/freesilo.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1199"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}