{"id":209,"date":"2011-04-02T10:44:51","date_gmt":"2011-04-02T02:44:51","guid":{"rendered":"http:\/\/www.royalwzy.com\/?p=209"},"modified":"2013-12-30T14:00:12","modified_gmt":"2013-12-30T06:00:12","slug":"%e6%81%a2%e5%a4%8d%e5%88%b0%e6%95%b0%e6%8d%ae%e5%ba%93%e5%bf%ab%e7%85%a7","status":"publish","type":"post","link":"http:\/\/www.royalwzy.com\/?p=209","title":{"rendered":"\u6062\u590d\u5230\u6570\u636e\u5e93\u5feb\u7167"},"content":{"rendered":"<p style=\"color: #333333; font-family: Arial; font-size: 14px; font-style: normal; font-variant: normal;\"><span style=\"font-family: 'courier new', courier;\"><span style=\"font-size: small;\"><span lang=\"zh-CN\">\u5982\u4f55\u6062\u590d\u5230\u5feb\u7167\u7ed3\u679c<\/span><span lang=\"en-US\">,<\/span><span lang=\"zh-CN\">\u8bf4\u660e\u6062\u590d\u64cd\u4f5c\u7684\u9650\u5236<\/span><span lang=\"en-US\">,<\/span><span lang=\"zh-CN\">\u5e76\u63d0\u4f9b\u6307\u5411\u6062\u590d\u8fc7\u7a0b\u7684\u94fe\u63a5<\/span><span lang=\"en-US\">.<\/span><span lang=\"zh-CN\">\u4f5c\u4e3a\u4ece\u5907\u4efd\u4e2d\u8fd8\u539f\u8054\u673a\u6570\u636e\u5e93\u7684\u66ff\u4ee3\u65b9\u6cd5<\/span><span lang=\"en-US\">,<\/span><span lang=\"zh-CN\">\u4efb\u4f55\u5bf9\u6e90\u6570\u636e\u5e93\u5177\u6709<\/span><span lang=\"en-US\">\u00a0RESTORE DATABASE\u00a0<\/span><span lang=\"zh-CN\">\u6743\u9650\u7684\u7528\u6237\u5747\u53ef\u5c06\u8be5\u6570\u636e\u5e93\u6062\u590d\u5230\u521b\u5efa\u6570\u636e\u5e93\u5feb\u7167\u65f6\u7684\u72b6\u6001<\/span><span lang=\"en-US\">.<\/span><span lang=\"zh-CN\">\u5f53\u8054\u673a\u6e90\u6570\u636e\u5e93\u4e2d\u7684\u6570\u636e\u635f\u574f\u65f6<\/span><span lang=\"en-US\">,<\/span><span lang=\"zh-CN\">\u6062\u590d\u5230\u6700\u8fd1\u7684\u5feb\u7167\u53ef\u80fd\u6bd4\u8f83\u5408\u9002<\/span><span lang=\"en-US\">.<\/span><span lang=\"zh-CN\">\u4f46\u662f<\/span><span lang=\"en-US\">,<\/span><span lang=\"zh-CN\">\u8bf7\u786e\u4fdd\u8be5\u5feb\u7167\u662f\u5728\u53d1\u751f\u9519\u8bef\u4e4b\u524d\u521b\u5efa\u7684<\/span><span lang=\"en-US\">,<\/span><span lang=\"zh-CN\">\u5e76\u4e14\u6570\u636e\u5e93\u5c1a\u672a\u635f\u574f<\/span><span lang=\"en-US\">.<\/span><span lang=\"zh-CN\">\u4f8b\u5982<\/span><span lang=\"en-US\">,<\/span><span lang=\"zh-CN\">\u6062\u590d\u64cd\u4f5c\u53ef\u4ee5\u6062\u590d\u6700\u8fd1\u51fa\u73b0\u7684\u4e25\u91cd\u7528\u6237\u9519\u8bef<\/span><span lang=\"en-US\">,<\/span><span lang=\"zh-CN\">\u5982\u5220\u9664\u8868<\/span><span lang=\"en-US\">.<\/span><\/span><\/span><\/p>\n<p style=\"color: #333333; font-family: Arial; font-style: normal; font-variant: normal; margin: 0in; font-size: 9pt;\"><span style=\"font-family: 'courier new', courier;\"><span style=\"font-size: small;\"><span lang=\"zh-CN\">\u901a\u8fc7\u4ece\u7a00\u758f\u6587\u4ef6\u4e2d\u5c06\u5199\u5165\u65f6\u590d\u5236\u7684\u9875\u590d\u5236\u56de\u6e90\u6570\u636e\u5e93<\/span><span lang=\"en-US\">,<\/span><span lang=\"zh-CN\">\u6062\u590d\u64cd\u4f5c\u5c06\u8986\u76d6\u81ea\u5feb\u7167\u521b\u5efa\u4ee5\u6765\u5bf9\u6e90\u6570\u636e\u5e93\u8fdb\u884c\u7684\u66f4\u65b0<\/span><span lang=\"en-US\">.<\/span><span lang=\"zh-CN\">\u53ea\u6709\u66f4\u65b0\u8fc7\u7684\u9875\u624d\u4f1a\u88ab\u8986\u76d6<\/span><span lang=\"en-US\">.<\/span><span lang=\"zh-CN\">\u6062\u590d\u64cd\u4f5c\u968f\u540e\u4f1a\u8986\u76d6\u65e7\u7684\u65e5\u5fd7\u6587\u4ef6<\/span><span lang=\"en-US\">,<\/span><span lang=\"zh-CN\">\u5e76\u91cd\u5efa\u65e5\u5fd7<\/span><span lang=\"en-US\">.<\/span><span lang=\"zh-CN\">\u56e0\u6b64<\/span><span lang=\"en-US\">,<\/span><span lang=\"zh-CN\">\u4ee5\u540e\u65e0\u6cd5\u5c06\u6062\u590d\u540e\u7684\u6570\u636e\u5e93\u524d\u6eda\u5230\u51fa\u73b0\u7528\u6237\u9519\u8bef\u65f6\u7684\u72b6\u6001<\/span><span lang=\"en-US\">,<\/span><span lang=\"zh-CN\">\u5e76\u4e14\u81ea\u5feb\u7167\u521b\u5efa\u4ee5\u6765\u5bf9\u6570\u636e\u5e93\u8fdb\u884c\u7684\u66f4\u6539\u5c06\u4e22\u5931<\/span><span lang=\"en-US\">.<\/span><span lang=\"zh-CN\">\u6062\u590d\u540e\u7684\u6570\u636e\u5e93\u7684\u5143\u6570\u636e\u4e0e\u521b\u5efa\u5feb\u7167\u65f6\u7684\u5143\u6570\u636e\u76f8\u540c<\/span><span lang=\"en-US\">.<\/span><\/span><\/span><\/p>\n<p style=\"color: #333333; font-family: Arial; font-style: normal; font-variant: normal; margin: 0in; font-size: 9pt;\"><span style=\"font-family: 'courier new', courier;\"><span style=\"font-size: small;\"><span lang=\"zh-CN\">\u6062\u590d\u5230\u67d0\u4e2a\u5feb\u7167\u8fd8\u4f1a\u5220\u9664\u6240\u6709\u5168\u6587\u76ee\u5f55<\/span><span lang=\"en-US\">.<\/span><\/span><\/span><\/p>\n<p style=\"color: #333333; font-style: normal; font-variant: normal; margin: 0in; font-family: \u5b8b\u4f53; font-size: 9pt;\"><span style=\"font-weight: bold;\"><span style=\"font-family: 'courier new', courier;\"><span style=\"font-size: small;\">\u5bf9\u6062\u590d\u7684\u9650\u5236<\/span><\/span><\/span><\/p>\n<p style=\"color: #333333; font-family: Arial; font-style: normal; font-variant: normal; margin: 0in; font-size: 9pt;\"><span style=\"font-family: 'courier new', courier;\"><span style=\"font-size: small;\"><span lang=\"zh-CN\">\u4e0b\u5217\u60c5\u51b5\u4e0d\u652f\u6301\u6062\u590d<\/span><span lang=\"en-US\">:<\/span><\/span><\/span><\/p>\n<ul style=\"color: #333333; font-family: Arial; font-size: 14px; font-style: normal; font-variant: normal; margin-top: 0in; unicode-bidi: embed; direction: ltr; margin-bottom: 0in; margin-left: 0.375in;\" type=\"disc\">\n<li style=\"vertical-align: middle;\"><span style=\"font-family: 'courier new', courier;\"><span style=\"font-size: small;\"><span lang=\"zh-CN\">\u6e90\u6570\u636e\u5e93\u5305\u542b\u4efb\u4f55\u53ea\u8bfb\u6216\u538b\u7f29\u7684\u6587\u4ef6\u7ec4<\/span><span lang=\"en-US\">.<\/span><\/span><\/span><\/li>\n<li style=\"vertical-align: middle;\"><span style=\"font-family: 'courier new', courier;\"><span style=\"font-size: small;\"><span lang=\"zh-CN\">\u67d0\u4e9b\u5728\u521b\u5efa\u5feb\u7167\u65f6\u5904\u4e8e\u8054\u673a\u72b6\u6001\u7684\u6587\u4ef6\u5df2\u8131\u673a<\/span><span lang=\"en-US\">.<\/span><\/span><\/span><\/li>\n<li style=\"vertical-align: middle;\"><span lang=\"zh-CN\" style=\"font-size: 9pt;\"><span style=\"font-family: 'courier new', courier;\"><span style=\"font-size: small;\">\u5f53\u524d\u5b58\u5728\u591a\u4e2a\u6570\u636e\u5e93\u5feb\u7167<\/span><\/span><\/span><span style=\"font-family: 'courier new', courier;\"><span style=\"font-size: small;\"><span lang=\"en-US\">.<br \/>\n<\/span><span lang=\"zh-CN\">\u53ea\u6709\u8981\u6062\u590d\u7684\u5feb\u7167\u624d\u53ef\u5b58\u5728<\/span><span lang=\"en-US\">.<\/span><\/span><\/span><\/li>\n<\/ul>\n<p style=\"color: #333333; font-family: Arial; font-style: normal; font-variant: normal; margin: 0in; font-size: 9pt;\"><span style=\"font-family: 'courier new', courier;\"><span style=\"font-size: small;\"><span lang=\"zh-CN\">\u5728\u6062\u590d\u6570\u636e\u5e93\u4e4b\u524d<\/span><span lang=\"en-US\">,<\/span><span lang=\"zh-CN\">\u6ce8\u610f\u4e0b\u5217\u4e8b\u9879<\/span><span lang=\"en-US\">:<\/span><\/span><\/span><\/p>\n<ul style=\"color: #333333; font-family: Arial; font-size: 14px; font-style: normal; font-variant: normal; margin-top: 0in; unicode-bidi: embed; direction: ltr; margin-bottom: 0in; margin-left: 0.375in;\" type=\"disc\">\n<li style=\"vertical-align: middle;\"><span style=\"font-family: 'courier new', courier;\"><span style=\"font-size: small;\"><span lang=\"zh-CN\">\u4ece\u6570\u636e\u5e93\u5feb\u7167\u6062\u590d\u4e0d\u9002\u7528\u4e8e\u5a92\u4f53\u6062\u590d<\/span><span lang=\"en-US\">.<\/span><span lang=\"zh-CN\">\u4e0e\u5b9a\u671f\u5907\u4efd\u96c6\u4e0d\u540c<\/span><span lang=\"en-US\">,<\/span><span lang=\"zh-CN\">\u6570\u636e\u5e93\u5feb\u7167\u5e76\u975e\u6570\u636e\u5e93\u6587\u4ef6\u7684\u5b8c\u6574\u526f\u672c<\/span><span lang=\"en-US\">.<\/span><span lang=\"zh-CN\">\u5982\u679c\u6570\u636e\u5e93\u6216\u6570\u636e\u5e93\u5feb\u7167\u5df2\u635f\u574f<\/span><span lang=\"en-US\">,<\/span><span lang=\"zh-CN\">\u5219\u53ef\u80fd\u65e0\u6cd5\u4ece\u5feb\u7167\u6062\u590d<\/span><span lang=\"en-US\">.<\/span><span lang=\"zh-CN\">\u53e6\u5916<\/span><span lang=\"en-US\">,<\/span><span lang=\"zh-CN\">\u5982\u679c\u635f\u574f\u7684\u8bdd<\/span><span lang=\"en-US\">,<\/span><span lang=\"zh-CN\">\u5373\u4fbf\u53ef\u4ee5\u6062\u590d<\/span><span lang=\"en-US\">,<\/span><span lang=\"zh-CN\">\u4e5f\u53ef\u80fd\u65e0\u6cd5\u66f4\u6b63\u8be5\u95ee\u9898<\/span><span lang=\"en-US\">.<\/span><\/span><\/span><\/li>\n<li style=\"vertical-align: middle;\"><span style=\"font-family: 'courier new', courier;\"><span style=\"font-size: small;\"><span lang=\"zh-CN\">\u5728\u6062\u590d\u64cd\u4f5c\u671f\u95f4<\/span><span lang=\"en-US\">,<\/span><span lang=\"zh-CN\">\u5feb\u7167\u548c\u6e90\u6570\u636e\u5e93\u90fd\u4e0d\u53ef\u7528<\/span><span lang=\"en-US\">.<\/span><span lang=\"zh-CN\">\u6e90\u6570\u636e\u5e93\u548c\u5feb\u7167\u90fd\u5c06\u88ab\u6807\u8bb0\u4e3a\u201d\u6b63\u5728\u8fd8\u539f\u201d<\/span><span lang=\"en-US\">.<\/span><span lang=\"zh-CN\">\u5982\u679c\u5728\u6062\u590d\u64cd\u4f5c\u671f\u95f4\u51fa\u73b0\u9519\u8bef<\/span><span lang=\"en-US\">,<\/span><span lang=\"zh-CN\">\u5219\u5f53\u6570\u636e\u5e93\u518d\u6b21\u542f\u52a8\u65f6<\/span><span lang=\"en-US\">,<\/span><span lang=\"zh-CN\">\u6062\u590d\u64cd\u4f5c\u5c06\u4f1a\u5c1d\u8bd5\u5b8c\u6210\u6062\u590d<\/span><span lang=\"en-US\">.<\/span><\/span><\/span><\/li>\n<li style=\"vertical-align: middle;\"><span style=\"font-family: 'courier new', courier;\"><span style=\"font-size: small;\"><span lang=\"zh-CN\">\u7531\u4e8e\u6210\u529f\u7684\u6062\u590d\u64cd\u4f5c\u4f1a\u81ea\u52a8\u91cd\u5efa\u65e5\u5fd7<\/span><span lang=\"en-US\">,<\/span><span lang=\"zh-CN\">\u56e0\u6b64<\/span><span lang=\"en-US\">\u00a0Microsoft\u00a0<\/span><span lang=\"zh-CN\">\u5efa\u8bae\u5728\u6062\u590d\u6570\u636e\u5e93\u4e4b\u524d\u5907\u4efd\u65e5\u5fd7<\/span><span lang=\"en-US\">.<\/span><span lang=\"zh-CN\">\u867d\u7136\u4e0d\u80fd\u8fd8\u539f\u539f\u59cb\u65e5\u5fd7\u4ee5\u4fbf\u5c06\u6570\u636e\u5e93\u524d\u6eda<\/span><span lang=\"en-US\">,<\/span><span lang=\"zh-CN\">\u4f46\u662f\u53ef\u4ee5\u4f7f\u7528\u539f\u59cb\u65e5\u5fd7\u6587\u4ef6\u4e2d\u7684\u4fe1\u606f\u6765\u91cd\u65b0\u6784\u9020\u4e22\u5931\u7684\u6570\u636e<\/span><span lang=\"en-US\">.<\/span><\/span><\/span><\/li>\n<li style=\"vertical-align: middle;\"><span style=\"font-family: 'courier new', courier;\"><span style=\"font-size: small;\"><span lang=\"zh-CN\">\u6062\u590d\u64cd\u4f5c\u4f1a\u6253\u65ad\u65e5\u5fd7\u5907\u4efd\u94fe<\/span><span lang=\"en-US\">.<\/span><span lang=\"zh-CN\">\u56e0\u6b64<\/span><span lang=\"en-US\">,<\/span><span lang=\"zh-CN\">\u5fc5\u987b\u5148\u5bf9\u6062\u590d\u7684\u6570\u636e\u5e93\u8fdb\u884c\u5b8c\u6574\u6570\u636e\u5e93\u5907\u4efd\u6216\u6587\u4ef6\u5907\u4efd<\/span><span lang=\"en-US\">,<\/span><span lang=\"zh-CN\">\u7136\u540e\u624d\u80fd\u8fdb\u884c\u65e5\u5fd7\u5907\u4efd<\/span><span lang=\"en-US\">.Microsoft\u00a0<\/span><span lang=\"zh-CN\">\u5efa\u8bae\u8fdb\u884c\u5b8c\u6574\u6570\u636e\u5e93\u5907\u4efd<\/span><span lang=\"en-US\">.<\/span><\/span><\/span><\/li>\n<\/ul>\n<p style=\"color: #333333; font-style: normal; font-variant: normal; margin: 0in; font-family: \u5b8b\u4f53; font-size: 9pt;\"><span style=\"font-weight: bold;\"><span style=\"font-family: 'courier new', courier;\"><span style=\"font-size: small;\">\u5c06\u6570\u636e\u5e93\u6062\u590d\u5230\u6570\u636e\u5e93\u5feb\u7167<\/span><\/span><\/span><\/p>\n<p style=\"color: #333333; font-family: Arial; font-style: normal; font-variant: normal; margin: 0in; font-size: 9pt;\"><span style=\"font-family: 'courier new', courier;\"><span style=\"font-size: small;\"><span lang=\"zh-CN\">\u6570\u636e\u5e93\u5feb\u7167\u4e0d\u662f\u5197\u4f59\u5b58\u50a8<\/span><span lang=\"en-US\">,<\/span><span lang=\"zh-CN\">\u56e0\u6b64<\/span><span lang=\"en-US\">,<\/span><span lang=\"zh-CN\">\u4e0d\u9488\u5bf9\u78c1\u76d8\u9519\u8bef\u6216\u5176\u4ed6\u7c7b\u578b\u7684\u635f\u574f\u63d0\u4f9b\u4efb\u4f55\u4fdd\u62a4\u529f\u80fd<\/span><span lang=\"en-US\">.<\/span><span lang=\"zh-CN\">\u4f46\u662f<\/span><span lang=\"en-US\">,<\/span><span lang=\"zh-CN\">\u5982\u679c\u5728\u8054\u673a\u6570\u636e\u5e93\u4e2d\u53d1\u751f\u7528\u6237\u9519\u8bef<\/span><span lang=\"en-US\">,<\/span><span lang=\"zh-CN\">\u5219\u53ef\u4ee5\u5c06\u6570\u636e\u5e93\u6062\u590d\u5230\u53d1\u751f\u9519\u8bef\u4e4b\u524d\u7684\u6570\u636e\u5e93\u5feb\u7167<\/span><span lang=\"en-US\">.<\/span><\/span><\/span><\/p>\n<p style=\"color: #333333; font-family: Arial; font-style: normal; font-variant: normal; margin: 0in; font-size: 9pt;\"><span style=\"font-family: 'courier new', courier;\"><span style=\"font-size: small;\"><span lang=\"zh-CN\" style=\"font-weight: bold;\">\u91cd\u8981\u63d0\u793a<\/span><span lang=\"en-US\" style=\"font-weight: bold;\">:<\/span><span lang=\"zh-CN\">\u4e3a\u4e86\u4fdd\u62a4\u6570\u636e\u5e93<\/span><span lang=\"en-US\">,<\/span><span lang=\"zh-CN\">\u975e\u5e38\u6709\u5fc5\u8981\u5b9a\u671f\u6267\u884c\u5907\u4efd\u5e76\u6d4b\u8bd5\u8fd8\u539f\u8ba1\u5212<\/span><span lang=\"en-US\">.<\/span><span lang=\"zh-CN\">\u5982\u679c\u5fc5\u987b\u5c06\u6e90\u6570\u636e\u5e93\u8fd8\u539f\u5230\u521b\u5efa\u6570\u636e\u5e93\u5feb\u7167\u7684\u65f6\u95f4\u70b9<\/span><span lang=\"en-US\">,<\/span><span lang=\"zh-CN\">\u8bf7\u5b9e\u65bd\u5141\u8bb8\u60a8\u6267\u884c\u8be5\u64cd\u4f5c\u7684\u5907\u4efd\u7b56\u7565<\/span><span lang=\"en-US\">.<\/span><\/span><\/span><\/p>\n<p style=\"color: #333333; font-family: Arial; font-style: normal; font-variant: normal; margin: 0in; font-size: 9pt;\"><span style=\"font-family: 'courier new', courier;\"><span style=\"font-size: small;\"><span lang=\"zh-CN\">\u6062\u590d\u7684\u6570\u636e\u5e93\u4f1a\u8986\u76d6\u539f\u6765\u7684\u6e90\u6570\u636e\u5e93<\/span><span lang=\"en-US\">.<\/span><span lang=\"zh-CN\">\u6062\u590d\u5230\u5feb\u7167\u5c06\u5220\u9664\u6240\u6709\u5168\u6587\u76ee\u5f55<\/span><span lang=\"en-US\">.<\/span><\/span><\/span><\/p>\n<ol style=\"color: #333333; font-size: 10.5pt; font-style: normal; font-variant: normal; margin-top: 0in; unicode-bidi: embed; font-family: Calibri; direction: ltr; margin-bottom: 0in; margin-left: 0.375in;\" type=\"1\">\n<li style=\"vertical-align: middle;\"><span style=\"font-family: 'courier new', courier;\"><span style=\"font-size: small;\"><span lang=\"zh-CN\" style=\"font-style: normal;\">\u6807\u8bc6\u8981\u5c06\u6570\u636e\u5e93\u6062\u590d\u5230\u7684\u6570\u636e\u5e93\u5feb\u7167<\/span><span lang=\"en-US\" style=\"font-style: normal;\">.<\/span><span lang=\"zh-CN\" style=\"font-style: normal;\">\u6b64\u5916<\/span><span lang=\"en-US\" style=\"font-style: normal;\">,<\/span><span lang=\"zh-CN\" style=\"font-style: normal;\">\u60a8\u8fd8\u53ef\u4ee5\u5728<\/span><span lang=\"en-US\" style=\"font-style: normal;\">\u00a0sys.databases\u00a0<\/span><span lang=\"zh-CN\" style=\"font-style: normal;\">\u76ee\u5f55\u89c6\u56fe\u7684<\/span><span lang=\"en-US\" style=\"font-style: normal; font-weight: bold;\">source_database_id<\/span><span lang=\"en-US\" style=\"font-style: normal;\">\u00a0<\/span><span lang=\"zh-CN\" style=\"font-style: normal;\">\u5217\u4e2d\u627e\u5230\u67d0\u4e2a\u89c6\u56fe\u7684\u6e90\u6570\u636e\u5e93<\/span><span lang=\"en-US\" style=\"font-style: normal;\">.<\/span><\/span><\/span><\/li>\n<li style=\"vertical-align: middle;\"><span lang=\"zh-CN\" style=\"font-size: 9pt;\"><span style=\"font-family: 'courier new', courier;\"><span style=\"font-size: small;\">\u5220\u9664\u5176\u4ed6\u4efb\u4f55\u6570\u636e\u5e93\u5feb\u7167<\/span><\/span><\/span><span style=\"font-family: 'courier new', courier;\"><span style=\"font-size: small;\"><span lang=\"en-US\">.<br \/>\n<\/span><span lang=\"zh-CN\">\u6709\u5173\u5220\u9664\u5feb\u7167\u7684\u4fe1\u606f<\/span><span lang=\"en-US\">.<\/span><span lang=\"zh-CN\">\u5982\u679c\u6570\u636e\u5e93\u4f7f\u7528\u5b8c\u6574\u6062\u590d\u6a21\u5f0f<\/span><span lang=\"en-US\">,<\/span><span lang=\"zh-CN\">\u5219\u5728\u6267\u884c\u6062\u590d\u4e4b\u524d<\/span><span lang=\"en-US\">,<\/span><span lang=\"zh-CN\">\u5e94\u5148\u5907\u4efd\u65e5\u5fd7<\/span><\/span><\/span><\/li>\n<li style=\"vertical-align: middle;\"><span lang=\"zh-CN\" style=\"font-size: 9pt;\"><span style=\"font-family: 'courier new', courier;\"><span style=\"font-size: small;\">\u6267\u884c\u6062\u590d\u64cd\u4f5c<\/span><\/span><\/span><span style=\"font-family: 'courier new', courier;\"><span style=\"font-size: small;\"><span lang=\"en-US\">.<br \/>\n<\/span><span lang=\"zh-CN\">\u6062\u590d\u64cd\u4f5c\u8981\u6c42\u5bf9\u6e90\u6570\u636e\u5e93\u5177\u6709<\/span><span lang=\"en-US\">\u00a0RESTORE DATABASE\u00a0<\/span><span lang=\"zh-CN\">\u6743\u9650<\/span><span lang=\"en-US\">.<\/span><span lang=\"zh-CN\">\u82e5\u8981\u6062\u590d\u6570\u636e\u5e93<\/span><span lang=\"en-US\">,<\/span><span lang=\"zh-CN\">\u8bf7\u4f7f\u7528\u4e0b\u5217<\/span><span lang=\"en-US\">\u00a0Transact-SQL<\/span><span lang=\"zh-CN\">\u8bed\u53e5<\/span><\/span><\/span><span style=\"font-family: 'courier new', courier;\"><span style=\"font-size: small;\"><span lang=\"en-US\">:<br \/>\nRESTORE DATABASE\u00a0<\/span><span lang=\"en-US\" style=\"font-style: italic;\">&lt;<\/span><span lang=\"zh-CN\" style=\"font-style: italic;\">\u6570\u636e\u5e93\u540d\u79f0<\/span><span lang=\"en-US\" style=\"font-style: italic;\">&gt;<\/span><span lang=\"en-US\">\u00a0FROM DATABASE_SNAPSHOT\u00a0<\/span><span lang=\"en-US\" style=\"font-weight: bold;\">=<\/span><span lang=\"en-US\" style=\"font-style: italic;\">&lt;<\/span><span lang=\"zh-CN\" style=\"font-style: italic;\">\u6570\u636e\u5e93\u5feb\u7167\u540d\u79f0<\/span><\/span><\/span><span style=\"font-family: 'courier new', courier;\"><span style=\"font-size: small;\"><span lang=\"en-US\" style=\"font-style: italic;\">&gt;<br \/>\n<\/span><span lang=\"zh-CN\">\u5176\u4e2d<\/span><span lang=\"en-US\">,<\/span><span lang=\"en-US\" style=\"font-style: italic;\">&lt;<\/span><span lang=\"zh-CN\" style=\"font-style: italic;\">\u6570\u636e\u5e93\u540d\u79f0<\/span><span lang=\"en-US\" style=\"font-style: italic;\">&gt;<\/span><span lang=\"en-US\">\u00a0<\/span><span lang=\"zh-CN\">\u662f\u6e90\u6570\u636e\u5e93\u7684\u540d\u79f0<\/span><span lang=\"en-US\">,<\/span><span lang=\"en-US\" style=\"font-style: italic;\">&lt;<\/span><span lang=\"zh-CN\" style=\"font-style: italic;\">\u6570\u636e\u5e93\u5feb\u7167\u540d\u79f0<\/span><span lang=\"en-US\" style=\"font-style: italic;\">&gt;<\/span><span lang=\"en-US\">\u00a0<\/span><span lang=\"zh-CN\">\u662f\u8981\u5c06\u6570\u636e\u5e93\u6062\u590d\u5230\u7684\u5feb\u7167\u7684\u540d\u79f0<\/span><span lang=\"en-US\">.<\/span><span lang=\"zh-CN\">\u6ce8\u610f<\/span><span lang=\"en-US\">,<\/span><span lang=\"zh-CN\">\u5fc5\u987b\u5728\u6b64\u8bed\u53e5\u4e2d\u6307\u5b9a\u5feb\u7167\u540d\u79f0\u800c\u975e\u5907\u4efd\u8bbe\u5907<\/span><span lang=\"en-US\">.<\/span><\/span><\/span><\/li>\n<\/ol>\n<p style=\"color: #333333; font-family: Arial; font-style: normal; font-variant: normal; margin: 0in 0in 0in 0.375in; font-size: 9pt;\"><span style=\"font-family: 'courier new', courier;\"><span style=\"font-size: small;\"><span lang=\"zh-CN\" style=\"font-weight: bold;\">\u6ce8\u610f<\/span><span lang=\"en-US\" style=\"font-weight: bold;\">:<\/span><span lang=\"zh-CN\">\u5728\u6062\u590d\u64cd\u4f5c\u8fc7\u7a0b\u4e2d<\/span><span lang=\"en-US\">,<\/span><span lang=\"zh-CN\">\u5feb\u7167\u548c\u6e90\u6570\u636e\u5e93\u90fd\u4e0d\u53ef\u7528<\/span><span lang=\"en-US\">.<\/span><span lang=\"zh-CN\">\u6e90\u6570\u636e\u5e93\u548c\u5feb\u7167\u90fd\u6807\u8bb0\u4e3a\u201d\u8fd8\u539f\u4e2d\u201d<\/span><span lang=\"en-US\">.<\/span><span lang=\"zh-CN\">\u5982\u679c\u5728\u6062\u590d\u64cd\u4f5c\u671f\u95f4\u53d1\u751f\u9519\u8bef<\/span><span lang=\"en-US\">,<\/span><span lang=\"zh-CN\">\u5219\u6570\u636e\u5e93\u5728\u91cd\u65b0\u542f\u52a8\u540e<\/span><span lang=\"en-US\">,<\/span><span lang=\"zh-CN\">\u5c06\u5c1d\u8bd5\u5b8c\u6210\u6062\u590d\u64cd\u4f5c<\/span><span lang=\"en-US\">.<\/span><\/span><\/span><\/p>\n<ol style=\"color: #333333; font-size: 10.5pt; font-style: normal; font-variant: normal; margin-top: 0in; unicode-bidi: embed; font-family: Calibri; direction: ltr; margin-bottom: 0in; margin-left: 0.375in;\" type=\"1\">\n<li style=\"vertical-align: middle;\"><span style=\"font-family: 'courier new', courier;\"><span style=\"font-size: small;\"><span lang=\"zh-CN\" style=\"font-style: normal;\">\u5982\u679c\u521b\u5efa\u6570\u636e\u5e93\u5feb\u7167\u540e\u6570\u636e\u5e93\u6240\u6709\u8005\u53d1\u751f\u4e86\u53d8\u5316<\/span><span lang=\"en-US\" style=\"font-style: normal;\">,<\/span><span lang=\"zh-CN\" style=\"font-style: normal;\">\u60a8\u53ef\u80fd\u5e0c\u671b\u66f4\u65b0\u6062\u590d\u7684\u6570\u636e\u5e93\u7684\u6570\u636e\u5e93\u6240\u6709\u8005<\/span><span lang=\"en-US\" style=\"font-style: normal;\">.<\/span><\/span><\/span><\/li>\n<\/ol>\n<p style=\"color: #333333; font-family: Arial; font-style: normal; font-variant: normal; margin: 0in 0in 0in 0.375in; font-size: 9pt;\"><span style=\"font-family: 'courier new', courier;\"><span style=\"font-size: small;\"><span lang=\"zh-CN\" style=\"font-weight: bold;\">\u6ce8\u610f<\/span><span lang=\"en-US\" style=\"font-weight: bold;\">:<\/span><span lang=\"zh-CN\">\u5df2\u6062\u590d\u7684\u6570\u636e\u5e93\u5c06\u4fdd\u7559\u6570\u636e\u5e93\u5feb\u7167\u7684\u6743\u9650\u548c\u914d\u7f6e<\/span><span lang=\"en-US\">(<\/span><span lang=\"zh-CN\">\u4f8b\u5982<\/span><span lang=\"en-US\">,<\/span><span lang=\"zh-CN\">\u6570\u636e\u5e93\u6240\u6709\u8005\u548c\u6062\u590d\u6a21\u5f0f<\/span><span lang=\"en-US\">).<\/span><\/span><\/span><\/p>\n<ol style=\"color: #333333; font-size: 10.5pt; font-style: normal; font-variant: normal; margin-top: 0in; unicode-bidi: embed; font-family: Calibri; direction: ltr; margin-bottom: 0in; margin-left: 0.375in;\" type=\"1\">\n<li style=\"vertical-align: middle;\"><span style=\"font-family: 'courier new', courier;\"><span style=\"font-size: small;\"><span lang=\"zh-CN\" style=\"font-style: normal;\">\u542f\u52a8\u6570\u636e\u5e93<\/span><span lang=\"en-US\" style=\"font-style: normal;\">.<\/span><\/span><\/span><\/li>\n<li style=\"vertical-align: middle;\"><span style=\"font-family: 'courier new', courier;\"><span style=\"font-size: small;\"><span lang=\"zh-CN\">\u5c24\u5176\u5728\u4f7f\u7528\u5b8c\u6574<\/span><span lang=\"en-US\">(<\/span><span lang=\"zh-CN\">\u6216\u5927\u5bb9\u91cf\u65e5\u5fd7<\/span><span lang=\"en-US\">)<\/span><span lang=\"zh-CN\">\u6062\u590d\u6a21\u5f0f\u65f6<\/span><span lang=\"en-US\">,<\/span><span lang=\"zh-CN\">\u53ef\u4ee5\u9009\u62e9\u5907\u4efd\u5df2\u6062\u590d\u7684\u6570\u636e\u5e93<\/span><span lang=\"en-US\">.<\/span><span lang=\"zh-CN\">\u672c\u8282\u5305\u542b\u5c06\u6570\u636e\u5e93\u6062\u590d\u5230\u6570\u636e\u5e93\u5feb\u7167\u7684\u793a\u4f8b<\/span><span lang=\"en-US\">.<\/span><\/span><\/span><\/li>\n<\/ol>\n<p style=\"color: #333333; font-family: Arial; font-style: normal; font-variant: normal; margin: 0in; font-size: 9pt;\"><span style=\"font-family: 'courier new', courier;\"><span style=\"font-size: small;\"><span lang=\"en-US\" style=\"font-weight: bold;\">A.\u00a0<\/span><span lang=\"zh-CN\" style=\"font-weight: bold;\">\u6062\u590d<\/span><span lang=\"en-US\" style=\"font-weight: bold;\">\u00a0AdventureWorks2008R2\u00a0<\/span><span lang=\"zh-CN\" style=\"font-weight: bold;\">\u6570\u636e\u5e93\u7684\u5feb\u7167<\/span><\/span><\/span><\/p>\n<p style=\"color: #333333; font-family: Arial; font-style: normal; font-variant: normal; margin: 0in; font-size: 9pt;\"><span style=\"font-family: 'courier new', courier;\"><span style=\"font-size: small;\"><span lang=\"zh-CN\">\u6b64\u793a\u4f8b\u5047\u5b9a<\/span><span lang=\"en-US\">\u00a0AdventureWorks2008R2\u00a0<\/span><span lang=\"zh-CN\">\u6570\u636e\u5e93\u5f53\u524d\u53ea\u5b58\u5728\u4e00\u4e2a\u5feb\u7167<\/span><span lang=\"en-US\">.<\/span><\/span><\/span><\/p>\n<p lang=\"en-US\" style=\"color: #333333; font-family: Arial; font-style: normal; font-variant: normal; margin: 0in; font-size: 9pt;\"><span style=\"font-family: 'courier new', courier;\"><span style=\"font-size: small;\">USE master;<\/span><\/span><\/p>\n<p lang=\"en-US\" style=\"color: #333333; font-family: Arial; font-style: normal; font-variant: normal; margin: 0in; font-size: 9pt;\"><span style=\"font-family: 'courier new', courier;\"><span style=\"font-size: small;\">&#8212; Reverting AdventureWorks2008R2 to AdventureWorks2008R2_dbss1800<\/span><\/span><\/p>\n<p lang=\"en-US\" style=\"color: #333333; font-family: Arial; font-style: normal; font-variant: normal; margin: 0in; font-size: 9pt;\"><span style=\"font-family: 'courier new', courier;\"><span style=\"font-size: small;\">RESTORE DATABASE AdventureWorks2008R2 FROM<\/span><\/span><\/p>\n<p lang=\"en-US\" style=\"color: #333333; font-family: Arial; font-style: normal; font-variant: normal; margin: 0in; font-size: 9pt;\"><span style=\"font-family: 'courier new', courier;\"><span style=\"font-size: small;\">DATABASE_SNAPSHOT = &#8216;AdventureWorks2008R2_dbss1800&#8217;;<\/span><\/span><\/p>\n<p lang=\"en-US\" style=\"color: #333333; font-family: Arial; font-style: normal; font-variant: normal; margin: 0in; font-size: 9pt;\"><span style=\"font-family: 'courier new', courier;\"><span style=\"font-size: small;\">GO<\/span><\/span><\/p>\n<p style=\"color: #333333; font-family: Arial; font-style: normal; font-variant: normal; margin: 0in; font-size: 9pt;\"><span style=\"font-family: 'courier new', courier;\"><span style=\"font-size: small;\"><span lang=\"en-US\" style=\"font-weight: bold;\">B.\u00a0<\/span><span lang=\"zh-CN\" style=\"font-weight: bold;\">\u6062\u590d<\/span><span lang=\"en-US\" style=\"font-weight: bold;\">\u00a0Sales\u00a0<\/span><span lang=\"zh-CN\" style=\"font-weight: bold;\">\u6570\u636e\u5e93\u7684\u5feb\u7167<\/span><\/span><\/span><\/p>\n<p style=\"color: #333333; font-family: Arial; font-style: normal; font-variant: normal; margin: 0in; font-size: 9pt;\"><span style=\"font-family: 'courier new', courier;\"><span style=\"font-size: small;\"><span lang=\"zh-CN\">\u6b64\u793a\u4f8b\u5047\u5b9a<\/span><span lang=\"zh-CN\">\u00a0<\/span><span lang=\"en-US\" style=\"font-weight: bold;\">Sales<\/span><span lang=\"en-US\">\u00a0<\/span><span lang=\"zh-CN\">\u6570\u636e\u5e93\u5f53\u524d\u5b58\u5728\u4e24\u4e2a\u5feb\u7167<\/span><span lang=\"en-US\">:<\/span><span lang=\"en-US\" style=\"font-weight: bold;\">sales_snapshot0600<\/span><span lang=\"en-US\">\u00a0<\/span><span lang=\"zh-CN\">\u548c<\/span><span lang=\"zh-CN\">\u00a0<\/span><span lang=\"en-US\" style=\"font-weight: bold;\">sales_snapshot1200<\/span><span lang=\"en-US\">.<\/span><span lang=\"zh-CN\">\u6b64\u793a\u4f8b\u5220\u9664\u4e86\u8f83\u65e7\u7684\u5feb\u7167\u5e76\u5c06\u6570\u636e\u5e93\u6062\u590d\u5230\u8f83\u65b0\u7684\u5feb\u7167<\/span><span lang=\"en-US\">.<\/span><\/span><\/span><\/p>\n<p lang=\"en-US\" style=\"color: #333333; font-family: Arial; font-style: normal; font-variant: normal; margin: 0in; font-size: 9pt;\"><span style=\"font-family: 'courier new', courier;\"><span style=\"font-size: small;\">&#8211;Test to see if sales_snapshot0600 exists and if it<\/span><\/span><\/p>\n<p lang=\"en-US\" style=\"color: #333333; font-family: Arial; font-style: normal; font-variant: normal; margin: 0in; font-size: 9pt;\"><span style=\"font-family: 'courier new', courier;\"><span style=\"font-size: small;\">&#8212; does, delete it.<\/span><\/span><\/p>\n<p lang=\"en-US\" style=\"color: #333333; font-family: Arial; font-style: normal; font-variant: normal; margin: 0in; font-size: 9pt;\"><span style=\"font-family: 'courier new', courier;\"><span style=\"font-size: small;\">IF EXISTS (SELECT dbid FROM sys.databases<\/span><\/span><\/p>\n<p lang=\"en-US\" style=\"color: #333333; font-family: Arial; font-style: normal; font-variant: normal; margin: 0in; font-size: 9pt;\"><span style=\"font-family: 'courier new', courier;\"><span style=\"font-size: small;\">\u00a0\u00a0\u00a0\u00a0WHERE NAME=&#8217;sales_snapshot0600&#8242;)<\/span><\/span><\/p>\n<p lang=\"en-US\" style=\"color: #333333; font-family: Arial; font-style: normal; font-variant: normal; margin: 0in; font-size: 9pt;\"><span style=\"font-family: 'courier new', courier;\"><span style=\"font-size: small;\">\u00a0\u00a0\u00a0\u00a0DROP DATABASE SalesSnapshot0600;<\/span><\/span><\/p>\n<p lang=\"en-US\" style=\"color: #333333; font-family: Arial; font-style: normal; font-variant: normal; margin: 0in; font-size: 9pt;\"><span style=\"font-family: 'courier new', courier;\"><span style=\"font-size: small;\">GO<\/span><\/span><\/p>\n<p lang=\"en-US\" style=\"color: #333333; font-family: Arial; font-style: normal; font-variant: normal; margin: 0in; font-size: 9pt;\"><span style=\"font-family: 'courier new', courier;\"><span style=\"font-size: small;\">&#8212; Reverting Sales to sales_snapshot1200<\/span><\/span><\/p>\n<p lang=\"en-US\" style=\"color: #333333; font-family: Arial; font-style: normal; font-variant: normal; margin: 0in; font-size: 9pt;\"><span style=\"font-family: 'courier new', courier;\"><span style=\"font-size: small;\">USE master;<\/span><\/span><\/p>\n<p lang=\"en-US\" style=\"color: #333333; font-family: Arial; font-style: normal; font-variant: normal; margin: 0in; font-size: 9pt;\"><span style=\"font-family: 'courier new', courier;\"><span style=\"font-size: small;\">RESTORE DATABASE Sales FROM DATABASE_SNAPSHOT = &#8216;sales_snapshot1200&#8217;;<\/span><\/span><\/p>\n<p lang=\"en-US\" style=\"color: #333333; font-family: Arial; font-style: normal; font-variant: normal; margin: 0in; font-size: 9pt;\"><span style=\"font-family: 'courier new', courier;\"><span style=\"font-size: small;\">GO<\/span><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u5982\u4f55\u6062\u590d\u5230\u5feb\u7167\u7ed3\u679c,\u8bf4\u660e\u6062\u590d\u64cd\u4f5c\u7684\u9650\u5236,\u5e76\u63d0\u4f9b\u6307\u5411\u6062\u590d\u8fc7\u7a0b\u7684\u94fe\u63a5.\u4f5c\u4e3a\u4ece\u5907\u4efd\u4e2d\u8fd8\u539f\u8054\u673a\u6570\u636e\u5e93\u7684\u66ff\u4ee3\u65b9\u6cd5,\u4efb\u4f55\u5bf9 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[17],"tags":[16],"class_list":["post-209","post","type-post","status-publish","format-standard","hentry","category-sqlserver","tag-sql_server_2008_r2"],"_links":{"self":[{"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=\/wp\/v2\/posts\/209","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=209"}],"version-history":[{"count":0,"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=\/wp\/v2\/posts\/209\/revisions"}],"wp:attachment":[{"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=209"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=209"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=209"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}