Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2004
    Posts
    21

    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.

  2. #2
    Join Date
    Sep 2004
    Posts
    21
    I created a custom distribution profile and increased the query timeout and that seems to have solved my problem.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •