Hi, I have a transactional replication between 2 SQL servers 2000 that are
linked via a T-1 connection. I know that my VPN is not too great; almost
everyday I have to reboot the VPN to have a connection to the remote location
to the SQL server. Until I can resolve the Network problem; I would like to
set up the replication to restart the process if it failed due to network
error. I have already set it up to wait 10 minutes, and to send me an email;
however, some time it doesn’t work after a network communication error. I
have to stop and restart the agent manually. Is there a better way to resolve
this issue? Or force replication when Network communication became available?
Thanks

You could have the agent run every minute, or you could force the agent's
steps to run in a loop ie on failure the main step is restarted (3 -> 2).
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)

Thanks Paul, I have a already tried the agent's
steps to run in a loop but still had the same problem.
I will try the agent every 1 minute


[quoted text, click to view]