Post reply

Distributor not Distributing Transaction to Subscriber for one table

  • January 25, 2014 at 11:51 am

    #303356

    Hi all,

    I have a Transaction replication set up, it was running fine and started to given problems for one table only. When I add this table in replication distribution stops delivering transactions to subscriber when I remove it everything is running fine.

    I have to use a Script to find hung transaction on distributor as monitor tool won't show me anything. Has any one faced this problem before ? Does any one was able to resolve this? I am still trying to find a solution for this.

    Thanks for your help.

  • January 29, 2014 at 5:56 am

    #1684265

    Is this issue between publisher and distributor or distributor or subscriber? Please check the error logs for distribution and log reader agent and see if you find anything?

    Also just to test if that table is the issue, create a replication just for that table only and see what happens?

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply