Effects of reboot on SQL2005 Merge Replication?

[fred]

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

[José Araujo]

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" <mojac...@community.nospam> wrote in message
news:5140EBBA-5AF8-4300...@microsoft.com...

[Charles Wang [MSFT]]

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

[fred]

Many thanks Charles.

[Charles Wang [MSFT]]

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

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

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