var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Transactional Replication Timeout Expired
I have Transactional replication setup like this:
Server A: Publisher
Server B: Distributor
Server C: Subscriber
A is able to deliver commands to B with no problem.
However, after replication runs for a day I am getting these timeouts on B while it is trying to connect to C to deliver transactiona and commands.
• Connecting to Subscriber 'C'
• The process is running and is waiting for a response from one of the backend connections.
• Timeout expired
Why can I not get replication to run for more than half a day?
Has anyone else had this issue? I can connect to B from C with no problem in Query Analyzer.
I created a custom distribution profile and increased the query timeout and that seems to have solved my problem.