By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,700 Members | 1,364 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,700 IT Pros & Developers. It's quick & easy.

Failing replication after WAN disconnect requiring restart MS SQL Agent 2008 R2

P: 1
This question was asked by Fredrik M?ller but can't see any replies.

I have a problem with Transactional Replication over a WAN. Server A is a distributor and server B is a publisher. Sometimes the network goes down and replication fails. When the network comes up again the log reader at server A continues to fails. To get the replication going one has to restart the SQL Agent at the server B.

This is a big problem. The personnel who watches over the replication sometimes has to restart the agents in the middle of the night.

Is there any way I can automate to restart the SQL Agent?

Thanks for your help in advance.
Dec 23 '14 #1
Share this Question
Share on Google+
1 Reply


ck9663
Expert 2.5K+
P: 2,878
Should you be asking why the network is failing in the first place?

Good Luck!!!


~~ CK
Jan 5 '15 #2

Post your reply

Sign in to post your reply or Sign up for a free account.