Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2004
    Posts
    76

    Unhappy Unanswered: The process is running and is waiting for a response from one of the backend CONNECTI

    We are useing merge replication with MSSQL Server 2000 for our two location, we have more than 6 database in replication on has issue following error and few time not updated data due to this error -

    The process is running and is waiting for a response from one of the backend CONNECTION

    With regards

    R.MAll

  2. #2
    Join Date
    Dec 2002
    Posts
    1,245
    Check out this link: http://sqlforums.windowsitpro.com/we...&enterthread=y

    Scroll down a couple of posts. Like the reply said, I saw the same assessment; basically it's not a big one to worry about.

    Regards,

    hmscott
    Have you hugged your backup today?

  3. #3
    Join Date
    Aug 2004
    Location
    Pune,India
    Posts
    94
    is that a custom error message?
    please let us know what's the table size(no of rows and columns etc..).

    Also if you have any indexes upon this table, please check if there is any dead-lock due to updates caused by the replication. The indexes sometimes cause a transaction deadlock when the table size is large.

    Hope this helps.
    In GOD we believe. Everything else we Test!

Posting Permissions

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