{"id":195,"date":"2011-05-29T10:38:04","date_gmt":"2011-05-29T02:38:04","guid":{"rendered":"http:\/\/www.royalwzy.com\/?p=195"},"modified":"2013-12-30T14:03:27","modified_gmt":"2013-12-30T06:03:27","slug":"%e5%b0%be%e6%97%a5%e5%bf%97%e5%a4%87%e4%bb%bd","status":"publish","type":"post","link":"http:\/\/www.royalwzy.com\/?p=195","title":{"rendered":"\u5c3e\u65e5\u5fd7\u5907\u4efd"},"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\" style=\"color: black;\">\u5bf9\u4e8e\u5927\u591a\u6570\u60c5\u51b5<\/span><span lang=\"en-US\" style=\"color: black;\">,<\/span><span lang=\"zh-CN\" style=\"color: black;\">\u5728\u5b8c\u6574\u6062\u590d\u6a21\u5f0f\u6216\u5927\u5bb9\u91cf\u65e5\u5fd7\u6062\u590d\u6a21\u5f0f\u4e0b<\/span><span lang=\"en-US\" style=\"color: black;\">,SQL Server 2005\u00a0<\/span><span lang=\"zh-CN\" style=\"color: black;\">\u53ca\u66f4\u9ad8\u7248\u672c\u8981\u6c42\u60a8\u5907\u4efd\u65e5\u5fd7\u7ed3\u5c3e\u4ee5\u6355\u83b7\u5c1a\u672a\u5907\u4efd\u7684\u65e5\u5fd7\u8bb0\u5f55<\/span><span lang=\"en-US\" style=\"color: black;\">.<\/span><span lang=\"zh-CN\" style=\"color: red;\">\u8fd8\u539f\u64cd\u4f5c\u4e4b\u524d\u5bf9\u65e5\u5fd7\u5c3e\u90e8\u6267\u884c\u7684\u65e5\u5fd7\u5907\u4efd\u79f0\u4e3a<\/span><span lang=\"en-US\" style=\"color: red;\">&#8220;<\/span><span lang=\"zh-CN\" style=\"color: red;\">\u7ed3\u5c3e\u65e5\u5fd7\u5907\u4efd<\/span><span lang=\"en-US\" style=\"color: red;\">&#8220;.<\/span><\/span><\/span><\/p>\n<p style=\"font-family: Arial; font-style: normal; font-variant: normal; margin: 0in; color: black; font-size: 9pt;\"><span style=\"font-family: 'courier new', courier;\"><span style=\"font-size: small;\"><span lang=\"en-US\">SQL Server 2005\u00a0<\/span><span lang=\"zh-CN\">\u53ca\u66f4\u9ad8\u7248\u672c\u901a\u5e38\u8981\u6c42\u60a8\u5728\u5f00\u59cb\u8fd8\u539f\u6570\u636e\u5e93\u524d\u6267\u884c\u7ed3\u5c3e\u65e5\u5fd7\u5907\u4efd<\/span><span lang=\"en-US\">.<\/span><span lang=\"zh-CN\">\u7ed3\u5c3e\u65e5\u5fd7\u5907\u4efd\u53ef\u4ee5\u9632\u6b62\u5de5\u4f5c\u4e22\u5931\u5e76\u786e\u4fdd\u65e5\u5fd7\u94fe\u7684\u5b8c\u6574\u6027<\/span><span lang=\"en-US\">.<\/span><span lang=\"zh-CN\">\u5c06\u6570\u636e\u5e93\u6062\u590d\u5230\u6545\u969c\u70b9\u65f6<\/span><span lang=\"en-US\">,<\/span><span lang=\"zh-CN\">\u7ed3\u5c3e\u65e5\u5fd7\u5907\u4efd\u662f\u6062\u590d\u8ba1\u5212\u4e2d\u7684\u6700\u540e\u4e00\u4e2a\u76f8\u5173\u5907\u4efd<\/span><span lang=\"en-US\">.<\/span><span lang=\"zh-CN\">\u5982\u679c\u65e0\u6cd5\u5907\u4efd\u65e5\u5fd7\u5c3e\u90e8<\/span><span lang=\"en-US\">,<\/span><span lang=\"zh-CN\">\u5219\u53ea\u80fd\u5c06\u6570\u636e\u5e93\u6062\u590d\u4e3a\u6545\u969c\u524d\u521b\u5efa\u7684\u6700\u540e\u4e00\u4e2a\u5907\u4efd<\/span><span lang=\"en-US\">.<\/span><\/span><\/span><\/p>\n<p style=\"font-family: Arial; font-style: normal; font-variant: normal; margin: 0in; color: black; font-size: 9pt;\"><span style=\"font-family: 'courier new', courier;\"><span style=\"font-size: small;\"><span lang=\"zh-CN\">\u5e76\u975e\u6240\u6709\u8fd8\u539f\u65b9\u6848\u90fd\u8981\u6c42\u6267\u884c\u7ed3\u5c3e\u65e5\u5fd7\u5907\u4efd<\/span><span lang=\"en-US\">.<\/span><span lang=\"zh-CN\">\u5982\u679c\u5148\u524d\u7684\u65e5\u5fd7\u5907\u4efd\u4e2d\u5305\u542b\u6062\u590d\u70b9<\/span><span lang=\"en-US\">,<\/span><span lang=\"zh-CN\">\u6216\u8005\u60a8\u51c6\u5907\u79fb\u52a8\u6216\u66ff\u6362<\/span><span lang=\"en-US\">(<\/span><span lang=\"zh-CN\">\u8986\u76d6<\/span><span lang=\"en-US\">)<\/span><span lang=\"zh-CN\">\u6570\u636e\u5e93<\/span><span lang=\"en-US\">,<\/span><span lang=\"zh-CN\">\u5219\u4e0d\u4e00\u5b9a\u9700\u8981\u7ed3\u5c3e\u65e5\u5fd7\u5907\u4efd<\/span><span lang=\"en-US\">.<\/span><span lang=\"zh-CN\">\u5e76\u4e14<\/span><span lang=\"en-US\">,<\/span><span lang=\"zh-CN\">\u5982\u679c\u65e5\u5fd7\u6587\u4ef6\u53d7\u635f\u4e14\u65e0\u6cd5\u521b\u5efa\u7ed3\u5c3e\u65e5\u5fd7\u5907\u4efd<\/span><span lang=\"en-US\">,<\/span><span lang=\"zh-CN\">\u5219\u5fc5\u987b\u5728\u4e0d\u4f7f\u7528\u7ed3\u5c3e\u65e5\u5fd7\u5907\u4efd\u7684\u60c5\u51b5\u4e0b\u8fd8\u539f\u6570\u636e\u5e93<\/span><span lang=\"en-US\">.<\/span><span lang=\"zh-CN\">\u6700\u65b0\u65e5\u5fd7\u5907\u4efd\u540e\u63d0\u4ea4\u7684\u4efb\u4f55\u4e8b\u52a1\u90fd\u5c06\u4e22\u5931<\/span><\/span><\/span><\/p>\n<p style=\"font-style: normal; font-variant: normal; margin: 0in; font-family: \u5b8b\u4f53; color: black; font-size: 9pt;\"><span style=\"font-weight: bold;\"><span style=\"font-family: 'courier new', courier;\"><span style=\"font-size: small;\">\u5907\u4efd\u65e5\u5fd7\u5c3e\u90e8<\/span><\/span><\/span><\/p>\n<p style=\"font-family: Arial; font-style: normal; font-variant: normal; margin: 0in; color: black; font-size: 9pt;\"><span style=\"font-family: 'courier new', courier;\"><span style=\"font-size: small;\"><span lang=\"zh-CN\">\u7ed3\u5c3e\u65e5\u5fd7\u5907\u4efd\u4e0e\u4efb\u4f55\u5176\u4ed6\u65e5\u5fd7\u5907\u4efd\u7c7b\u4f3c<\/span><span lang=\"en-US\">,<\/span><span lang=\"zh-CN\">\u4f7f\u7528<\/span><span lang=\"en-US\">\u00a0BACKUP LOG\u00a0<\/span><span lang=\"zh-CN\">\u8bed\u53e5\u6267\u884c<\/span><span lang=\"en-US\">.<\/span><span lang=\"zh-CN\">\u5efa\u8bae\u4e0b\u5217\u60c5\u51b5\u4e0b\u6267\u884c\u7ed3\u5c3e\u65e5\u5fd7\u5907\u4efd<\/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\" style=\"color: black;\">\u5982\u679c\u6570\u636e\u5e93\u5904\u4e8e\u8054\u673a\u72b6\u6001<\/span><span lang=\"en-US\" style=\"color: black;\">,<\/span><span lang=\"zh-CN\" style=\"color: black;\">\u6bcf\u5f53\u60a8\u51c6\u5907\u5bf9\u6570\u636e\u5e93\u6267\u884c\u7684\u4e0b\u4e00\u4e2a\u64cd\u4f5c\u4e3a\u8fd8\u539f\u64cd\u4f5c\u65f6<\/span><span lang=\"en-US\" style=\"color: black;\">,<\/span><span lang=\"zh-CN\" style=\"color: black;\">\u8bf7\u5728\u5f00\u59cb\u8fd8\u539f\u987a\u5e8f\u4e4b\u524d\u4f7f\u7528<\/span><span lang=\"en-US\" style=\"color: black;\">WITH NORECOVERY\u00a0<\/span><span lang=\"zh-CN\" style=\"color: black;\">\u5907\u4efd\u65e5\u5fd7\u5c3e\u90e8<\/span><\/span><\/span><span style=\"font-family: 'courier new', courier;\"><span style=\"font-size: small;\"><span lang=\"en-US\" style=\"color: black;\">:<br \/>\nBACKUP LOG\u00a0<\/span><span lang=\"zh-CN\" style=\"color: black;\">\u6570\u636e\u5e93\u540d\u79f0<\/span><span lang=\"en-US\" style=\"color: black;\">\u00a0TO &lt;<\/span><span lang=\"zh-CN\" style=\"color: black;\">\u5907\u4efd\u8bbe\u5907<\/span><span lang=\"en-US\" style=\"color: black;\">&gt; WITH NORECOVERY<\/span><\/span><\/span><\/li>\n<\/ul>\n<p style=\"font-family: Arial; font-style: normal; font-variant: normal; margin: 0in 0in 0in 0.375in; color: black; 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\">\u4e3a\u9632\u6b62\u51fa\u9519<\/span><span lang=\"en-US\">,<\/span><span lang=\"zh-CN\">\u5fc5\u987b\u4f7f\u7528<\/span><span lang=\"en-US\">\u00a0NORECOVERY\u00a0<\/span><span lang=\"zh-CN\">\u9009\u9879<\/span><span lang=\"en-US\">(<\/span><span lang=\"zh-CN\">\u6307\u5b9a\u4e0d\u53d1\u751f\u56de\u6eda<\/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 lang=\"zh-CN\" style=\"color: black; font-size: 9pt;\"><span style=\"font-family: 'courier new', courier;\"><span style=\"font-size: small;\">\u5982\u679c\u6570\u636e\u5e93\u5904\u4e8e\u8131\u673a\u72b6\u6001\u5e76\u4e14\u65e0\u6cd5\u542f\u52a8<\/span><\/span><\/span><span style=\"font-family: 'courier new', courier;\"><span style=\"font-size: small;\"><span lang=\"en-US\" style=\"color: black;\">.<br \/>\n<\/span><span lang=\"zh-CN\" style=\"color: black;\">\u5c1d\u8bd5\u6267\u884c\u7ed3\u5c3e\u65e5\u5fd7\u5907\u4efd<\/span><span lang=\"en-US\" style=\"color: black;\">.<\/span><span lang=\"zh-CN\" style=\"color: black;\">\u7531\u4e8e\u6b64\u65f6\u4e0d\u4f1a\u53d1\u751f\u4efb\u4f55\u4e8b\u52a1<\/span><span lang=\"en-US\" style=\"color: black;\">,<\/span><span lang=\"zh-CN\" style=\"color: black;\">\u6240\u4ee5<\/span><span lang=\"en-US\" style=\"color: black;\">\u00a0WITH NORECOVERY\u00a0<\/span><span lang=\"zh-CN\" style=\"color: black;\">\u662f\u53ef\u9009\u7684<\/span><span lang=\"en-US\" style=\"color: black;\">.<\/span><span lang=\"zh-CN\" style=\"color: black;\">\u5982\u679c\u6570\u636e\u5e93\u53d7\u635f<\/span><span lang=\"en-US\" style=\"color: black;\">,<\/span><span lang=\"zh-CN\" style=\"color: black;\">\u8bf7\u4f7f\u7528<\/span><span lang=\"en-US\" style=\"color: black;\">\u00a0WITH CONTINUE_AFTER_ERROR\u00a0<\/span><span lang=\"zh-CN\" style=\"color: black;\">\u6216<\/span><\/span><\/span><span style=\"font-family: 'courier new', courier;\"><span style=\"font-size: small;\"><span lang=\"en-US\" style=\"color: black;\">\u00a0WITH NO_TRUNCATE.<br \/>\nBACKUP LOG\u00a0<\/span><span lang=\"zh-CN\" style=\"color: black;\">\u6570\u636e\u5e93\u540d\u79f0<\/span><span lang=\"en-US\" style=\"color: black;\">\u00a0TO &lt;<\/span><span lang=\"zh-CN\" style=\"color: black;\">\u5907\u4efd\u8bbe\u5907<\/span><span lang=\"en-US\" style=\"color: black;\">&gt; [WITH { CONTINUE_AFTER_ERROR | NO_TRUNCATE }<\/span><\/span><\/span><\/li>\n<\/ul>\n<p style=\"font-family: Arial; font-style: normal; font-variant: normal; margin: 0in 0in 0in 0.375in; color: black; 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\">\u9664\u975e\u6570\u636e\u5e93\u53d7\u635f<\/span><span lang=\"en-US\">,<\/span><span lang=\"zh-CN\">\u5426\u5219\u4e0d\u5efa\u8bae\u4f7f\u7528<\/span><span lang=\"en-US\">\u00a0NO_TRUNCATE.<\/span><\/span><\/span><\/p>\n<p style=\"font-family: Arial; font-style: normal; font-variant: normal; margin: 0in; color: black; font-size: 9pt;\"><span style=\"font-family: 'courier new', courier;\"><span style=\"font-size: small;\"><span lang=\"zh-CN\">\u5982\u679c\u6570\u636e\u5e93\u53d7\u635f<\/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\u65e0\u6cd5\u542f\u52a8<\/span><span lang=\"en-US\">),<\/span><span lang=\"zh-CN\">\u5219\u4ec5\u5f53\u65e5\u5fd7\u6587\u4ef6\u672a\u53d7\u635f<\/span><span lang=\"en-US\">,<\/span><span lang=\"zh-CN\">\u6570\u636e\u5e93\u5904\u4e8e\u652f\u6301\u7ed3\u5c3e\u65e5\u5fd7\u5907\u4efd\u7684\u72b6\u6001\u5e76\u4e14\u4e0d\u5305\u542b\u4efb\u4f55\u5927\u5bb9\u91cf\u65e5\u5fd7\u66f4\u6539\u65f6<\/span><span lang=\"en-US\">,<\/span><span lang=\"zh-CN\">\u7ed3\u5c3e\u65e5\u5fd7\u5907\u4efd\u624d\u80fd\u6210\u529f<\/span><span lang=\"en-US\">.<\/span><\/span><\/span><\/p>\n<div style=\"color: #333333; font-family: Arial; font-size: 14px; font-style: normal; font-variant: normal; direction: ltr;\">\n<table style=\"border-collapse: collapse; direction: ltr; border: 1pt solid #a3a3a3;\" border=\"1\" cellspacing=\"0\" cellpadding=\"0\">\n<tbody>\n<tr>\n<td style=\"width: 2.625in; vertical-align: top; border-width: 1pt; border-top-style: solid; border-right-style: solid; border-left-style: solid; border-color: #a3a3a3; padding: 4pt;\">\n<p style=\"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;\">BACKUP LOG\u00a0<\/span><span lang=\"zh-CN\" style=\"font-weight: bold;\">\u9009\u9879<\/span><\/span><\/span><\/p>\n<\/td>\n<td style=\"width: 7.006in; vertical-align: top; border-width: 1pt; border-top-style: solid; border-right-style: solid; border-left-style: solid; border-color: #a3a3a3; padding: 4pt;\">\n<p style=\"margin: 0in; font-size: 9pt;\"><span style=\"font-family: 'courier new', courier;\"><span style=\"font-size: small;\"><span style=\"font-weight: bold;\">\u6ce8\u91ca<\/span><\/span><\/span><\/p>\n<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 2.625in; vertical-align: top; border-width: 1pt; border-top-style: solid; border-right-style: solid; border-left-style: solid; border-color: #a3a3a3; padding: 4pt;\">\n<p lang=\"en-US\" style=\"margin: 0in; font-size: 9pt;\"><span style=\"font-family: 'courier new', courier;\"><span style=\"font-size: small;\">NORECOVERY<\/span><\/span><\/p>\n<\/td>\n<td style=\"width: 7.006in; vertical-align: top; border-width: 1pt; border-top-style: solid; border-right-style: solid; border-left-style: solid; border-color: #a3a3a3; padding: 4pt;\">\n<p style=\"margin: 0in; font-size: 9pt;\"><span style=\"font-family: 'courier new', courier;\"><span style=\"font-size: small;\"><span lang=\"zh-CN\">\u6bcf\u5f53\u60a8\u51c6\u5907\u5bf9\u6570\u636e\u5e93\u7ee7\u7eed\u6267\u884c\u8fd8\u539f\u64cd\u4f5c\u65f6<\/span><span lang=\"en-US\">,<\/span><span lang=\"zh-CN\">\u8bf7\u4f7f\u7528<\/span><span lang=\"en-US\">\u00a0NORECOVERY.NORECOVERY<\/span><span lang=\"zh-CN\">\u4f7f\u6570\u636e\u5e93\u8fdb\u5165\u8fd8\u539f\u72b6\u6001<\/span><span lang=\"en-US\">.<\/span><span lang=\"zh-CN\">\u8fd9\u786e\u4fdd\u4e86\u6570\u636e\u5e93\u5728\u7ed3\u5c3e\u65e5\u5fd7\u5907\u4efd\u540e\u4e0d\u4f1a\u66f4\u6539<\/span><span lang=\"en-US\">.<\/span><\/span><\/span><\/p>\n<p style=\"margin: 0in; font-size: 9pt;\"><span style=\"font-family: 'courier new', courier;\"><span style=\"font-size: small;\"><span lang=\"zh-CN\">\u9664\u975e\u540c\u65f6\u6307\u5b9a<\/span><span lang=\"en-US\">\u00a0NO_TRUNCATE\u00a0<\/span><span lang=\"zh-CN\">\u6216<\/span><span lang=\"en-US\">\u00a0COPY_ONLY\u00a0<\/span><span lang=\"zh-CN\">\u9009\u9879<\/span><span lang=\"en-US\">,<\/span><span lang=\"zh-CN\">\u5426\u5219\u5c06\u622a\u65ad\u65e5\u5fd7<\/span><span lang=\"en-US\">.<\/span><\/span><\/span><\/p>\n<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 2.625in; vertical-align: top; border-width: 1pt; border-top-style: solid; border-right-style: solid; border-left-style: solid; border-color: #a3a3a3; padding: 4pt;\">\n<p lang=\"en-US\" style=\"margin: 0in; font-size: 9pt;\"><span style=\"font-family: 'courier new', courier;\"><span style=\"font-size: small;\">{ CONTINUE_AFTER_ERROR | NO_TRUNCATE }<\/span><\/span><\/p>\n<\/td>\n<td style=\"width: 7.006in; vertical-align: top; border-width: 1pt; border-top-style: solid; border-right-style: solid; border-left-style: solid; border-color: #a3a3a3; padding: 4pt;\">\n<p style=\"margin: 0in; font-size: 9pt;\"><span style=\"font-family: 'courier new', courier;\"><span style=\"font-size: small;\"><span lang=\"zh-CN\">\u4ec5\u5f53\u60a8\u8981\u5907\u4efd\u53d7\u635f\u6570\u636e\u5e93\u7684\u5c3e\u90e8\u65f6\u624d\u80fd\u4f7f\u7528<\/span><span lang=\"en-US\">\u00a0NO_TRUNCATE\u00a0<\/span><span lang=\"zh-CN\">\u6216<\/span><span lang=\"en-US\">CONTINUE_AFTER_ERROR.<\/span><\/span><\/span><\/p>\n<p style=\"margin: 0in; font-size: 9pt;\"><span style=\"font-family: 'courier new', courier;\"><span style=\"font-size: small;\"><span lang=\"zh-CN\">\u6ce8\u610f<\/span><span lang=\"en-US\">:<\/span><span lang=\"zh-CN\">\u5bf9\u53d7\u635f\u6570\u636e\u5e93\u5907\u4efd\u65e5\u5fd7\u5c3e\u90e8\u65f6<\/span><span lang=\"en-US\">,<\/span><span lang=\"zh-CN\">\u65e5\u5fd7\u5907\u4efd\u4e2d\u6b63\u5e38\u6355\u83b7\u7684\u90e8\u5206\u5143\u6570\u636e\u53ef\u80fd\u4e0d\u53ef\u7528<\/span><span lang=\"en-US\">.<\/span><\/span><\/span><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<p style=\"font-family: Arial; font-style: normal; font-variant: normal; margin: 0in; color: black; font-size: 9pt;\"><span style=\"font-family: 'courier new', courier;\"><span style=\"font-size: small;\"><span lang=\"zh-CN\" style=\"font-weight: bold;\">\u5728\u6570\u636e\u5e93\u635f\u574f\u65f6\u521b\u5efa\u4e8b\u52a1\u65e5\u5fd7\u5907\u4efd<\/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\" style=\"color: black;\">\u5982\u4f55\u5728\u6570\u636e\u5e93\u635f\u574f\u65f6\u5907\u4efd\u4e8b\u52a1\u65e5\u5fd7<\/span><span lang=\"en-US\" style=\"color: black;\">\u00a0(Transact-SQL)<\/span><\/span><\/span><\/li>\n<\/ul>\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\" style=\"color: black;\">\u5982\u4f55\u5907\u4efd\u4e8b\u52a1\u65e5\u5fd7<\/span><span lang=\"en-US\" style=\"color: black;\">\u00a0(SQL Server Management Studio)<\/span><\/span><\/span><\/li>\n<\/ul>\n<p style=\"font-style: normal; font-variant: normal; margin: 0in; font-family: \u5b8b\u4f53; color: black; font-size: 9pt;\"><span style=\"font-weight: bold;\"><span style=\"font-family: 'courier new', courier;\"><span style=\"font-size: small;\">\u5305\u542b\u4e0d\u5b8c\u6574\u5907\u4efd\u5143\u6570\u636e\u7684\u7ed3\u5c3e\u65e5\u5fd7\u5907\u4efd<\/span><\/span><\/span><\/p>\n<p style=\"font-family: Arial; font-style: normal; font-variant: normal; margin: 0in; color: black; font-size: 9pt;\"><span style=\"font-family: 'courier new', courier;\"><span style=\"font-size: small;\"><span lang=\"zh-CN\">\u7ed3\u5c3e\u65e5\u5fd7\u5907\u4efd\u53ef\u6355\u83b7\u65e5\u5fd7\u5c3e\u90e8<\/span><span lang=\"en-US\">,<\/span><span lang=\"zh-CN\">\u5373\u4f7f\u6570\u636e\u5e93\u8131\u673a<\/span><span lang=\"en-US\">,<\/span><span lang=\"zh-CN\">\u635f\u574f\u6216\u7f3a\u5c11\u6570\u636e\u6587\u4ef6<\/span><span lang=\"en-US\">.<\/span><span lang=\"zh-CN\">\u8fd9\u53ef\u80fd\u5bfc\u81f4\u8fd8\u539f\u4fe1\u606f\u547d\u4ee4\u548c<\/span><span lang=\"zh-CN\">\u00a0<\/span><span lang=\"en-US\" style=\"font-weight: bold;\">msdb<\/span><span lang=\"en-US\">\u00a0<\/span><span lang=\"zh-CN\">\u751f\u6210\u4e0d\u5b8c\u6574\u7684\u5143\u6570\u636e<\/span><span lang=\"en-US\">.<\/span><span lang=\"zh-CN\">\u4f46\u53ea\u6709\u5143\u6570\u636e\u662f\u4e0d\u5b8c\u6574\u7684<\/span><span lang=\"en-US\">,<\/span><span lang=\"zh-CN\">\u800c\u6355\u83b7\u7684\u65e5\u5fd7\u662f\u5b8c\u6574\u4e14\u53ef\u7528\u7684<\/span><span lang=\"en-US\">.<\/span><\/span><\/span><\/p>\n<p style=\"font-family: Arial; font-style: normal; font-variant: normal; margin: 0in; color: black; font-size: 9pt;\"><span style=\"font-family: 'courier new', courier;\"><span style=\"font-size: small;\"><span lang=\"zh-CN\">\u5982\u679c\u7ed3\u5c3e\u65e5\u5fd7\u5907\u4efd\u5305\u542b\u4e0d\u5b8c\u6574\u7684\u5143\u6570\u636e<\/span><span lang=\"en-US\">,<\/span><span lang=\"zh-CN\">\u5219<\/span><span lang=\"en-US\">\u00a0backupset\u00a0<\/span><span lang=\"zh-CN\">\u8868\u4e2d\u7684<\/span><span lang=\"zh-CN\">\u00a0<\/span><span lang=\"en-US\" style=\"font-weight: bold;\">has_incomplete_metadata<\/span><span lang=\"en-US\">\u00a0<\/span><span lang=\"zh-CN\">\u5c06\u8bbe\u7f6e\u4e3a<\/span><span lang=\"zh-CN\">\u00a0<\/span><span lang=\"en-US\" style=\"font-weight: bold;\">1<\/span><span lang=\"en-US\">.<\/span><span lang=\"zh-CN\">\u6b64\u5916<\/span><span lang=\"en-US\">,<\/span><span lang=\"zh-CN\">\u5728<\/span><span lang=\"en-US\">RESTORE HEADERONLY\u00a0<\/span><span lang=\"zh-CN\">\u7684\u8f93\u51fa\u4e2d<\/span><span lang=\"en-US\">,<\/span><span lang=\"en-US\" style=\"font-weight: bold;\">HasIncompleteMetadata<\/span><span lang=\"en-US\">\u00a0<\/span><span lang=\"zh-CN\">\u5c06\u8bbe\u7f6e\u4e3a<\/span><span lang=\"zh-CN\">\u00a0<\/span><span lang=\"en-US\" style=\"font-weight: bold;\">1<\/span><span lang=\"en-US\">.<\/span><\/span><\/span><\/p>\n<p style=\"font-family: Arial; font-style: normal; font-variant: normal; margin: 0in; color: black; font-size: 9pt;\"><span style=\"font-family: 'courier new', courier;\"><span style=\"font-size: small;\"><span lang=\"zh-CN\">\u5982\u679c\u7ed3\u5c3e\u65e5\u5fd7\u5907\u4efd\u4e2d\u7684\u5143\u6570\u636e\u4e0d\u5b8c\u6574<\/span><span lang=\"en-US\">,<\/span><span lang=\"zh-CN\">\u5219<\/span><span lang=\"en-US\">\u00a0backupfilegroup\u00a0<\/span><span lang=\"zh-CN\">\u8868\u5728\u7ed3\u5c3e\u65e5\u5fd7\u5907\u4efd\u65f6\u5c06\u4e22\u5931\u6587\u4ef6\u7ec4\u7684\u5927\u591a\u6570\u76f8\u5173\u4fe1\u606f<\/span><span lang=\"en-US\">.<\/span><span lang=\"zh-CN\">\u5927\u591a\u6570<\/span><span lang=\"zh-CN\">\u00a0<\/span><span lang=\"en-US\" style=\"font-weight: bold;\">backupfilegroup<\/span><span lang=\"en-US\">\u00a0<\/span><span lang=\"zh-CN\">\u8868\u5217\u4e3a<\/span><span lang=\"en-US\">\u00a0NULL;<\/span><span lang=\"zh-CN\">\u53ea\u6709\u4ee5\u4e0b\u51e0\u5217\u6709\u610f\u4e49<\/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 lang=\"en-US\" style=\"vertical-align: middle;\"><span style=\"font-family: 'courier new', courier;\"><span style=\"font-size: small;\"><span style=\"color: black; font-weight: bold;\">backup_set_id<\/span><\/span><\/span><\/li>\n<\/ul>\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 lang=\"en-US\" style=\"vertical-align: middle;\"><span style=\"font-family: 'courier new', courier;\"><span style=\"font-size: small;\"><span style=\"color: black; font-weight: bold;\">filegroup_id<\/span><\/span><\/span><\/li>\n<\/ul>\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 lang=\"en-US\" style=\"vertical-align: middle;\"><span style=\"font-family: 'courier new', courier;\"><span style=\"font-size: small;\"><span style=\"color: black; font-weight: bold;\">type<\/span><\/span><\/span><\/li>\n<\/ul>\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 lang=\"en-US\" style=\"vertical-align: middle;\"><span style=\"font-family: 'courier new', courier;\"><span style=\"font-size: small;\"><span style=\"color: black; font-weight: bold;\">type_desc<\/span><\/span><\/span><\/li>\n<\/ul>\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 lang=\"en-US\" style=\"vertical-align: middle;\"><span style=\"font-family: 'courier new', courier;\"><span style=\"font-size: small;\"><span style=\"color: black; font-weight: bold;\">is_readonly<\/span><\/span><\/span><\/li>\n<\/ul>\n<p style=\"font-style: normal; font-variant: normal; margin: 0in; font-family: \u5b8b\u4f53; color: black; font-size: 9pt;\"><span style=\"font-weight: bold;\"><span style=\"font-family: 'courier new', courier;\"><span style=\"font-size: small;\">\u4e0d\u4f7f\u7528\u7ed3\u5c3e\u65e5\u5fd7\u5907\u4efd\u6267\u884c\u8fd8\u539f<\/span><\/span><\/span><\/p>\n<p style=\"font-family: Arial; font-style: normal; font-variant: normal; margin: 0in; color: black; font-size: 9pt;\"><span style=\"font-family: 'courier new', courier;\"><span style=\"font-size: small;\"><span lang=\"zh-CN\">\u4e0d\u9700\u8981\u7ed3\u5c3e\u65e5\u5fd7\u5907\u4efd\u7684\u8fd8\u539f\u65b9\u6848\u5305\u62ec\u4ee5\u4e0b\u51e0\u79cd<\/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 lang=\"zh-CN\" style=\"color: black; font-size: 9pt;\"><span style=\"font-family: 'courier new', courier;\"><span style=\"font-size: small;\">\u5c06\u6570\u636e\u5e93\u8fd8\u539f\u5230\u5148\u524d\u65e5\u5fd7\u5907\u4efd\u4e2d\u5305\u542b\u7684\u67d0\u4e2a\u65f6\u95f4\u70b9<\/span><\/span><\/span><span style=\"font-family: 'courier new', courier;\"><span style=\"font-size: small;\"><span lang=\"en-US\" style=\"color: black;\">.<br \/>\n<\/span><span lang=\"zh-CN\" style=\"color: black;\">\u5982\u679c\u8fd8\u539f\u4e00\u4e2a\u6570\u636e\u5e93\u5e76\u5728\u8fd8\u539f\u987a\u5e8f\u4e2d\u7684\u6bcf\u4e2a<\/span><span lang=\"en-US\" style=\"color: black;\">\u00a0RESTORE\u00a0<\/span><span lang=\"zh-CN\" style=\"color: black;\">\u8bed\u53e5\u4e2d\u6307\u5b9a<\/span><span lang=\"en-US\" style=\"color: black;\">\u00a0STOPAT,STOPATMARK\u00a0<\/span><span lang=\"zh-CN\" style=\"color: black;\">\u6216<\/span><span lang=\"en-US\" style=\"color: black;\">STOPBEFOREMARK\u00a0<\/span><span lang=\"zh-CN\" style=\"color: black;\">\u9009\u9879<\/span><span lang=\"en-US\" style=\"color: black;\">,<\/span><span lang=\"zh-CN\" style=\"color: black;\">\u5219\u4e0d\u5fc5\u8fdb\u884c\u7ed3\u5c3e\u65e5\u5fd7\u5907\u4efd<\/span><span lang=\"en-US\" style=\"color: black;\">.<\/span><\/span><\/span><\/li>\n<\/ul>\n<p style=\"font-family: Arial; font-style: normal; font-variant: normal; margin: 0in; color: black; font-size: 9pt;\"><span style=\"font-family: 'courier new', courier;\"><span style=\"font-size: small;\"><span lang=\"zh-CN\" style=\"font-weight: bold;\">\u5c06\u6570\u636e\u5e93\u8fd8\u539f\u5230\u5148\u524d\u65f6\u95f4\u70b9<\/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\" style=\"color: black;\">\u82e5\u8981\u4f7f\u7528<\/span><span lang=\"en-US\" style=\"color: black;\">\u00a0Transact-SQL\u00a0<\/span><span lang=\"zh-CN\" style=\"color: black;\">\u8fd8\u539f\u5230\u7279\u5b9a\u65f6\u95f4\u70b9<\/span><span lang=\"en-US\" style=\"color: black;\">,<\/span><span lang=\"zh-CN\" style=\"color: black;\">\u8bf7\u53c2\u9605\u5982\u4f55\u8fd8\u539f\u5230\u67d0\u4e2a\u65f6\u95f4\u70b9<\/span><span lang=\"en-US\" style=\"color: black;\">\u00a0(Transact-SQL),<\/span><span lang=\"zh-CN\" style=\"color: black;\">\u6062\u590d\u5230\u6807\u8bb0\u7684\u4e8b\u52a1\u6216\u6062\u590d\u5230\u65e5\u5fd7\u5e8f\u5217\u53f7<\/span><span lang=\"en-US\" style=\"color: black;\">\u00a0(LSN).<\/span><\/span><\/span><\/li>\n<\/ul>\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\" style=\"color: black;\">\u82e5\u8981\u4f7f\u7528<\/span><span lang=\"en-US\" style=\"color: black;\">\u00a0SQL Server Management Studio,<\/span><span lang=\"zh-CN\" style=\"color: black;\">\u8bf7\u53c2\u9605\u5982\u4f55\u8fd8\u539f\u5230\u67d0\u4e2a\u65f6\u70b9<\/span><span lang=\"en-US\" style=\"color: black;\">\u00a0(SQL Server Management Studio)<\/span><span lang=\"zh-CN\" style=\"color: black;\">\u6216\u5982\u4f55\u5c06\u6570\u636e\u5e93\u8fd8\u539f\u5230\u6807\u8bb0\u7684\u4e8b\u52a1<\/span><span lang=\"en-US\" style=\"color: black;\">\u00a0(SQL Server Management Studio).<\/span><\/span><\/span><\/li>\n<\/ul>\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 lang=\"zh-CN\" style=\"color: black; font-size: 9pt;\"><span style=\"font-family: 'courier new', courier;\"><span style=\"font-size: small;\">\u5c06\u6570\u636e\u5e93\u526f\u672c\u8fd8\u539f\u5230\u65b0\u4f4d\u7f6e<\/span><\/span><\/span><span style=\"font-family: 'courier new', courier;\"><span style=\"font-size: small;\"><span lang=\"en-US\" style=\"color: black;\">.<br \/>\n<\/span><span lang=\"zh-CN\" style=\"color: black;\">\u5f53\u60a8\u8fd8\u539f\u6570\u636e\u5e93\u65f6<\/span><span lang=\"en-US\" style=\"color: black;\">,<\/span><span lang=\"zh-CN\" style=\"color: black;\">\u53ea\u6709\u5c06\u6570\u636e\u5e93\u8fd8\u539f\u5230\u4e0d\u540c\u7684\u670d\u52a1\u5668\u5b9e\u4f8b\u65f6<\/span><span lang=\"en-US\" style=\"color: black;\">,<\/span><span lang=\"zh-CN\" style=\"color: black;\">\u624d\u53ef\u4ee5\u4f7f\u7528\u76f8\u540c\u7684\u6570\u636e\u5e93\u540d\u79f0<\/span><span lang=\"en-US\" style=\"color: black;\">,<\/span><span lang=\"zh-CN\" style=\"color: black;\">\u4f8b\u5982<\/span><span lang=\"en-US\" style=\"color: black;\">,<\/span><span lang=\"zh-CN\" style=\"color: black;\">\u521b\u5efa\u955c\u50cf\u6570\u636e\u5e93\u7528\u4e8e\u6570\u636e\u5e93\u955c\u50cf\u6216\u521b\u5efa\u8f85\u52a9\u6570\u636e\u5e93\u7528\u4e8e\u65e5\u5fd7\u4f20\u9001<\/span><span lang=\"en-US\" style=\"color: black;\">.<\/span><span lang=\"zh-CN\" style=\"color: black;\">\u5982\u679c\u5728\u540c\u4e00\u670d\u52a1\u5668\u5b9e\u4f8b\u4e0a\u79fb\u52a8\u6570\u636e\u5e93<\/span><span lang=\"en-US\" style=\"color: black;\">,<\/span><span lang=\"zh-CN\" style=\"color: black;\">\u60a8\u5fc5\u987b\u4e3a\u6570\u636e\u5e93\u6307\u5b9a\u65b0\u540d\u79f0<\/span><span lang=\"en-US\" style=\"color: black;\">.<\/span><\/span><\/span><\/li>\n<\/ul>\n<p style=\"font-family: Arial; font-style: normal; font-variant: normal; margin: 0in; color: black; font-size: 9pt;\"><span style=\"font-family: 'courier new', courier;\"><span style=\"font-size: small;\"><span lang=\"zh-CN\" style=\"font-weight: bold;\">\u5c06\u6570\u636e\u5e93\u8fd8\u539f\u5230\u65b0\u4f4d\u7f6e<\/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\" style=\"color: black;\">\u5728\u8fd8\u539f\u987a\u5e8f\u7684\u6bcf\u4e2a<\/span><span lang=\"en-US\" style=\"color: black;\">\u00a0RESTORE\u00a0<\/span><span lang=\"zh-CN\" style=\"color: black;\">\u8bed\u53e5\u4e2d<\/span><span lang=\"en-US\" style=\"color: black;\">,<\/span><span lang=\"zh-CN\" style=\"color: black;\">\u4f7f\u7528<\/span><span lang=\"en-US\" style=\"color: black;\">\u00a0Transact-SQL\u00a0<\/span><span lang=\"zh-CN\" style=\"color: black;\">\u6307\u5b9a<\/span><span lang=\"en-US\" style=\"color: black;\">\u00a0MOVE\u00a0<\/span><span lang=\"zh-CN\" style=\"color: black;\">\u9009\u9879<\/span><span lang=\"en-US\" style=\"color: black;\">.<\/span><\/span><\/span><\/li>\n<\/ul>\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\" style=\"color: black;\">\u4f7f\u7528<\/span><span lang=\"en-US\" style=\"color: black;\">\u00a0SQL Server Management Studio,<\/span><span lang=\"zh-CN\" style=\"color: black;\">\u5728<\/span><\/span><\/span><\/li>\n<\/ul>\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=\"color: black;\">\u5bf9\u4e8e\u5927\u591a\u6570\u60c5\u51b5<\/span><span lang=\"en-US\" style=\"color: black;\">,<\/span><span lang=\"zh-CN\" style=\"color: black;\">\u5728\u5b8c\u6574\u6062\u590d\u6a21\u5f0f\u6216\u5927\u5bb9\u91cf\u65e5\u5fd7\u6062\u590d\u6a21\u5f0f\u4e0b<\/span><span lang=\"en-US\" style=\"color: black;\">,SQL Server 2005\u00a0<\/span><span lang=\"zh-CN\" style=\"color: black;\">\u53ca\u66f4\u9ad8\u7248\u672c\u8981\u6c42\u60a8\u5907\u4efd\u65e5\u5fd7\u7ed3\u5c3e\u4ee5\u6355\u83b7\u5c1a\u672a\u5907\u4efd\u7684\u65e5\u5fd7\u8bb0\u5f55<\/span><span lang=\"en-US\" style=\"color: black;\">.<\/span><span lang=\"zh-CN\" style=\"color: red;\">\u8fd8\u539f\u64cd\u4f5c\u4e4b\u524d\u5bf9\u65e5\u5fd7\u5c3e\u90e8\u6267\u884c\u7684\u65e5\u5fd7\u5907\u4efd\u79f0\u4e3a\u201d\u7ed3\u5c3e\u65e5\u5fd7\u5907\u4efd\u201d<\/span><span lang=\"en-US\" style=\"color: red;\">.<\/span><\/span><\/span><\/p>\n<p style=\"font-family: Arial; font-style: normal; font-variant: normal; margin: 0in 0in 0in 0.375in; color: black; font-size: 9pt;\"><span style=\"font-family: 'courier new', courier;\"><span style=\"font-size: small;\"><span lang=\"en-US\">SQL Server 2005\u00a0<\/span><span lang=\"zh-CN\">\u53ca\u66f4\u9ad8\u7248\u672c\u901a\u5e38\u8981\u6c42\u60a8\u5728\u5f00\u59cb\u8fd8\u539f\u6570\u636e\u5e93\u524d\u6267\u884c\u7ed3\u5c3e\u65e5\u5fd7\u5907\u4efd<\/span><span lang=\"en-US\">.<\/span><span lang=\"zh-CN\">\u7ed3\u5c3e\u65e5\u5fd7\u5907\u4efd\u53ef\u4ee5\u9632\u6b62\u5de5\u4f5c\u4e22\u5931\u5e76\u786e\u4fdd\u65e5\u5fd7\u94fe\u7684\u5b8c\u6574\u6027<\/span><span lang=\"en-US\">.<\/span><span lang=\"zh-CN\">\u5c06\u6570\u636e\u5e93\u6062\u590d\u5230\u6545\u969c\u70b9\u65f6<\/span><span lang=\"en-US\">,<\/span><span lang=\"zh-CN\">\u7ed3\u5c3e\u65e5\u5fd7\u5907\u4efd\u662f\u6062\u590d\u8ba1\u5212\u4e2d\u7684\u6700\u540e\u4e00\u4e2a\u76f8\u5173\u5907\u4efd<\/span><span lang=\"en-US\">.<\/span><span lang=\"zh-CN\">\u5982\u679c\u65e0\u6cd5\u5907\u4efd\u65e5\u5fd7\u5c3e\u90e8<\/span><span lang=\"en-US\">,<\/span><span lang=\"zh-CN\">\u5219\u53ea\u80fd\u5c06\u6570\u636e\u5e93\u6062\u590d\u4e3a\u6545\u969c\u524d\u521b\u5efa\u7684\u6700\u540e\u4e00\u4e2a\u5907\u4efd<\/span><span lang=\"en-US\">.<\/span><\/span><\/span><\/p>\n<p style=\"font-family: Arial; font-style: normal; font-variant: normal; margin: 0in 0in 0in 0.375in; color: black; font-size: 9pt;\"><span style=\"font-family: 'courier new', courier;\"><span style=\"font-size: small;\"><span lang=\"zh-CN\">\u5e76\u975e\u6240\u6709\u8fd8\u539f\u65b9\u6848\u90fd\u8981\u6c42\u6267\u884c\u7ed3\u5c3e\u65e5\u5fd7\u5907\u4efd<\/span><span lang=\"en-US\">.<\/span><span lang=\"zh-CN\">\u5982\u679c\u5148\u524d\u7684\u65e5\u5fd7\u5907\u4efd\u4e2d\u5305\u542b\u6062\u590d\u70b9<\/span><span lang=\"en-US\">,<\/span><span lang=\"zh-CN\">\u6216\u8005\u60a8\u51c6\u5907\u79fb\u52a8\u6216\u66ff\u6362<\/span><span lang=\"en-US\">(<\/span><span lang=\"zh-CN\">\u8986\u76d6<\/span><span lang=\"en-US\">)<\/span><span lang=\"zh-CN\">\u6570\u636e\u5e93<\/span><span lang=\"en-US\">,<\/span><span lang=\"zh-CN\">\u5219\u4e0d\u4e00\u5b9a\u9700\u8981\u7ed3\u5c3e\u65e5\u5fd7\u5907\u4efd<\/span><span lang=\"en-US\">.<\/span><span lang=\"zh-CN\">\u5e76\u4e14<\/span><span lang=\"en-US\">,<\/span><span lang=\"zh-CN\">\u5982\u679c\u65e5\u5fd7\u6587\u4ef6\u53d7\u635f\u4e14\u65e0\u6cd5\u521b\u5efa\u7ed3\u5c3e\u65e5\u5fd7\u5907\u4efd<\/span><span lang=\"en-US\">,<\/span><span lang=\"zh-CN\">\u5219\u5fc5\u987b\u5728\u4e0d\u4f7f\u7528\u7ed3\u5c3e\u65e5\u5fd7\u5907\u4efd\u7684\u60c5\u51b5\u4e0b\u8fd8\u539f\u6570\u636e\u5e93<\/span><span lang=\"en-US\">.<\/span><span lang=\"zh-CN\">\u6700\u65b0\u65e5\u5fd7\u5907\u4efd\u540e\u63d0\u4ea4\u7684\u4efb\u4f55\u4e8b\u52a1\u90fd\u5c06\u4e22\u5931<\/span><\/span><\/span><\/p>\n<p style=\"font-style: normal; font-variant: normal; margin: 0in 0in 0in 0.375in; font-family: \u5b8b\u4f53; color: black; font-size: 9pt;\"><span style=\"font-weight: bold;\"><span style=\"font-family: 'courier new', courier;\"><span style=\"font-size: small;\">\u5907\u4efd\u65e5\u5fd7\u5c3e\u90e8<\/span><\/span><\/span><\/p>\n<p style=\"font-family: Arial; font-style: normal; font-variant: normal; margin: 0in 0in 0in 0.375in; color: black; font-size: 9pt;\"><span style=\"font-family: 'courier new', courier;\"><span style=\"font-size: small;\"><span lang=\"zh-CN\">\u7ed3\u5c3e\u65e5\u5fd7\u5907\u4efd\u4e0e\u4efb\u4f55\u5176\u4ed6\u65e5\u5fd7\u5907\u4efd\u7c7b\u4f3c<\/span><span lang=\"en-US\">,<\/span><span lang=\"zh-CN\">\u4f7f\u7528<\/span><span lang=\"en-US\">\u00a0BACKUP LOG\u00a0<\/span><span lang=\"zh-CN\">\u8bed\u53e5\u6267\u884c<\/span><span lang=\"en-US\">.<\/span><span lang=\"zh-CN\">\u5efa\u8bae\u4e0b\u5217\u60c5\u51b5\u4e0b\u6267\u884c\u7ed3\u5c3e\u65e5\u5fd7\u5907\u4efd<\/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.75in;\" type=\"disc\">\n<li style=\"vertical-align: middle;\"><span style=\"font-family: 'courier new', courier;\"><span style=\"font-size: small;\"><span lang=\"zh-CN\" style=\"color: black;\">\u5982\u679c\u6570\u636e\u5e93\u5904\u4e8e\u8054\u673a\u72b6\u6001<\/span><span lang=\"en-US\" style=\"color: black;\">,<\/span><span lang=\"zh-CN\" style=\"color: black;\">\u6bcf\u5f53\u60a8\u51c6\u5907\u5bf9\u6570\u636e\u5e93\u6267\u884c\u7684\u4e0b\u4e00\u4e2a\u64cd\u4f5c\u4e3a\u8fd8\u539f\u64cd\u4f5c\u65f6<\/span><span lang=\"en-US\" style=\"color: black;\">,<\/span><span lang=\"zh-CN\" style=\"color: black;\">\u8bf7\u5728\u5f00\u59cb\u8fd8\u539f\u987a\u5e8f\u4e4b\u524d\u4f7f\u7528<\/span><span lang=\"en-US\" style=\"color: black;\">\u00a0WITH NORECOVERY\u00a0<\/span><span lang=\"zh-CN\" style=\"color: black;\">\u5907\u4efd\u65e5\u5fd7\u5c3e\u90e8<\/span><\/span><\/span><span style=\"font-family: 'courier new', courier;\"><span style=\"font-size: small;\"><span lang=\"en-US\" style=\"color: black;\">:<br \/>\nBACKUP LOG\u00a0<\/span><span lang=\"zh-CN\" style=\"font-style: italic; color: black;\">\u6570\u636e\u5e93\u540d\u79f0<\/span><span lang=\"en-US\" style=\"color: black;\">\u00a0TO &lt;<\/span><span lang=\"zh-CN\" style=\"color: black;\">\u5907\u4efd\u8bbe\u5907<\/span><span lang=\"en-US\" style=\"color: black;\">&gt; WITH NORECOVERY<\/span><\/span><\/span><\/li>\n<\/ul>\n<p style=\"font-family: Arial; font-style: normal; font-variant: normal; margin: 0in 0in 0in 0.75in; color: black; 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\">\u4e3a\u9632\u6b62\u51fa\u9519<\/span><span lang=\"en-US\">,<\/span><span lang=\"zh-CN\">\u5fc5\u987b\u4f7f\u7528<\/span><span lang=\"en-US\">\u00a0NORECOVERY\u00a0<\/span><span lang=\"zh-CN\">\u9009\u9879<\/span><span lang=\"en-US\">(<\/span><span lang=\"zh-CN\">\u6307\u5b9a\u4e0d\u53d1\u751f\u56de\u6eda<\/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.75in;\" type=\"disc\">\n<li style=\"vertical-align: middle;\"><span lang=\"zh-CN\" style=\"color: black; font-size: 9pt;\"><span style=\"font-family: 'courier new', courier;\"><span style=\"font-size: small;\">\u5982\u679c\u6570\u636e\u5e93\u5904\u4e8e\u8131\u673a\u72b6\u6001\u5e76\u4e14\u65e0\u6cd5\u542f\u52a8<\/span><\/span><\/span><span style=\"font-family: 'courier new', courier;\"><span style=\"font-size: small;\"><span lang=\"en-US\" style=\"color: black;\">.<br \/>\n<\/span><span lang=\"zh-CN\" style=\"color: black;\">\u5c1d\u8bd5\u6267\u884c\u7ed3\u5c3e\u65e5\u5fd7\u5907\u4efd<\/span><span lang=\"en-US\" style=\"color: black;\">.<\/span><span lang=\"zh-CN\" style=\"color: black;\">\u7531\u4e8e\u6b64\u65f6\u4e0d\u4f1a\u53d1\u751f\u4efb\u4f55\u4e8b\u52a1<\/span><span lang=\"en-US\" style=\"color: black;\">,<\/span><span lang=\"zh-CN\" style=\"color: black;\">\u6240\u4ee5<\/span><span lang=\"en-US\" style=\"color: black;\">\u00a0WITH NORECOVERY\u00a0<\/span><span lang=\"zh-CN\" style=\"color: black;\">\u662f\u53ef\u9009\u7684<\/span><span lang=\"en-US\" style=\"color: black;\">.<\/span><span lang=\"zh-CN\" style=\"color: black;\">\u5982\u679c\u6570\u636e\u5e93\u53d7\u635f<\/span><span lang=\"en-US\" style=\"color: black;\">,<\/span><span lang=\"zh-CN\" style=\"color: black;\">\u8bf7\u4f7f\u7528<\/span><span lang=\"en-US\" style=\"color: black;\">\u00a0WITH CONTINUE_AFTER_ERROR\u00a0<\/span><span lang=\"zh-CN\" style=\"color: black;\">\u6216<\/span><\/span><\/span><span style=\"font-family: 'courier new', courier;\"><span style=\"font-size: small;\"><span lang=\"en-US\" style=\"color: black;\">\u00a0WITH NO_TRUNCATE.<br \/>\nBACKUP LOG\u00a0<\/span><span lang=\"zh-CN\" style=\"font-style: italic; color: black;\">\u6570\u636e\u5e93\u540d\u79f0<\/span><span lang=\"en-US\" style=\"color: black;\">\u00a0TO &lt;<\/span><span lang=\"zh-CN\" style=\"color: black;\">\u5907\u4efd\u8bbe\u5907<\/span><span lang=\"en-US\" style=\"color: black;\">&gt; [WITH { CONTINUE_AFTER_ERROR | NO_TRUNCATE }<\/span><\/span><\/span><\/li>\n<\/ul>\n<p style=\"font-family: Arial; font-style: normal; font-variant: normal; margin: 0in 0in 0in 0.75in; color: black; 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\">\u9664\u975e\u6570\u636e\u5e93\u53d7\u635f<\/span><span lang=\"en-US\">,<\/span><span lang=\"zh-CN\">\u5426\u5219\u4e0d\u5efa\u8bae\u4f7f\u7528<\/span><span lang=\"en-US\">\u00a0NO_TRUNCATE.<\/span><\/span><\/span><\/p>\n<p style=\"font-family: Arial; font-style: normal; font-variant: normal; margin: 0in 0in 0in 0.375in; color: black; font-size: 9pt;\"><span style=\"font-family: 'courier new', courier;\"><span style=\"font-size: small;\"><span lang=\"zh-CN\">\u5982\u679c\u6570\u636e\u5e93\u53d7\u635f<\/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\u65e0\u6cd5\u542f\u52a8<\/span><span lang=\"en-US\">),<\/span><span lang=\"zh-CN\">\u5219\u4ec5\u5f53\u65e5\u5fd7\u6587\u4ef6\u672a\u53d7\u635f<\/span><span lang=\"en-US\">,<\/span><span lang=\"zh-CN\">\u6570\u636e\u5e93\u5904\u4e8e\u652f\u6301\u7ed3\u5c3e\u65e5\u5fd7\u5907\u4efd\u7684\u72b6\u6001\u5e76\u4e14\u4e0d\u5305\u542b\u4efb\u4f55\u5927\u5bb9\u91cf\u65e5\u5fd7\u66f4\u6539\u65f6<\/span><span lang=\"en-US\">,<\/span><span lang=\"zh-CN\">\u7ed3\u5c3e\u65e5\u5fd7\u5907\u4efd\u624d\u80fd\u6210\u529f<\/span><span lang=\"en-US\">.<\/span><\/span><\/span><\/p>\n<div style=\"color: #333333; font-family: Arial; font-size: 14px; font-style: normal; font-variant: normal; direction: ltr;\">\n<table style=\"border-collapse: collapse; direction: ltr; margin-left: 0.333in; border: 1pt solid #a3a3a3;\" border=\"1\" cellspacing=\"0\" cellpadding=\"0\">\n<tbody>\n<tr>\n<td style=\"width: 2.536in; vertical-align: top; border-width: 1pt; border-top-style: solid; border-right-style: solid; border-left-style: solid; border-color: #a3a3a3; padding: 4pt;\">\n<p style=\"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;\">BACKUP LOG\u00a0<\/span><span lang=\"zh-CN\" style=\"font-weight: bold;\">\u9009\u9879<\/span><\/span><\/span><\/p>\n<\/td>\n<td style=\"width: 6.72in; vertical-align: top; border-width: 1pt; border-top-style: solid; border-right-style: solid; border-left-style: solid; border-color: #a3a3a3; padding: 4pt;\">\n<p style=\"margin: 0in; font-size: 9pt;\"><span style=\"font-family: 'courier new', courier;\"><span style=\"font-size: small;\"><span style=\"font-weight: bold;\">\u6ce8\u91ca<\/span><\/span><\/span><\/p>\n<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 2.536in; vertical-align: top; border-width: 1pt; border-top-style: solid; border-right-style: solid; border-left-style: solid; border-color: #a3a3a3; padding: 4pt;\">\n<p lang=\"en-US\" style=\"margin: 0in; font-size: 9pt;\"><span style=\"font-family: 'courier new', courier;\"><span style=\"font-size: small;\">NORECOVERY<\/span><\/span><\/p>\n<\/td>\n<td style=\"width: 6.72in; vertical-align: top; border-width: 1pt; border-top-style: solid; border-right-style: solid; border-left-style: solid; border-color: #a3a3a3; padding: 4pt;\">\n<p style=\"margin: 0in; font-size: 9pt;\"><span style=\"font-family: 'courier new', courier;\"><span style=\"font-size: small;\"><span lang=\"zh-CN\">\u6bcf\u5f53\u60a8\u51c6\u5907\u5bf9\u6570\u636e\u5e93\u7ee7\u7eed\u6267\u884c\u8fd8\u539f\u64cd\u4f5c\u65f6<\/span><span lang=\"en-US\">,<\/span><span lang=\"zh-CN\">\u8bf7\u4f7f\u7528<\/span><span lang=\"en-US\">NORECOVERY.NORECOVERY\u00a0<\/span><span lang=\"zh-CN\">\u4f7f\u6570\u636e\u5e93\u8fdb\u5165\u8fd8\u539f\u72b6\u6001<\/span><span lang=\"en-US\">.<\/span><span lang=\"zh-CN\">\u8fd9\u786e\u4fdd\u4e86\u6570\u636e\u5e93\u5728\u7ed3\u5c3e\u65e5\u5fd7\u5907\u4efd\u540e\u4e0d\u4f1a\u66f4\u6539<\/span><span lang=\"en-US\">.<\/span><\/span><\/span><\/p>\n<p style=\"margin: 0in; font-size: 9pt;\"><span style=\"font-family: 'courier new', courier;\"><span style=\"font-size: small;\"><span lang=\"zh-CN\">\u9664\u975e\u540c\u65f6\u6307\u5b9a<\/span><span lang=\"en-US\">\u00a0NO_TRUNCATE\u00a0<\/span><span lang=\"zh-CN\">\u6216<\/span><span lang=\"en-US\">\u00a0COPY_ONLY\u00a0<\/span><span lang=\"zh-CN\">\u9009\u9879<\/span><span lang=\"en-US\">,<\/span><span lang=\"zh-CN\">\u5426\u5219\u5c06\u622a\u65ad\u65e5\u5fd7<\/span><span lang=\"en-US\">.<\/span><\/span><\/span><\/p>\n<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 2.536in; vertical-align: top; border-width: 1pt; border-top-style: solid; border-right-style: solid; border-left-style: solid; border-color: #a3a3a3; padding: 4pt;\">\n<p lang=\"en-US\" style=\"margin: 0in; font-size: 9pt;\"><span style=\"font-family: 'courier new', courier;\"><span style=\"font-size: small;\">{ CONTINUE_AFTER_ERROR | NO_TRUNCATE }<\/span><\/span><\/p>\n<\/td>\n<td style=\"width: 6.72in; vertical-align: top; border-width: 1pt; border-top-style: solid; border-right-style: solid; border-left-style: solid; border-color: #a3a3a3; padding: 4pt;\">\n<p style=\"margin: 0in; font-size: 9pt;\"><span style=\"font-family: 'courier new', courier;\"><span style=\"font-size: small;\"><span lang=\"zh-CN\">\u4ec5\u5f53\u60a8\u8981\u5907\u4efd\u53d7\u635f\u6570\u636e\u5e93\u7684\u5c3e\u90e8\u65f6\u624d\u80fd\u4f7f\u7528<\/span><span lang=\"en-US\">\u00a0NO_TRUNCATE\u00a0<\/span><span lang=\"zh-CN\">\u6216<\/span><span lang=\"en-US\">CONTINUE_AFTER_ERROR.<\/span><\/span><\/span><\/p>\n<p style=\"margin: 0in; font-size: 9pt;\"><span style=\"font-family: 'courier new', courier;\"><span style=\"font-size: small;\"><span lang=\"zh-CN\">\u6ce8\u610f<\/span><span lang=\"en-US\">:<\/span><span lang=\"zh-CN\">\u5bf9\u53d7\u635f\u6570\u636e\u5e93\u5907\u4efd\u65e5\u5fd7\u5c3e\u90e8\u65f6<\/span><span lang=\"en-US\">,<\/span><span lang=\"zh-CN\">\u65e5\u5fd7\u5907\u4efd\u4e2d\u6b63\u5e38\u6355\u83b7\u7684\u90e8\u5206\u5143\u6570\u636e\u53ef\u80fd\u4e0d\u53ef\u7528<\/span><span lang=\"en-US\">.<\/span><\/span><\/span><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<p style=\"font-family: Arial; font-style: normal; font-variant: normal; margin: 0in; color: black; font-size: 9pt;\"><span style=\"font-family: 'courier new', courier;\"><span style=\"font-size: small;\"><span lang=\"zh-CN\" style=\"font-weight: bold;\">\u5728\u6570\u636e\u5e93\u635f\u574f\u65f6\u521b\u5efa\u4e8b\u52a1\u65e5\u5fd7\u5907\u4efd<\/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\" style=\"color: black;\">\u5982\u4f55\u5728\u6570\u636e\u5e93\u635f\u574f\u65f6\u5907\u4efd\u4e8b\u52a1\u65e5\u5fd7<\/span><span lang=\"en-US\" style=\"color: black;\">\u00a0(Transact-SQL)<\/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\" style=\"color: black;\">\u5982\u4f55\u5907\u4efd\u4e8b\u52a1\u65e5\u5fd7<\/span><span lang=\"en-US\" style=\"color: black;\">\u00a0(SQL Server Management Studio)<\/span><\/span><\/span><\/li>\n<\/ul>\n<p lang=\"en-US\" 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;\">\u00a0<\/span><\/span><\/p>\n<p style=\"font-style: normal; font-variant: normal; margin: 0in; font-family: \u5b8b\u4f53; color: black; font-size: 9pt;\"><span style=\"font-weight: bold;\"><span style=\"font-family: 'courier new', courier;\"><span style=\"font-size: small;\">\u5305\u542b\u4e0d\u5b8c\u6574\u5907\u4efd\u5143\u6570\u636e\u7684\u7ed3\u5c3e\u65e5\u5fd7\u5907\u4efd<\/span><\/span><\/span><\/p>\n<p style=\"font-family: Arial; font-style: normal; font-variant: normal; margin: 0in; color: black; font-size: 9pt;\"><span style=\"font-family: 'courier new', courier;\"><span style=\"font-size: small;\"><span lang=\"zh-CN\">\u7ed3\u5c3e\u65e5\u5fd7\u5907\u4efd\u53ef\u6355\u83b7\u65e5\u5fd7\u5c3e\u90e8<\/span><span lang=\"en-US\">,<\/span><span lang=\"zh-CN\">\u5373\u4f7f\u6570\u636e\u5e93\u8131\u673a<\/span><span lang=\"en-US\">,<\/span><span lang=\"zh-CN\">\u635f\u574f\u6216\u7f3a\u5c11\u6570\u636e\u6587\u4ef6<\/span><span lang=\"en-US\">.<\/span><span lang=\"zh-CN\">\u8fd9\u53ef\u80fd\u5bfc\u81f4\u8fd8\u539f\u4fe1\u606f\u547d\u4ee4\u548c<\/span><span lang=\"zh-CN\">\u00a0<\/span><span lang=\"en-US\" style=\"font-weight: bold;\">msdb<\/span><span lang=\"en-US\">\u00a0<\/span><span lang=\"zh-CN\">\u751f\u6210\u4e0d\u5b8c\u6574\u7684\u5143\u6570\u636e<\/span><span lang=\"en-US\">.<\/span><span lang=\"zh-CN\">\u4f46\u53ea\u6709\u5143\u6570\u636e\u662f\u4e0d\u5b8c\u6574\u7684<\/span><span lang=\"en-US\">,<\/span><span lang=\"zh-CN\">\u800c\u6355\u83b7\u7684\u65e5\u5fd7\u662f\u5b8c\u6574\u4e14\u53ef\u7528\u7684<\/span><span lang=\"en-US\">.<\/span><\/span><\/span><\/p>\n<p style=\"font-family: Arial; font-style: normal; font-variant: normal; margin: 0in; color: black; font-size: 9pt;\"><span style=\"font-family: 'courier new', courier;\"><span style=\"font-size: small;\"><span lang=\"zh-CN\">\u5982\u679c\u7ed3\u5c3e\u65e5\u5fd7\u5907\u4efd\u5305\u542b\u4e0d\u5b8c\u6574\u7684\u5143\u6570\u636e<\/span><span lang=\"en-US\">,<\/span><span lang=\"zh-CN\">\u5219<\/span><span lang=\"en-US\">\u00a0backupset\u00a0<\/span><span lang=\"zh-CN\">\u8868\u4e2d\u7684<\/span><span lang=\"zh-CN\">\u00a0<\/span><span lang=\"en-US\" style=\"font-weight: bold;\">has_incomplete_metadata<\/span><span lang=\"en-US\">\u00a0<\/span><span lang=\"zh-CN\">\u5c06\u8bbe\u7f6e\u4e3a<\/span><span lang=\"zh-CN\">\u00a0<\/span><span lang=\"en-US\" style=\"font-weight: bold;\">1<\/span><span lang=\"en-US\">.<\/span><span lang=\"zh-CN\">\u6b64\u5916<\/span><span lang=\"en-US\">,<\/span><span lang=\"zh-CN\">\u5728<\/span><span lang=\"en-US\">RESTORE HEADERONLY\u00a0<\/span><span lang=\"zh-CN\">\u7684\u8f93\u51fa\u4e2d<\/span><span lang=\"en-US\">,<\/span><span lang=\"en-US\" style=\"font-weight: bold;\">HasIncompleteMetadata<\/span><span lang=\"en-US\">\u00a0<\/span><span lang=\"zh-CN\">\u5c06\u8bbe\u7f6e\u4e3a<\/span><span lang=\"zh-CN\">\u00a0<\/span><span lang=\"en-US\" style=\"font-weight: bold;\">1<\/span><span lang=\"en-US\">.<\/span><\/span><\/span><\/p>\n<p style=\"font-family: Arial; font-style: normal; font-variant: normal; margin: 0in; color: black; font-size: 9pt;\"><span style=\"font-family: 'courier new', courier;\"><span style=\"font-size: small;\"><span lang=\"zh-CN\">\u5982\u679c\u7ed3\u5c3e\u65e5\u5fd7\u5907\u4efd\u4e2d\u7684\u5143\u6570\u636e\u4e0d\u5b8c\u6574<\/span><span lang=\"en-US\">,<\/span><span lang=\"zh-CN\">\u5219<\/span><span lang=\"en-US\">\u00a0backupfilegroup\u00a0<\/span><span lang=\"zh-CN\">\u8868\u5728\u7ed3\u5c3e\u65e5\u5fd7\u5907\u4efd\u65f6\u5c06\u4e22\u5931\u6587\u4ef6\u7ec4\u7684\u5927\u591a\u6570\u76f8\u5173\u4fe1\u606f<\/span><span lang=\"en-US\">.<\/span><span lang=\"zh-CN\">\u5927\u591a\u6570<\/span><span lang=\"zh-CN\">\u00a0<\/span><span lang=\"en-US\" style=\"font-weight: bold;\">backupfilegroup<\/span><span lang=\"en-US\">\u00a0<\/span><span lang=\"zh-CN\">\u8868\u5217\u4e3a<\/span><span lang=\"en-US\">\u00a0NULL;<\/span><span lang=\"zh-CN\">\u53ea\u6709\u4ee5\u4e0b\u51e0\u5217\u6709\u610f\u4e49<\/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 lang=\"en-US\" style=\"vertical-align: middle;\"><span style=\"font-family: 'courier new', courier;\"><span style=\"font-size: small;\"><span style=\"color: black; font-weight: bold;\">backup_set_id<\/span><\/span><\/span><\/li>\n<li lang=\"en-US\" style=\"vertical-align: middle;\"><span style=\"font-family: 'courier new', courier;\"><span style=\"font-size: small;\"><span style=\"color: black; font-weight: bold;\">filegroup_id<\/span><\/span><\/span><\/li>\n<\/ul>\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 lang=\"en-US\" style=\"vertical-align: middle;\"><span style=\"font-family: 'courier new', courier;\"><span style=\"font-size: small;\"><span style=\"color: black; font-weight: bold;\">type<\/span><\/span><\/span><\/li>\n<\/ul>\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 lang=\"en-US\" style=\"vertical-align: middle;\"><span style=\"font-family: 'courier new', courier;\"><span style=\"font-size: small;\"><span style=\"color: black; font-weight: bold;\">type_desc<\/span><\/span><\/span><\/li>\n<li lang=\"en-US\" style=\"vertical-align: middle;\"><span style=\"font-family: 'courier new', courier;\"><span style=\"font-size: small;\"><span style=\"color: black; font-weight: bold;\">is_readonly<\/span><\/span><\/span><\/li>\n<\/ul>\n<p style=\"font-style: normal; font-variant: normal; margin: 0in; font-family: \u5b8b\u4f53; color: black; font-size: 9pt;\"><span style=\"font-weight: bold;\"><span style=\"font-family: 'courier new', courier;\"><span style=\"font-size: small;\">\u4e0d\u4f7f\u7528\u7ed3\u5c3e\u65e5\u5fd7\u5907\u4efd\u6267\u884c\u8fd8\u539f<\/span><\/span><\/span><\/p>\n<p style=\"font-family: Arial; font-style: normal; font-variant: normal; margin: 0in; color: black; font-size: 9pt;\"><span style=\"font-family: 'courier new', courier;\"><span style=\"font-size: small;\"><span lang=\"zh-CN\">\u4e0d\u9700\u8981\u7ed3\u5c3e\u65e5\u5fd7\u5907\u4efd\u7684\u8fd8\u539f\u65b9\u6848\u5305\u62ec\u4ee5\u4e0b\u51e0\u79cd<\/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 lang=\"zh-CN\" style=\"color: black; font-size: 9pt;\"><span style=\"font-family: 'courier new', courier;\"><span style=\"font-size: small;\">\u5c06\u6570\u636e\u5e93\u8fd8\u539f\u5230\u5148\u524d\u65e5\u5fd7\u5907\u4efd\u4e2d\u5305\u542b\u7684\u67d0\u4e2a\u65f6\u95f4\u70b9<\/span><\/span><\/span><span style=\"font-family: 'courier new', courier;\"><span style=\"font-size: small;\"><span lang=\"en-US\" style=\"color: black;\">.<br \/>\n<\/span><span lang=\"zh-CN\" style=\"color: black;\">\u5982\u679c\u8fd8\u539f\u4e00\u4e2a\u6570\u636e\u5e93\u5e76\u5728\u8fd8\u539f\u987a\u5e8f\u4e2d\u7684\u6bcf\u4e2a<\/span><span lang=\"en-US\" style=\"color: black;\">\u00a0RESTORE\u00a0<\/span><span lang=\"zh-CN\" style=\"color: black;\">\u8bed\u53e5\u4e2d\u6307\u5b9a<\/span><span lang=\"en-US\" style=\"color: black;\">\u00a0STOPAT,STOPATMARK\u00a0<\/span><span lang=\"zh-CN\" style=\"color: black;\">\u6216<\/span><span lang=\"en-US\" style=\"color: black;\">STOPBEFOREMARK\u00a0<\/span><span lang=\"zh-CN\" style=\"color: black;\">\u9009\u9879<\/span><span lang=\"en-US\" style=\"color: black;\">,<\/span><span lang=\"zh-CN\" style=\"color: black;\">\u5219\u4e0d\u5fc5\u8fdb\u884c\u7ed3\u5c3e\u65e5\u5fd7\u5907\u4efd<\/span><span lang=\"en-US\" style=\"color: black;\">.<\/span><\/span><\/span><\/li>\n<\/ul>\n<p style=\"font-family: Arial; font-style: normal; font-variant: normal; margin: 0in; color: black; font-size: 9pt;\"><span style=\"font-family: 'courier new', courier;\"><span style=\"font-size: small;\"><span lang=\"zh-CN\" style=\"font-weight: bold;\">\u5c06\u6570\u636e\u5e93\u8fd8\u539f\u5230\u5148\u524d\u65f6\u95f4\u70b9<\/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\" style=\"color: black;\">\u82e5\u8981\u4f7f\u7528<\/span><span lang=\"en-US\" style=\"color: black;\">\u00a0Transact-SQL\u00a0<\/span><span lang=\"zh-CN\" style=\"color: black;\">\u8fd8\u539f\u5230\u7279\u5b9a\u65f6\u95f4\u70b9<\/span><span lang=\"en-US\" style=\"color: black;\">,<\/span><span lang=\"zh-CN\" style=\"color: black;\">\u8bf7\u53c2\u9605\u5982\u4f55\u8fd8\u539f\u5230\u67d0\u4e2a\u65f6\u95f4\u70b9<\/span><span lang=\"en-US\" style=\"color: black;\">\u00a0(Transact-SQL),<\/span><span lang=\"zh-CN\" style=\"color: black;\">\u6062\u590d\u5230\u6807\u8bb0\u7684\u4e8b\u52a1\u6216\u6062\u590d\u5230\u65e5\u5fd7\u5e8f\u5217\u53f7<\/span><span lang=\"en-US\" style=\"color: black;\">\u00a0(LSN).<\/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\" style=\"color: black;\">\u82e5\u8981\u4f7f\u7528<\/span><span lang=\"en-US\" style=\"color: black;\">\u00a0SQL Server Management Studio,<\/span><span lang=\"zh-CN\" style=\"color: black;\">\u8bf7\u53c2\u9605\u5982\u4f55\u8fd8\u539f\u5230\u67d0\u4e2a\u65f6\u70b9<\/span><span lang=\"en-US\" style=\"color: black;\">\u00a0(SQL Server Management Studio)<\/span><span lang=\"zh-CN\" style=\"color: black;\">\u6216\u5982\u4f55\u5c06\u6570\u636e\u5e93\u8fd8\u539f\u5230\u6807\u8bb0\u7684\u4e8b\u52a1<\/span><span lang=\"en-US\" style=\"color: black;\">\u00a0(SQL Server Management Studio).<\/span><\/span><\/span><\/li>\n<li style=\"vertical-align: middle;\"><span lang=\"zh-CN\" style=\"color: black; font-size: 9pt;\"><span style=\"font-family: 'courier new', courier;\"><span style=\"font-size: small;\">\u5c06\u6570\u636e\u5e93\u526f\u672c\u8fd8\u539f\u5230\u65b0\u4f4d\u7f6e<\/span><\/span><\/span><span style=\"font-family: 'courier new', courier;\"><span style=\"font-size: small;\"><span lang=\"en-US\" style=\"color: black;\">.<br \/>\n<\/span><span lang=\"zh-CN\" style=\"color: black;\">\u5f53\u60a8\u8fd8\u539f\u6570\u636e\u5e93\u65f6<\/span><span lang=\"en-US\" style=\"color: black;\">,<\/span><span lang=\"zh-CN\" style=\"color: black;\">\u53ea\u6709\u5c06\u6570\u636e\u5e93\u8fd8\u539f\u5230\u4e0d\u540c\u7684\u670d\u52a1\u5668\u5b9e\u4f8b\u65f6<\/span><span lang=\"en-US\" style=\"color: black;\">,<\/span><span lang=\"zh-CN\" style=\"color: black;\">\u624d\u53ef\u4ee5\u4f7f\u7528\u76f8\u540c\u7684\u6570\u636e\u5e93\u540d\u79f0<\/span><span lang=\"en-US\" style=\"color: black;\">,<\/span><span lang=\"zh-CN\" style=\"color: black;\">\u4f8b\u5982<\/span><span lang=\"en-US\" style=\"color: black;\">,<\/span><span lang=\"zh-CN\" style=\"color: black;\">\u521b\u5efa\u955c\u50cf\u6570\u636e\u5e93\u7528\u4e8e\u6570\u636e\u5e93\u955c\u50cf\u6216\u521b\u5efa\u8f85\u52a9\u6570\u636e\u5e93\u7528\u4e8e\u65e5\u5fd7\u4f20\u9001<\/span><span lang=\"en-US\" style=\"color: black;\">.<\/span><span lang=\"zh-CN\" style=\"color: black;\">\u5982\u679c\u5728\u540c\u4e00\u670d\u52a1\u5668\u5b9e\u4f8b\u4e0a\u79fb\u52a8\u6570\u636e\u5e93<\/span><span lang=\"en-US\" style=\"color: black;\">,<\/span><span lang=\"zh-CN\" style=\"color: black;\">\u60a8\u5fc5\u987b\u4e3a\u6570\u636e\u5e93\u6307\u5b9a\u65b0\u540d\u79f0<\/span><span lang=\"en-US\" style=\"color: black;\">.<\/span><\/span><\/span><\/li>\n<\/ul>\n<p style=\"font-family: Arial; font-style: normal; font-variant: normal; margin: 0in; color: black; font-size: 9pt;\"><span style=\"font-family: 'courier new', courier;\"><span style=\"font-size: small;\"><span lang=\"zh-CN\" style=\"font-weight: bold;\">\u5c06\u6570\u636e\u5e93\u8fd8\u539f\u5230\u65b0\u4f4d\u7f6e<\/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\" style=\"color: black;\">\u5728\u8fd8\u539f\u987a\u5e8f\u7684\u6bcf\u4e2a<\/span><span lang=\"en-US\" style=\"color: black;\">\u00a0RESTORE\u00a0<\/span><span lang=\"zh-CN\" style=\"color: black;\">\u8bed\u53e5\u4e2d<\/span><span lang=\"en-US\" style=\"color: black;\">,<\/span><span lang=\"zh-CN\" style=\"color: black;\">\u4f7f\u7528<\/span><span lang=\"en-US\" style=\"color: black;\">\u00a0Transact-SQL\u00a0<\/span><span lang=\"zh-CN\" style=\"color: black;\">\u6307\u5b9a<\/span><span lang=\"en-US\" style=\"color: black;\">\u00a0MOVE\u00a0<\/span><span lang=\"zh-CN\" style=\"color: black;\">\u9009\u9879<\/span><span lang=\"en-US\" style=\"color: black;\">.<\/span><\/span><\/span><\/li>\n<\/ul>\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\" style=\"color: black;\">\u4f7f\u7528<\/span><span lang=\"en-US\" style=\"color: black;\">\u00a0SQL Server Management Studio,<\/span><span lang=\"zh-CN\" style=\"color: black;\">\u5728<\/span><span lang=\"en-US\" style=\"color: black; font-weight: bold;\">&#8220;<\/span><span lang=\"zh-CN\" style=\"color: black; font-weight: bold;\">\u8fd8\u539f\u6570\u636e\u5e93<\/span><span lang=\"en-US\" style=\"color: black; font-weight: bold;\">&#8220;<\/span><span lang=\"en-US\" style=\"color: black;\">(<\/span><span lang=\"en-US\" style=\"color: black; font-weight: bold;\">&#8220;<\/span><span lang=\"zh-CN\" style=\"color: black; font-weight: bold;\">\u9009\u9879<\/span><span lang=\"en-US\" style=\"color: black; font-weight: bold;\">&#8220;<\/span><span lang=\"zh-CN\" style=\"color: black;\">\u9875<\/span><span lang=\"en-US\" style=\"color: black;\">)<\/span><span lang=\"zh-CN\" style=\"color: black;\">\u7684<\/span><span lang=\"en-US\" style=\"color: black; font-weight: bold;\">&#8220;<\/span><span lang=\"zh-CN\" style=\"color: black; font-weight: bold;\">\u8fd8\u539f\u4e3a<\/span><span lang=\"en-US\" style=\"color: black; font-weight: bold;\">&#8220;<\/span><span lang=\"zh-CN\" style=\"color: black;\">\u5b57\u6bb5\u4e2d\u6307\u5b9a\u6bcf\u4e2a\u6587\u4ef6\u7684\u65b0\u4f4d\u7f6e<\/span><span lang=\"en-US\" style=\"color: black;\">.<\/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\" style=\"color: black;\">\u5b8c\u6574\u66ff\u6362<\/span><span lang=\"en-US\" style=\"color: black;\">(<\/span><span lang=\"zh-CN\" style=\"color: black;\">\u8986\u76d6<\/span><span lang=\"en-US\" style=\"color: black;\">)<\/span><span lang=\"zh-CN\" style=\"color: black;\">\u6570\u636e\u5e93<\/span><span lang=\"en-US\" style=\"color: black;\">.<\/span><\/span><\/span><\/li>\n<\/ul>\n<p style=\"font-family: Arial; font-style: normal; font-variant: normal; margin: 0in 0in 0in 0.375in; color: black; 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\">\u5e94\u5f53\u5c3d\u91cf\u907f\u514d\u4f7f\u7528<\/span><span lang=\"en-US\">\u00a0REPLACE\u00a0<\/span><span lang=\"zh-CN\">\u9009\u9879\u6267\u884c\u8fd8\u539f<\/span><span lang=\"en-US\">,<\/span><span lang=\"zh-CN\">\u5e76\u4e14\u53ea\u6709\u7ecf\u9a8c\u4e30\u5bcc\u7684\u6570\u636e\u5e93\u7ba1\u7406\u5458\u5728\u614e\u91cd\u8003\u8651\u540e\u624d\u80fd\u8fd9\u6837\u505a<\/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=\"en-US\" style=\"color: black;\">PLACE\u00a0<\/span><span lang=\"zh-CN\" style=\"color: black;\">\u9009\u9879<\/span><span lang=\"en-US\" style=\"color: black;\">.<\/span><\/span><\/span><\/li>\n<\/ul>\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\" style=\"color: black;\">\u4f7f\u7528<\/span><span lang=\"en-US\" style=\"color: black;\">\u00a0SQL Server Management Studio,<\/span><span lang=\"zh-CN\" style=\"color: black;\">\u5728<\/span><span lang=\"en-US\" style=\"color: black; font-weight: bold;\">&#8220;<\/span><span lang=\"zh-CN\" style=\"color: black; font-weight: bold;\">\u8fd8\u539f\u6570\u636e\u5e93<\/span><span lang=\"en-US\" style=\"color: black; font-weight: bold;\">&#8220;<\/span><span lang=\"en-US\" style=\"color: black;\">(<\/span><span lang=\"en-US\" style=\"color: black; font-weight: bold;\">&#8220;<\/span><span lang=\"zh-CN\" style=\"color: black; font-weight: bold;\">\u9009\u9879<\/span><span lang=\"en-US\" style=\"color: black; font-weight: bold;\">&#8220;<\/span><span lang=\"zh-CN\" style=\"color: black;\">\u9875<\/span><span lang=\"en-US\" style=\"color: black;\">)<\/span><span lang=\"zh-CN\" style=\"color: black;\">\u7684<\/span><span lang=\"en-US\" style=\"color: black; font-weight: bold;\">&#8220;<\/span><span lang=\"zh-CN\" style=\"color: black; font-weight: bold;\">\u8fd8\u539f\u4e3a<\/span><span lang=\"en-US\" style=\"color: black; font-weight: bold;\">&#8220;<\/span><span lang=\"zh-CN\" style=\"color: black;\">\u5b57\u6bb5\u4e2d\u6307\u5b9a\u6bcf\u4e2a\u6587\u4ef6\u7684\u65b0\u4f4d\u7f6e<\/span><span lang=\"en-US\" style=\"color: black;\">.<\/span><\/span><\/span><\/li>\n<\/ul>\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=\"en-US\" style=\"color: black; font-weight: bold;\">&#8220;<\/span><span lang=\"zh-CN\" style=\"color: black; font-weight: bold;\">\u8fd8\u539f\u6570\u636e\u5e93<\/span><span lang=\"en-US\" style=\"color: black; font-weight: bold;\">&#8220;<\/span><span lang=\"en-US\" style=\"color: black;\">(<\/span><span lang=\"en-US\" style=\"color: black; font-weight: bold;\">&#8220;<\/span><span lang=\"zh-CN\" style=\"color: black; font-weight: bold;\">\u9009\u9879<\/span><span lang=\"en-US\" style=\"color: black; font-weight: bold;\">&#8220;<\/span><span lang=\"zh-CN\" style=\"color: black;\">\u9875<\/span><span lang=\"en-US\" style=\"color: black;\">)<\/span><span lang=\"zh-CN\" style=\"color: black;\">\u7684<\/span><span lang=\"en-US\" style=\"color: black; font-weight: bold;\">&#8220;<\/span><span lang=\"zh-CN\" style=\"color: black; font-weight: bold;\">\u8fd8\u539f\u4e3a<\/span><span lang=\"en-US\" style=\"color: black; font-weight: bold;\">&#8220;<\/span><span lang=\"zh-CN\" style=\"color: black;\">\u5b57\u6bb5\u4e2d\u6307\u5b9a\u6bcf\u4e2a\u6587\u4ef6\u7684\u65b0\u4f4d\u7f6e<\/span><span lang=\"en-US\" style=\"color: black;\">.<\/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\" style=\"color: black;\">\u5b8c\u6574\u66ff\u6362<\/span><span lang=\"en-US\" style=\"color: black;\">(<\/span><span lang=\"zh-CN\" style=\"color: black;\">\u8986\u76d6<\/span><span lang=\"en-US\" style=\"color: black;\">)<\/span><span lang=\"zh-CN\" style=\"color: black;\">\u6570\u636e\u5e93<\/span><span lang=\"en-US\" style=\"color: black;\">.<\/span><\/span><\/span><\/li>\n<\/ul>\n<p style=\"font-family: Arial; font-style: normal; font-variant: normal; margin: 0in 0in 0in 0.375in; color: black; 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\">\u5e94\u5f53\u5c3d\u91cf\u907f\u514d\u4f7f\u7528<\/span><span lang=\"en-US\">\u00a0REPLACE\u00a0<\/span><span lang=\"zh-CN\">\u9009\u9879\u6267\u884c\u8fd8\u539f<\/span><span lang=\"en-US\">,<\/span><span lang=\"zh-CN\">\u5e76\u4e14\u53ea\u6709\u7ecf\u9a8c\u4e30\u5bcc\u7684\u6570\u636e\u5e93\u7ba1\u7406\u5458\u5728\u614e\u91cd\u8003\u8651\u540e\u624d\u80fd\u8fd9\u6837\u505a<\/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=\"en-US\" style=\"color: black;\">PLACE\u00a0<\/span><span lang=\"zh-CN\" style=\"color: black;\">\u9009\u9879<\/span><span lang=\"en-US\" style=\"color: black;\">.<\/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\" style=\"color: black;\">\u4f7f\u7528<\/span><span lang=\"en-US\" style=\"color: black;\">\u00a0SQL Server Management Studio,<\/span><span lang=\"zh-CN\" style=\"color: black;\">\u5728<\/span><span lang=\"en-US\" style=\"color: black; font-weight: bold;\">&#8220;<\/span><span lang=\"zh-CN\" style=\"color: black; font-weight: bold;\">\u8fd8\u539f\u6570\u636e\u5e93<\/span><span lang=\"en-US\" style=\"color: black; font-weight: bold;\">&#8220;<\/span><span lang=\"en-US\" style=\"color: black;\">(<\/span><span lang=\"en-US\" style=\"color: black; font-weight: bold;\">&#8220;<\/span><span lang=\"zh-CN\" style=\"color: black; font-weight: bold;\">\u9009\u9879<\/span><span lang=\"en-US\" style=\"color: black; font-weight: bold;\">&#8220;<\/span><span lang=\"zh-CN\" style=\"color: black;\">\u9875<\/span><span lang=\"en-US\" style=\"color: black;\">)<\/span><span lang=\"zh-CN\" style=\"color: black;\">\u7684<\/span><span lang=\"en-US\" style=\"color: black; font-weight: bold;\">&#8220;<\/span><span lang=\"zh-CN\" style=\"color: black; font-weight: bold;\">\u8fd8\u539f\u4e3a<\/span><span lang=\"en-US\" style=\"color: black; font-weight: bold;\">&#8220;<\/span><span lang=\"zh-CN\" style=\"color: black;\">\u5b57\u6bb5\u4e2d\u6307\u5b9a\u6bcf\u4e2a\u6587\u4ef6\u7684\u65b0\u4f4d\u7f6e<\/span><span lang=\"en-US\" style=\"color: black;\">.<\/span><\/span><\/span><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>\u5bf9\u4e8e\u5927\u591a\u6570\u60c5\u51b5,\u5728\u5b8c\u6574\u6062\u590d\u6a21\u5f0f\u6216\u5927\u5bb9\u91cf\u65e5\u5fd7\u6062\u590d\u6a21\u5f0f\u4e0b,SQL Server 2005\u00a0\u53ca\u66f4\u9ad8\u7248\u672c\u8981\u6c42\u60a8\u5907\u4efd\u65e5\u5fd7 [&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-195","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\/195","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=195"}],"version-history":[{"count":0,"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=\/wp\/v2\/posts\/195\/revisions"}],"wp:attachment":[{"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=195"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=195"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=195"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}