Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Lost Linked Server how to Stop replication and Restart

Status
Not open for further replies.

roytheboy

Programmer
Aug 18, 2002
58
GB
I have 3 sites.

1 publishing linked server, 2 receiving.

When there is maintenance on the leased line link and they are down for more than 10 mins replication fail and I have to reboot.

Once, sometimes twice I have reboot the server because of this.

Is there another way, or can I detect the link stop replication, try to detect when the link is up again and then start replication again.

Any help would be much appreciated.

Thanks

Roy
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top