November 2, 2011 at 2:54 pm
Hi Guys
I have a replication setup done with 1 publisher and 3 subscriber
its transactional repl in 2008 sql server
Publisher : US server
Subscribers: 1)US 2)Germany 3)Singapore
Us and Germany has no issue but Singapore is getting the below error.
TCP Provider: The semaphore timeout period has expired.
Microsoft engineer checked it and says its network issue, but networking team checked it and says no issue with network.
any suggestions to lookout for?
November 3, 2011 at 7:50 am
It will be a network issue rather than sql server and based on the location it is likely to be network lag causing the error.
We get this on occasion going to the southern hemisphere. Is it a permanent error or occasional?
Bearing in mind that the internet routing is out of our control to a degree. The network connection cannot be guaranteed and you will get occasional blips. I would increase the timeout period on distribution agent profile and see if that helps.
November 3, 2011 at 12:20 pm
we are getting this error from last 1 month, we never faced this on the replication before.
we tried increasing timeout period and batch size too, it doesn't work for us.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply