Transactional replication with unreliable network

Last Post 20 Sep 2006 03:36 AM by aidanh. 0 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
New Member
New Member

20 Sep 2006 03:36 AM
I am running SQL Server 2000, and have successfully configured Transactional replication using Enerprise Manager.

The problem I am having is that the network connection between the Publisher and Subscriber is quite tempromental. It seems that if the connection goes down for a period of time, I get the error message "The process could not connect to subscriber". The problem is that even when the connection is back up again I have to manually "Start Synchronizing".

Is there any way using Enterprise manager GUI to make sure the agent continues to attempt to replicate the date? Or Will I have to write some kind of service to Kick start the agent?

thanks in advance


Acceptable Use Policy