{"id":2,"date":"2010-12-14T10:10:00","date_gmt":"2010-12-14T02:10:00","guid":{"rendered":"http:\/\/localhost\/?p=2"},"modified":"2013-12-30T10:39:45","modified_gmt":"2013-12-30T02:39:45","slug":"database_mirroring","status":"publish","type":"post","link":"http:\/\/www.royalwzy.com\/?p=2","title":{"rendered":"Database Mirroring"},"content":{"rendered":"<p><span style=\"FONT-FAMILY: SimSun\" lang=\"zh-CN\">\u8bd5\u9a8c\u76ee\u6807<\/span><span style=\"FONT-FAMILY: 'Courier New'\" lang=\"en-US\">:<\/span><span style=\"FONT-FAMILY: SimSun\" lang=\"zh-CN\">\u521b\u5efa<\/span><span style=\"FONT-FAMILY: 'Courier New'\" lang=\"en-US\">Database Mirroring<\/span><\/p>\n<p style=\"MARGIN: 0in; FONT-SIZE: 9pt\"><span style=\"FONT-FAMILY: SimSun\" lang=\"zh-CN\">\u51c6\u5907\u5de5\u4f5c<\/span><span style=\"FONT-FAMILY: 'Courier New'\" lang=\"en-US\">:<\/span><\/p>\n<p style=\"MARGIN: 0in 0in 0in 0.375in; FONT-SIZE: 9pt\"><span style=\"FONT-FAMILY: 'Courier New'\" lang=\"en-US\">1.<\/span><span style=\"FONT-FAMILY: SimSun\" lang=\"zh-CN\">\u51c6\u5907<\/span><span style=\"FONT-FAMILY: 'Courier New'\" lang=\"en-US\">3<\/span><span style=\"FONT-FAMILY: SimSun\" lang=\"zh-CN\">\u53f0\u6570\u636e\u5e93\u5b9e\u4f8b<\/span><\/p>\n<ul style=\"MARGIN-TOP: 0in; unicode-bidi: embed; DIRECTION: ltr; MARGIN-BOTTOM: 0in; MARGIN-LEFT: 0.75in\" type=\"disc\">\n<li style=\"MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px; VERTICAL-ALIGN: middle\"><span style=\"FONT-FAMILY: 'Courier New'; FONT-SIZE: 9pt\" lang=\"en-US\">WIN-9JFNLS74727<\/span><span style=\"FONT-FAMILY: SimSun; FONT-SIZE: 9pt\" lang=\"zh-CN\">\u4e3a\u4e3b\u670d\u52a1\u5668<\/span><\/li>\n<\/ul>\n<ul style=\"MARGIN-TOP: 0in; unicode-bidi: embed; DIRECTION: ltr; MARGIN-BOTTOM: 0in; MARGIN-LEFT: 0.75in\" type=\"disc\">\n<li style=\"MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px; VERTICAL-ALIGN: middle\"><span style=\"FONT-FAMILY: 'Courier New'; FONT-SIZE: 9pt\" lang=\"en-US\">WIN-9JFNLS74727\/SQLSERVER_R2_S01<\/span><span style=\"FONT-FAMILY: SimSun; FONT-SIZE: 9pt\" lang=\"zh-CN\">\u4e3a\u955c\u50cf\u670d\u52a1\u5668<\/span><\/li>\n<\/ul>\n<ul style=\"MARGIN-TOP: 0in; unicode-bidi: embed; DIRECTION: ltr; MARGIN-BOTTOM: 0in; MARGIN-LEFT: 0.75in\" type=\"disc\">\n<li style=\"MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px; VERTICAL-ALIGN: middle\"><span style=\"FONT-FAMILY: 'Courier New'; FONT-SIZE: 9pt\" lang=\"en-US\">WIN-9JFNLS74727\/SQLSERVER_R2_S02<\/span><span style=\"FONT-FAMILY: SimSun; FONT-SIZE: 9pt\" lang=\"zh-CN\">\u4e3a\u89c1\u8bc1\u670d\u52a1\u5668<\/span><\/li>\n<\/ul>\n<p style=\"MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px; VERTICAL-ALIGN: middle\"><span style=\"FONT-FAMILY: SimSun; FONT-SIZE: 9pt\" lang=\"zh-CN\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <img decoding=\"async\" src=\"http:\/\/localhost\/wp-content\/uploads\/pic\/0_1292291706qt8a.gif\" alt=\"\" \/><\/span><\/p>\n<p style=\"MARGIN: 0in 0in 0in 0.375in; FONT-SIZE: 9pt\"><span style=\"FONT-FAMILY: 'Courier New'\" lang=\"en-US\">2.<\/span><span style=\"FONT-FAMILY: SimSun\" lang=\"zh-CN\">\u5728\u4e3b\u670d\u52a1\u5668\u4e0a\u521b\u5efa<\/span><span style=\"FONT-FAMILY: 'Courier New'\" lang=\"en-US\">DB_Mirror<\/span><span style=\"FONT-FAMILY: SimSun\" lang=\"zh-CN\">\u793a\u4f8b\u6570\u636e\u5e93<\/span><span style=\"FONT-FAMILY: 'Courier New'\" lang=\"en-US\">,<\/span><span style=\"FONT-FAMILY: SimSun\" lang=\"zh-CN\">\u5e76\u8bbe\u7f6e<\/span><span style=\"FONT-FAMILY: 'Courier New'\" lang=\"zh-CN\">\u793a\u4f8b\u6570\u636e\u5e93\u7684RECOVERY MODEL\u4e3aFULL<\/span><\/p>\n<p style=\"MARGIN: 0in 0in 0in 0.75in; FONT-FAMILY: 'Courier New'; FONT-SIZE: 9pt\"><textarea cols=\"50\" rows=\"15\" name=\"code\" class=\"c-sharp\">USE master<br \/>\nGO<br \/>\n&#8212; \u521b\u5efaDB_Mirror\u793a\u4f8b\u6570\u636e\u5e93<br \/>\nCREATE DATABASE DB_Mirror<br \/>\nGO<br \/>\n&#8212; \u8bbe\u7f6e\u793a\u4f8b\u6570\u636e\u5e93\u7684RECOVERY MODEL\u4e3aFULL<br \/>\nALTER DATABASE DB_Mirror SET RECOVERY FULL<br \/>\nGO<\/textarea> <\/p>\n<p style=\"MARGIN: 0in 0in 0in 0.375in; FONT-FAMILY: 'Courier New'; FONT-SIZE: 9pt\"><span lang=\"en-US\">3.<\/span><span lang=\"zh-CN\">\u5907\u4efd\u4e3b\u670d\u52a1\u5668\u4e0a\u7684DB_Mirror\u793a\u4f8b\u6570\u636e\u5e93<\/span><\/p>\n<p style=\"MARGIN: 0in 0in 0in 0.75in; FONT-FAMILY: 'Courier New'; FONT-SIZE: 9pt\"><textarea cols=\"50\" rows=\"15\" name=\"code\" class=\"c-sharp\">&#8212; \u5907\u4efd\u4e3b\u670d\u52a1\u5668\u4e0a\u7684DB_Mirror\u793a\u4f8b\u6570\u636e\u5e93<br \/>\nBACKUP DATABASE DB_Mirror<br \/>\nTO DISK = N&#8217;C:\/DB_Mirror.bak&#8217;<br \/>\nWITH INIT<br \/>\nGO<\/textarea>&nbsp;&nbsp;<\/p>\n<p style=\"MARGIN: 0in 0in 0in 0.375in; FONT-FAMILY: 'Courier New'; FONT-SIZE: 9pt\"><span lang=\"en-US\">4.<\/span><span lang=\"zh-CN\">\u5c06DB_Mirror\u793a\u4f8b\u6570\u636e\u5e93\u7684\u5907\u4efd\u6587\u4ef6\u4ee5WITH NORECOVERY\u6a21\u5f0f\u8fd8\u539f\u81f3\u955c\u50cf\u670d\u52a1\u5668,\u4ee5\u627f\u63a5\u540e\u7eed\u7684\u4e8b\u52a1\u6570\u636e<\/span><\/p>\n<p style=\"MARGIN: 0in 0in 0in 0.75in\"><textarea cols=\"50\" rows=\"15\" name=\"code\" class=\"c-sharp\">&#8212; \u5c06DB_Mirror\u793a\u4f8b\u6570\u636e\u5e93\u7684\u5907\u4efd\u6587\u4ef6\u4ee5WITH NORECOVERY\u6a21\u5f0f\u8fd8\u539f\u81f3\u955c\u50cf\u670d\u52a1\u5668,\u4ee5\u627f\u63a5\u540e\u7eed\u7684\u4e8b\u52a1\u6570\u636e<br \/>\nRESTORE DATABASE DB_Mirror<br \/>\nFROM DISK = N&#8217;C:\/DB_Mirror.bak&#8217;<br \/>\nWITH REPLACE, NORECOVERY,<br \/>\nMOVE N&#8217;DB_Mirror&#8217; TO N&#8217;C:\/Program Files\/Microsoft SQL Server\/MSSQL10_50.SQLSERVER_R2_S01\/MSSQL\/DATA\/DB_Mirror.mdf&#8217;,<br \/>\nMOVE N&#8217;DB_Mirror_Log&#8217; TO N&#8217;C:\/Program Files\/Microsoft SQL Server\/MSSQL10_50.SQLSERVER_R2_S01\/MSSQL\/DATA\/DB_Mirror_Log.ldf&#8217;<br \/>\nGO<\/textarea> <img decoding=\"async\" src=\"http:\/\/localhost\/wp-content\/uploads\/pic\/0_1292291716A6h5.gif\" alt=\"\" \/><\/p>\n<p style=\"MARGIN: 0in; FONT-FAMILY: SimSun; FONT-SIZE: 9pt\">&nbsp;<\/p>\n<p style=\"MARGIN: 0in; FONT-FAMILY: SimSun; FONT-SIZE: 9pt\"><span style=\"FONT-WEIGHT: bold\">\u5b9e\u9a8c\u6b65\u9aa4<\/span><\/p>\n<p style=\"MARGIN: 0in 0in 0in 0.375in; FONT-SIZE: 9pt\"><span style=\"FONT-FAMILY: 'Courier New'\" lang=\"en-US\">1.<\/span><span style=\"FONT-FAMILY: SimSun\" lang=\"zh-CN\">\u521b\u5efa\u7aef\u70b9<\/span><span style=\"FONT-FAMILY: 'Courier New'\" lang=\"en-US\">:<\/span><\/p>\n<ul style=\"MARGIN-TOP: 0in; unicode-bidi: embed; DIRECTION: ltr; MARGIN-BOTTOM: 0in; MARGIN-LEFT: 0.75in\" type=\"disc\">\n<li style=\"MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px; VERTICAL-ALIGN: middle\"><span style=\"FONT-FAMILY: SimSun; FONT-SIZE: 9pt\" lang=\"zh-CN\">\u5728<\/span><span style=\"FONT-FAMILY: 'Courier New'; FONT-SIZE: 9pt\" lang=\"en-US\">SQL Server Management Studio<\/span><span style=\"FONT-FAMILY: SimSun; FONT-SIZE: 9pt\" lang=\"zh-CN\">\u4e3b\u670d\u52a1\u5668\u7684<\/span><span style=\"FONT-FAMILY: 'Courier New'; FONT-SIZE: 9pt\" lang=\"zh-CN\">DB_Mirror<\/span><span style=\"FONT-FAMILY: SimSun; FONT-SIZE: 9pt\" lang=\"zh-CN\">\u6570\u636e\u5e93\u4e2d<\/span><span style=\"FONT-FAMILY: 'Courier New'; FONT-SIZE: 9pt\" lang=\"en-US\">,<\/span><span style=\"FONT-FAMILY: SimSun; FONT-SIZE: 9pt\" lang=\"zh-CN\">\u5355\u51fb\u53f3\u952e\u9009\u62e9<\/span><span style=\"FONT-FAMILY: 'Courier New'; FONT-SIZE: 9pt\" lang=\"en-US\">&#8220;<\/span><span style=\"FONT-FAMILY: SimSun; FONT-SIZE: 9pt\" lang=\"zh-CN\">\u5c5e\u6027<\/span><span style=\"FONT-FAMILY: 'Courier New'; FONT-SIZE: 9pt\" lang=\"en-US\">&#8220;<\/span><span style=\"FONT-FAMILY: SimSun; FONT-SIZE: 9pt\" lang=\"zh-CN\">\u9009\u9879<\/span><span style=\"FONT-FAMILY: 'Courier New'; FONT-SIZE: 9pt\" lang=\"en-US\">,<\/span><span style=\"FONT-FAMILY: SimSun; FONT-SIZE: 9pt\" lang=\"zh-CN\">\u7136\u540e\u5728<\/span><span style=\"FONT-FAMILY: 'Courier New'; FONT-SIZE: 9pt\" lang=\"en-US\">&#8220;<\/span><span style=\"FONT-FAMILY: SimSun; FONT-SIZE: 9pt\" lang=\"zh-CN\">\u6570\u636e\u5e93\u5c5e\u6027<\/span><span style=\"FONT-FAMILY: 'Courier New'; FONT-SIZE: 9pt\" lang=\"en-US\">&#8220;<\/span><span style=\"FONT-FAMILY: SimSun; FONT-SIZE: 9pt\" lang=\"zh-CN\">\u5bf9\u8bdd\u6846\u4e2d\u9009\u62e9<\/span><span style=\"FONT-FAMILY: 'Courier New'; FONT-SIZE: 9pt\" lang=\"en-US\">&#8220;<\/span><span style=\"FONT-FAMILY: SimSun; FONT-SIZE: 9pt\" lang=\"zh-CN\">\u955c\u50cf<\/span><span style=\"FONT-FAMILY: 'Courier New'; FONT-SIZE: 9pt\" lang=\"en-US\">&#8220;<\/span><span style=\"FONT-FAMILY: SimSun; FONT-SIZE: 9pt\" lang=\"zh-CN\">\u9875\u7b7e<\/span><span style=\"FONT-FAMILY: 'Courier New'; FONT-SIZE: 9pt\" lang=\"en-US\">,<\/span><span style=\"FONT-FAMILY: SimSun; FONT-SIZE: 9pt\" lang=\"zh-CN\">\u5982\u56fe<\/span><span style=\"FONT-FAMILY: 'Courier New'; FONT-SIZE: 9pt\" lang=\"en-US\">:<\/span><\/li>\n<\/ul>\n<p style=\"MARGIN: 0in 0in 0in 0.75in\"><img decoding=\"async\" src=\"http:\/\/localhost\/wp-content\/uploads\/pic\/0_129229172398E1.gif\" alt=\"\" \/><\/p>\n<ul style=\"MARGIN-TOP: 0in; unicode-bidi: embed; DIRECTION: ltr; MARGIN-BOTTOM: 0in; MARGIN-LEFT: 0.75in\" type=\"disc\">\n<li style=\"MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px; VERTICAL-ALIGN: middle\"><span style=\"FONT-FAMILY: SimSun; FONT-SIZE: 9pt\" lang=\"zh-CN\">\u5728\u5355\u51fb<\/span><span style=\"FONT-FAMILY: 'Courier New'; FONT-SIZE: 9pt\" lang=\"en-US\">&#8220;<\/span><span style=\"FONT-FAMILY: SimSun; FONT-SIZE: 9pt\" lang=\"zh-CN\">\u914d\u7f6e\u5b89\u5168\u6027<\/span><span style=\"FONT-FAMILY: 'Courier New'; FONT-SIZE: 9pt\" lang=\"en-US\">&#8220;<\/span><span style=\"FONT-FAMILY: SimSun; FONT-SIZE: 9pt\" lang=\"zh-CN\">\u6309\u94ae<\/span><span style=\"FONT-FAMILY: 'Courier New'; FONT-SIZE: 9pt\" lang=\"en-US\">,<\/span><span style=\"FONT-FAMILY: SimSun; FONT-SIZE: 9pt\" lang=\"zh-CN\">\u5f39\u51fa<\/span><span style=\"FONT-FAMILY: 'Courier New'; FONT-SIZE: 9pt\" lang=\"en-US\">&#8220;<\/span><span style=\"FONT-FAMILY: SimSun; FONT-SIZE: 9pt\" lang=\"zh-CN\">\u8bbe\u7f6e\u6570\u636e\u5e93\u955c\u50cf\u5b89\u5168\u5411\u5bfc<\/span><span style=\"FONT-FAMILY: 'Courier New'; FONT-SIZE: 9pt\" lang=\"en-US\">&#8220;<\/span><span style=\"FONT-FAMILY: SimSun; FONT-SIZE: 9pt\" lang=\"zh-CN\">\u5bf9\u8bdd\u6846<\/span><span style=\"FONT-FAMILY: 'Courier New'; FONT-SIZE: 9pt\" lang=\"en-US\">,<\/span><span style=\"FONT-FAMILY: SimSun; FONT-SIZE: 9pt\" lang=\"zh-CN\">\u5728<\/span><span style=\"FONT-FAMILY: 'Courier New'; FONT-SIZE: 9pt\" lang=\"en-US\">&#8220;<\/span><span style=\"FONT-FAMILY: SimSun; FONT-SIZE: 9pt\" lang=\"zh-CN\">\u5305\u62ec\u89c1\u8bc1\u670d\u52a1\u5668<\/span><span style=\"FONT-FAMILY: 'Courier New'; FONT-SIZE: 9pt\" lang=\"en-US\">&#8220;<\/span><span style=\"FONT-FAMILY: SimSun; FONT-SIZE: 9pt\" lang=\"zh-CN\">\u7a97\u53e3\u4e2d\u9009\u62e9<\/span><span style=\"FONT-FAMILY: 'Courier New'; FONT-SIZE: 9pt\" lang=\"en-US\">&#8220;<\/span><span style=\"FONT-FAMILY: SimSun; FONT-SIZE: 9pt\" lang=\"zh-CN\">\u662f<\/span><span style=\"FONT-FAMILY: 'Courier New'; FONT-SIZE: 9pt\" lang=\"en-US\">&#8220;<\/span><span style=\"FONT-FAMILY: SimSun; FONT-SIZE: 9pt\" lang=\"zh-CN\">\u5982\u56fe\u6240\u793a<\/span><span style=\"FONT-FAMILY: 'Courier New'; FONT-SIZE: 9pt\" lang=\"en-US\">:<\/span><\/li>\n<\/ul>\n<p style=\"MARGIN: 0in 0in 0in 0.75in\"><img decoding=\"async\" src=\"http:\/\/localhost\/wp-content\/uploads\/pic\/0_1292291730E6nr.gif\" alt=\"\" \/><\/p>\n<ul style=\"MARGIN-TOP: 0in; unicode-bidi: embed; DIRECTION: ltr; MARGIN-BOTTOM: 0in; MARGIN-LEFT: 0.75in\" type=\"disc\">\n<li style=\"MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px; VERTICAL-ALIGN: middle\"><span style=\"FONT-FAMILY: SimSun; FONT-SIZE: 9pt\" lang=\"zh-CN\">\u5206\u522b\u8bbe\u7f6e\u4e3b\u4f53<\/span><span style=\"FONT-FAMILY: 'Courier New'; FONT-SIZE: 9pt\" lang=\"en-US\">,<\/span><span style=\"FONT-FAMILY: SimSun; FONT-SIZE: 9pt\" lang=\"zh-CN\">\u955c\u50cf\u548c\u89c1\u8bc1\u670d\u52a1\u5668<\/span><span style=\"FONT-FAMILY: 'Courier New'; FONT-SIZE: 9pt\" lang=\"en-US\">,<\/span><span style=\"FONT-FAMILY: SimSun; FONT-SIZE: 9pt\" lang=\"zh-CN\">\u9996\u5148\u662f\u4e3b\u4f53\u670d\u52a1\u5668\u7684<\/span><span style=\"FONT-FAMILY: 'Courier New'; FONT-SIZE: 9pt\" lang=\"en-US\">&#8220;<\/span><span style=\"FONT-FAMILY: SimSun; FONT-SIZE: 9pt\" lang=\"zh-CN\">\u7aef\u70b9\u540d\u79f0<\/span><span style=\"FONT-FAMILY: 'Courier New'; FONT-SIZE: 9pt\" lang=\"en-US\">&#8220;<\/span><span style=\"FONT-FAMILY: SimSun; FONT-SIZE: 9pt\" lang=\"zh-CN\">\u4e0e<\/span><span style=\"FONT-FAMILY: 'Courier New'; FONT-SIZE: 9pt\" lang=\"en-US\">&#8220;<\/span><span style=\"FONT-FAMILY: SimSun; FONT-SIZE: 9pt\" lang=\"zh-CN\">\u4fa6\u542c\u5668\u7aef\u53e3<\/span><span style=\"FONT-FAMILY: 'Courier New'; FONT-SIZE: 9pt\" lang=\"en-US\">(<\/span><span style=\"FONT-FAMILY: SimSun; FONT-SIZE: 9pt\" lang=\"zh-CN\">\u9ed8\u8ba4<\/span><span style=\"FONT-FAMILY: 'Courier New'; FONT-SIZE: 9pt\" lang=\"en-US\">5022)&#8221;,<\/span><span style=\"FONT-FAMILY: SimSun; FONT-SIZE: 9pt\" lang=\"zh-CN\">\u5982\u56fe<\/span><span style=\"FONT-FAMILY: 'Courier New'; FONT-SIZE: 9pt\" lang=\"en-US\">:<\/span><\/li>\n<\/ul>\n<p style=\"MARGIN: 0in 0in 0in 0.75in\"><img decoding=\"async\" src=\"http:\/\/localhost\/wp-content\/uploads\/pic\/0_1292291738iADX.gif\" alt=\"\" \/><\/p>\n<ul style=\"MARGIN-TOP: 0in; unicode-bidi: embed; DIRECTION: ltr; MARGIN-BOTTOM: 0in; MARGIN-LEFT: 0.75in\" type=\"disc\">\n<li style=\"MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px; VERTICAL-ALIGN: middle\"><span style=\"FONT-FAMILY: SimSun; FONT-SIZE: 9pt\" lang=\"zh-CN\">\u8bbe\u7f6e\u955c\u50cf\u670d\u52a1\u5668\u7684<\/span><span style=\"FONT-FAMILY: 'Courier New'; FONT-SIZE: 9pt\" lang=\"en-US\">&#8220;<\/span><span style=\"FONT-FAMILY: SimSun; FONT-SIZE: 9pt\" lang=\"zh-CN\">\u7aef\u70b9\u540d\u79f0<\/span><span style=\"FONT-FAMILY: 'Courier New'; FONT-SIZE: 9pt\" lang=\"en-US\">&#8220;<\/span><span style=\"FONT-FAMILY: SimSun; FONT-SIZE: 9pt\" lang=\"zh-CN\">\u4e0e<\/span><span style=\"FONT-FAMILY: 'Courier New'; FONT-SIZE: 9pt\" lang=\"en-US\">&#8220;<\/span><span style=\"FONT-FAMILY: SimSun; FONT-SIZE: 9pt\" lang=\"zh-CN\">\u4fa6\u542c\u5668\u7aef\u53e3<\/span><span style=\"FONT-FAMILY: 'Courier New'; FONT-SIZE: 9pt\" lang=\"en-US\">(<\/span><span style=\"FONT-FAMILY: SimSun; FONT-SIZE: 9pt\" lang=\"zh-CN\">\u9ed8\u8ba4<\/span><span style=\"FONT-FAMILY: 'Courier New'; FONT-SIZE: 9pt\" lang=\"en-US\">5023)&#8221;,<\/span><span style=\"FONT-FAMILY: SimSun; FONT-SIZE: 9pt\" lang=\"zh-CN\">\u5982\u56fe<\/span><span style=\"FONT-FAMILY: 'Courier New'; FONT-SIZE: 9pt\" lang=\"en-US\">:<\/span><\/li>\n<\/ul>\n<p style=\"MARGIN: 0in 0in 0in 0.75in\"><img decoding=\"async\" src=\"http:\/\/localhost\/wp-content\/uploads\/pic\/0_1292291747bUcu.gif\" alt=\"\" \/><\/p>\n<ul style=\"MARGIN-TOP: 0in; unicode-bidi: embed; DIRECTION: ltr; MARGIN-BOTTOM: 0in; MARGIN-LEFT: 0.75in\" type=\"disc\">\n<li style=\"MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px; VERTICAL-ALIGN: middle\"><span style=\"FONT-FAMILY: SimSun; FONT-SIZE: 9pt\" lang=\"zh-CN\">\u8bbe\u7f6e\u89c1\u8bc1\u670d\u52a1\u5668\u7684<\/span><span style=\"FONT-FAMILY: 'Courier New'; FONT-SIZE: 9pt\" lang=\"en-US\">&#8220;<\/span><span style=\"FONT-FAMILY: SimSun; FONT-SIZE: 9pt\" lang=\"zh-CN\">\u7aef\u70b9\u540d\u79f0<\/span><span style=\"FONT-FAMILY: 'Courier New'; FONT-SIZE: 9pt\" lang=\"en-US\">&#8220;<\/span><span style=\"FONT-FAMILY: SimSun; FONT-SIZE: 9pt\" lang=\"zh-CN\">\u4e0e<\/span><span style=\"FONT-FAMILY: 'Courier New'; FONT-SIZE: 9pt\" lang=\"en-US\">&#8220;<\/span><span style=\"FONT-FAMILY: SimSun; FONT-SIZE: 9pt\" lang=\"zh-CN\">\u4fa6\u542c\u5668\u7aef\u53e3<\/span><span style=\"FONT-FAMILY: 'Courier New'; FONT-SIZE: 9pt\" lang=\"en-US\">(<\/span><span style=\"FONT-FAMILY: SimSun; FONT-SIZE: 9pt\" lang=\"zh-CN\">\u9ed8\u8ba4<\/span><span style=\"FONT-FAMILY: 'Courier New'; FONT-SIZE: 9pt\" lang=\"en-US\">5024)&#8221;,<\/span><span style=\"FONT-FAMILY: SimSun; FONT-SIZE: 9pt\" lang=\"zh-CN\">\u5982\u56fe<\/span><span style=\"FONT-FAMILY: 'Courier New'; FONT-SIZE: 9pt\" lang=\"en-US\">:<\/span><\/li>\n<\/ul>\n<p style=\"MARGIN: 0in 0in 0in 0.75in\"><img decoding=\"async\" src=\"http:\/\/localhost\/wp-content\/uploads\/pic\/0_1292291753D4c1.gif\" alt=\"\" \/><\/p>\n<ul style=\"MARGIN-TOP: 0in; unicode-bidi: embed; DIRECTION: ltr; MARGIN-BOTTOM: 0in; MARGIN-LEFT: 0.75in\" type=\"disc\">\n<li style=\"MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px; VERTICAL-ALIGN: middle\"><span style=\"FONT-FAMILY: SimSun; FONT-SIZE: 9pt\">\u663e\u793a\u914d\u7f6e\u4fe1\u606f<\/span><\/li>\n<\/ul>\n<p style=\"MARGIN: 0in 0in 0in 0.75in\"><img decoding=\"async\" src=\"http:\/\/localhost\/wp-content\/uploads\/pic\/0_1292291761ROsq.gif\" alt=\"\" \/><\/p>\n<ul style=\"MARGIN-TOP: 0in; unicode-bidi: embed; DIRECTION: ltr; MARGIN-BOTTOM: 0in; MARGIN-LEFT: 0.75in\" type=\"disc\">\n<li style=\"MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px; VERTICAL-ALIGN: middle\"><span style=\"FONT-FAMILY: SimSun; FONT-SIZE: 9pt\">\u663e\u793a\u914d\u7f6e\u6210\u529f<\/span><\/li>\n<\/ul>\n<p style=\"MARGIN: 0in 0in 0in 0.75in\"><img decoding=\"async\" src=\"http:\/\/hi.csdn.net\/attachment\/201012\/14\/0_1292291769f4iL.gif\" alt=\"\" \/><\/p>\n<p style=\"MARGIN: 0in 0in 0in 0.375in; FONT-SIZE: 9pt\"><span style=\"FONT-FAMILY: 'Courier New'\" lang=\"en-US\">2.<\/span><span style=\"FONT-FAMILY: SimSun\" lang=\"zh-CN\">\u521b\u5efa\u955c\u50cf\u8fde\u63a5<\/span><\/p>\n<ul style=\"MARGIN-TOP: 0in; unicode-bidi: embed; DIRECTION: ltr; MARGIN-BOTTOM: 0in; MARGIN-LEFT: 0.75in\" type=\"disc\">\n<li style=\"MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px; VERTICAL-ALIGN: middle\"><span style=\"FONT-FAMILY: SimSun; FONT-SIZE: 9pt\" lang=\"zh-CN\">\u521b\u5efa\u6210\u529f\u540e\u5411\u5bfc\u4f1a\u8be2\u95ee\u662f\u5426\u8981\u542f\u52a8\u955c\u50cf<\/span><span style=\"FONT-FAMILY: 'Courier New'; FONT-SIZE: 9pt\" lang=\"en-US\">,<\/span><span style=\"FONT-FAMILY: SimSun; FONT-SIZE: 9pt\" lang=\"zh-CN\">\u53ef\u4ee5\u7acb\u5373\u542f\u52a8\u6216\u8005\u4e8b\u540e\u518d\u542f\u52a8<\/span><\/li>\n<\/ul>\n<p style=\"MARGIN: 0in 0in 0in 0.75in\"><img decoding=\"async\" src=\"http:\/\/hi.csdn.net\/attachment\/201012\/14\/0_12922917769j11.gif\" alt=\"\" \/><\/p>\n<ul style=\"MARGIN-TOP: 0in; unicode-bidi: embed; DIRECTION: ltr; MARGIN-BOTTOM: 0in; MARGIN-LEFT: 0.75in\" type=\"disc\">\n<li style=\"MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px; VERTICAL-ALIGN: middle\"><span style=\"FONT-FAMILY: SimSun; FONT-SIZE: 9pt\" lang=\"zh-CN\">\u670d\u52a1\u5668\u7f51\u7edc\u5730\u5740<\/span><span style=\"FONT-FAMILY: 'Courier New'; FONT-SIZE: 9pt\" lang=\"en-US\">:<\/span><span style=\"FONT-FAMILY: SimSun; FONT-SIZE: 9pt\" lang=\"zh-CN\">\u663e\u793a\u4e86<\/span><span style=\"FONT-FAMILY: 'Courier New'; FONT-SIZE: 9pt\" lang=\"en-US\">3<\/span><span style=\"FONT-FAMILY: SimSun; FONT-SIZE: 9pt\" lang=\"zh-CN\">\u4e2a\u670d\u52a1\u5668<\/span><span style=\"FONT-FAMILY: 'Courier New'; FONT-SIZE: 9pt\" lang=\"en-US\">(<\/span><span style=\"FONT-FAMILY: SimSun; FONT-SIZE: 9pt\" lang=\"zh-CN\">\u4e3b\u4f53<\/span><span style=\"FONT-FAMILY: 'Courier New'; FONT-SIZE: 9pt\" lang=\"en-US\">,<\/span><span style=\"FONT-FAMILY: SimSun; FONT-SIZE: 9pt\" lang=\"zh-CN\">\u955c\u50cf<\/span><span style=\"FONT-FAMILY: 'Courier New'; FONT-SIZE: 9pt\" lang=\"en-US\">,<\/span><span style=\"FONT-FAMILY: SimSun; FONT-SIZE: 9pt\" lang=\"zh-CN\">\u89c1\u8bc1<\/span><span style=\"FONT-FAMILY: 'Courier New'; FONT-SIZE: 9pt\" lang=\"en-US\">)<\/span><span style=\"FONT-FAMILY: SimSun; FONT-SIZE: 9pt\" lang=\"zh-CN\">\u7aef\u70b9\u8def\u5f84\u53ca\u901a\u4fe1\u7aef\u53e3<\/span><\/li>\n<\/ul>\n<ul style=\"MARGIN-TOP: 0in; unicode-bidi: embed; DIRECTION: ltr; MARGIN-BOTTOM: 0in; MARGIN-LEFT: 0.75in\" type=\"disc\">\n<li style=\"MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px; VERTICAL-ALIGN: middle\"><span style=\"FONT-FAMILY: SimSun; FONT-SIZE: 9pt\" lang=\"zh-CN\">\u8fd0\u884c\u6a21\u5f0f<\/span><span style=\"FONT-FAMILY: 'Courier New'; FONT-SIZE: 9pt\" lang=\"en-US\">:<\/span>\n<ul style=\"MARGIN-TOP: 0in; unicode-bidi: embed; DIRECTION: ltr; MARGIN-BOTTOM: 0in; MARGIN-LEFT: 0.375in\" type=\"disc\">\n<li style=\"MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px; VERTICAL-ALIGN: middle\"><span style=\"FONT-FAMILY: SimSun; FONT-SIZE: 9pt\" lang=\"zh-CN\">\u9ad8\u6027\u80fd\u6a21\u5f0f<\/span><span style=\"FONT-FAMILY: 'Courier New'; FONT-SIZE: 9pt\" lang=\"en-US\">:<\/span><span style=\"FONT-FAMILY: SimSun; FONT-SIZE: 9pt\" lang=\"zh-CN\">\u4e0d\u9700\u8981\u89c1\u8bc1\u670d\u52a1\u5668<\/span><span style=\"FONT-FAMILY: 'Courier New'; FONT-SIZE: 9pt\" lang=\"en-US\">,<\/span><span style=\"FONT-FAMILY: SimSun; FONT-SIZE: 9pt\" lang=\"zh-CN\">\u91c7\u7528\u5f02\u6b65\u64cd\u4f5c<\/span><span style=\"FONT-FAMILY: 'Courier New'; FONT-SIZE: 9pt\" lang=\"en-US\">,<\/span><span style=\"FONT-FAMILY: SimSun; FONT-SIZE: 9pt\" lang=\"zh-CN\">\u6709\u6570\u636e\u9057\u5931\u7684\u98ce\u9669<\/span><\/li>\n<\/ul>\n<ul style=\"MARGIN-TOP: 0in; unicode-bidi: embed; DIRECTION: ltr; MARGIN-BOTTOM: 0in; MARGIN-LEFT: 0.375in\" type=\"disc\">\n<li style=\"MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px; VERTICAL-ALIGN: middle\"><span style=\"FONT-FAMILY: SimSun; FONT-SIZE: 9pt\" lang=\"zh-CN\">\u9ad8\u4fdd\u62a4\u6a21\u5f0f<\/span><span style=\"FONT-FAMILY: 'Courier New'; FONT-SIZE: 9pt\" lang=\"en-US\">:<\/span><span style=\"FONT-FAMILY: SimSun; FONT-SIZE: 9pt\" lang=\"zh-CN\">\u4e0d\u9700\u8981\u89c1\u8bc1\u670d\u52a1\u5668<\/span><span style=\"FONT-FAMILY: 'Courier New'; FONT-SIZE: 9pt\" lang=\"en-US\">,<\/span><span style=\"FONT-FAMILY: SimSun; FONT-SIZE: 9pt\" lang=\"zh-CN\">\u91c7\u7528\u540c\u6b65\u64cd\u4f5c<\/span><span style=\"FONT-FAMILY: 'Courier New'; FONT-SIZE: 9pt\" lang=\"en-US\">,<\/span><span style=\"FONT-FAMILY: SimSun; FONT-SIZE: 9pt\" lang=\"zh-CN\">\u6ca1\u6709\u6570\u636e\u9057\u5931\u7684\u98ce\u9669<\/span><span style=\"FONT-FAMILY: 'Courier New'; FONT-SIZE: 9pt\" lang=\"en-US\">,<\/span><span style=\"FONT-FAMILY: SimSun; FONT-SIZE: 9pt\" lang=\"zh-CN\">\u4f46\u662f\u4e3b\u4f53\u53d1\u751f\u5f02\u5e38\u65f6\u5fc5\u987b\u624b\u52a8\u8f6c\u79fb\u81f3\u955c\u50cf\u670d\u52a1\u5668<\/span><\/li>\n<\/ul>\n<ul style=\"MARGIN-TOP: 0in; unicode-bidi: embed; DIRECTION: ltr; MARGIN-BOTTOM: 0in; MARGIN-LEFT: 0.375in\" type=\"disc\">\n<li style=\"MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px; VERTICAL-ALIGN: middle\"><span style=\"FONT-FAMILY: SimSun; FONT-SIZE: 9pt\" lang=\"zh-CN\">\u9ad8\u53ef\u7528\u6a21\u5f0f<\/span><span style=\"FONT-FAMILY: 'Courier New'; FONT-SIZE: 9pt\" lang=\"en-US\">:<\/span><span style=\"FONT-FAMILY: SimSun; FONT-SIZE: 9pt\" lang=\"zh-CN\">\u9700\u8981\u6709\u89c1\u8bc1\u670d\u52a1\u5668<\/span><span style=\"FONT-FAMILY: 'Courier New'; FONT-SIZE: 9pt\" lang=\"en-US\">,<\/span><span style=\"FONT-FAMILY: SimSun; FONT-SIZE: 9pt\" lang=\"zh-CN\">\u91c7\u7528\u540c\u6b65\u64cd\u4f5c<\/span><span style=\"FONT-FAMILY: 'Courier New'; FONT-SIZE: 9pt\" lang=\"en-US\">,<\/span><span style=\"FONT-FAMILY: SimSun; FONT-SIZE: 9pt\" lang=\"zh-CN\">\u6ca1\u6709\u6570\u636e\u9057\u5931\u7684\u98ce\u9669<\/span><span style=\"FONT-FAMILY: 'Courier New'; FONT-SIZE: 9pt\" lang=\"en-US\">,<\/span><span style=\"FONT-FAMILY: SimSun; FONT-SIZE: 9pt\" lang=\"zh-CN\">\u5982\u679c\u4e3b\u4f53\u53d1\u751f\u5f02\u5e38\u53ef\u4ee5\u81ea\u52a8\u8f6c\u79fb\u81f3\u955c\u50cf\u670d\u52a1\u5668<\/span><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<ul style=\"MARGIN-TOP: 0in; unicode-bidi: embed; DIRECTION: ltr; MARGIN-BOTTOM: 0in; MARGIN-LEFT: 0.75in\" type=\"disc\">\n<li style=\"MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px; VERTICAL-ALIGN: middle\"><span style=\"FONT-FAMILY: SimSun; FONT-SIZE: 9pt\">\u955c\u50cf\u673a\u5236\u5f00\u59cb\u8fd0\u884c<\/span><\/li>\n<\/ul>\n<p style=\"MARGIN: 0in 0in 0in 0.75in\"><img decoding=\"async\" src=\"http:\/\/hi.csdn.net\/attachment\/201012\/14\/0_1292291782s19m.gif\" alt=\"\" \/><\/p>\n<p style=\"MARGIN: 0in 0in 0in 0.375in; FONT-SIZE: 9pt\"><span style=\"FONT-FAMILY: 'Courier New'\" lang=\"en-US\">3.<\/span><span style=\"FONT-FAMILY: SimSun\" lang=\"zh-CN\">\u9a8c\u8bc1\u6570\u636e\u5e93\u955c\u50cf<\/span><\/p>\n<ul style=\"MARGIN-TOP: 0in; unicode-bidi: embed; DIRECTION: ltr; MARGIN-BOTTOM: 0in; MARGIN-LEFT: 0.75in\" type=\"disc\">\n<li style=\"MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px; VERTICAL-ALIGN: middle\"><span style=\"FONT-FAMILY: SimSun; FONT-SIZE: 9pt\">\u5728\u4e3b\u4f53\u670d\u52a1\u5668\u4e0a\u521b\u5efa\u8868\u53ca\u6570\u636e<\/span><\/li>\n<\/ul>\n<p style=\"MARGIN: 0in 0in 0in 0.75in; FONT-FAMILY: 'Courier New'; FONT-SIZE: 9pt\"><textarea cols=\"50\" rows=\"15\" name=\"code\" class=\"c-sharp\">USE DB_Mirror<br \/>\nGO<br \/>\n&#8212;  \u521b\u5efaTable_Mirror\u8868,\u5e76\u63d2\u5165\u6570\u636e<br \/>\nCREATE TABLE Table_Mirror<br \/>\n(id INT IDENTITY(1,1) PRIMARY KEY,<br \/>\nname VARCHAR(20) NOT NULL,<br \/>\ndate DATETIME NOT NULL<br \/>\n)<br \/>\nINSERT INTO Table_Mirror VALUES(&#8216;Kobe&#8217;, GETDATE())<br \/>\nINSERT INTO Table_Mirror VALUES(&#8216;Jordan&#8217;, GETDATE())<br \/>\nINSERT INTO Table_Mirror VALUES(&#8216;Wade&#8217;, GETDATE())<br \/>\n&#8212; \u9a8c\u8bc1\u6570\u636e<br \/>\nSELECT * FROM Table_Mirror<\/textarea> <\/p>\n<p style=\"MARGIN: 0in 0in 0in 0.75in\"><img decoding=\"async\" src=\"http:\/\/hi.csdn.net\/attachment\/201012\/14\/0_1292291788kTXF.gif\" alt=\"\" \/><\/p>\n<ul style=\"MARGIN-TOP: 0in; unicode-bidi: embed; DIRECTION: ltr; MARGIN-BOTTOM: 0in; MARGIN-LEFT: 0.75in\" type=\"disc\">\n<li style=\"MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px; VERTICAL-ALIGN: middle\"><span style=\"FONT-FAMILY: SimSun; FONT-SIZE: 9pt\" lang=\"zh-CN\">\u70b9\u51fb<\/span><span style=\"FONT-FAMILY: 'Courier New'; FONT-SIZE: 9pt\" lang=\"en-US\">&#8220;<\/span><span style=\"FONT-FAMILY: SimSun; FONT-SIZE: 9pt\" lang=\"zh-CN\">\u6545\u969c\u8f6c\u79fb<\/span><span style=\"FONT-FAMILY: 'Courier New'; FONT-SIZE: 9pt\" lang=\"en-US\">&#8220;,<\/span><span style=\"FONT-FAMILY: SimSun; FONT-SIZE: 9pt\" lang=\"zh-CN\">\u5982\u56fe<\/span><\/li>\n<\/ul>\n<p style=\"MARGIN: 0in 0in 0in 0.75in\"><img decoding=\"async\" src=\"http:\/\/hi.csdn.net\/attachment\/201012\/14\/0_1292291795nxLZ.gif\" alt=\"\" \/><\/p>\n<ul style=\"MARGIN-TOP: 0in; unicode-bidi: embed; DIRECTION: ltr; MARGIN-BOTTOM: 0in; MARGIN-LEFT: 0.75in\" type=\"disc\">\n<li style=\"MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px; VERTICAL-ALIGN: middle\"><span style=\"FONT-FAMILY: SimSun; FONT-SIZE: 9pt\">\u9a8c\u8bc1\u955c\u50cf\u670d\u52a1\u5668\u4e2d\u6570\u636e<\/span><\/li>\n<\/ul>\n<p style=\"MARGIN: 0in 0in 0in 0.75in; FONT-FAMILY: 'Courier New'; FONT-SIZE: 9pt\"><textarea cols=\"50\" rows=\"15\" name=\"code\" class=\"c-sharp\">use DB_Mirror<br \/>\nGO<br \/>\nSELECT * FROM Table_Mirror<\/textarea> <\/p>\n<p style=\"MARGIN: 0in 0in 0in 0.75in\"><img decoding=\"async\" src=\"http:\/\/hi.csdn.net\/attachment\/201012\/14\/0_1292291804Mc9A.gif\" alt=\"\" \/><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u8bd5\u9a8c\u76ee\u6807:\u521b\u5efaDatabase Mirroring \u51c6\u5907\u5de5\u4f5c: 1.\u51c6\u59073\u53f0\u6570\u636e\u5e93\u5b9e\u4f8b WIN-9JFNLS7 [&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-2","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\/2","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=2"}],"version-history":[{"count":0,"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=\/wp\/v2\/posts\/2\/revisions"}],"wp:attachment":[{"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}