Effects of reboot on SQL2005 Merge Replication?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

fred - 21 Aug 2008 14:18 GMT

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

Reply to this Message

José Araujo - 21 Aug 2008 18:40 GMT

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.

> Hi,
>
[quoted text clipped - 8 lines]
>
> FD

Reply to this Message

Charles Wang [MSFT] - 22 Aug 2008 09:31 GMT

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.
====================================================

Signature

This posting is provided "AS IS" with no warranties, and confers no rights.

====================================================

Reply to this Message

fred - 22 Aug 2008 09:56 GMT

Many thanks Charles.

Reply to this Message

Charles Wang [MSFT] - 26 Aug 2008 09:45 GMT

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@microsoft.com.
=========================================================

Signature

This posting is provided "AS IS" with no warranties, and confers no rights.

=========================================================

Reply to this Message