Sqlserver 2005 Replication issue
- by Francesco
Hi,
I have a peer to peer Merge Replication from two Sqlserver 2005. The first Sqlserver is both the publisher and distribuitor. All works fine but if the VPN goes down for a couple of hours the replication goes down too and I need to manually restart the sqlserver agent.
In the Sqlserver Agent properties I have set the two option about the agent failover but nothing.
How I can set an automatic restart of sqlserver agent when the VPN goes down?
Thanks