Effects of reboot on SQL2005 Merge Replication?
in [Replication]
|
Prev: Error 14151: schema script could not be propagated to the subscrib
Next: SQL2005 / SP2 / Setting replication clean-out metadata
From: fred on 21 Aug 2008 09:18 Hi, Can anyone confirm what happens when either of 2 SQL 2005 servers configured for continous merge replication are rebooted? Will the replication just pick up and carry on, or must it be manually started again? Many thanks, FD
From: Jos� Araujo on 21 Aug 2008 13:40 Check the schedule of the associated scheduled job. I presume they are set to start on server's start. In any case it will resume the next time the scheduled job starts (either manually or automatically). Regards. "fred" <mojacmankey(a)community.nospam> wrote in message news:5140EBBA-5AF8-4300-9AA1-5FBF462BE55B(a)microsoft.com... > Hi, > > Can anyone confirm what happens when either of 2 SQL 2005 servers > configured > for continous merge replication are rebooted? > > Will the replication just pick up and carry on, or must it be manually > started again? > > Many thanks, > > FD
From: "Charles Wang [MSFT]" on 22 Aug 2008 04:31 Hi FD, Based on my research, the process may need your manual synchronization after each one rebooted, however I have not found an official document talking about it. Now I am trying to establish a test environment for verifying this issue and may need more time to get back to you for further confirmation on this. I appreicate your patience. If you have any other questions or concerns, please feel free to let me know. Have a nice weekend! Best regards, Charles Wang Microsoft Online Community Support Get Secure! - www.microsoft.com/security ==================================================== When responding to posts, please "Reply to Group" via your newsreader so that others may learn and benefit from your issue. ==================================================== This posting is provided "AS IS" with no warranties, and confers no rights. ====================================================
From: fred on 22 Aug 2008 04:56 Many thanks Charles.
From: "Charles Wang [MSFT]" on 26 Aug 2008 04:45
Hi FD, Sorry for delaying this response. Based on my test, SQL Server 2005 continous merge replication worked fine when either the publisher or subscriber was rebooted. After any of the servers came online, all newly inserted or changed data would be synchronized automatically. So in conclusion, you need not to manually start the replication again. Best regards, Charles Wang Microsoft Online Community Support ========================================================= Delighting our customers is our #1 priority. We welcome your comments and suggestions about how we can improve the support we provide to you. Please feel free to let my manager know what you think of the level of service provided. You can send feedback directly to my manager at: msdnmg(a)microsoft.com. ========================================================= This posting is provided "AS IS" with no warranties, and confers no rights. ========================================================= |