July 4, 2012 at 5:21 am
I am getting "No replicated transactions are available" on distributor on my transactional replication. I have check all the available suggestions in many forum but non is seems to resolve my issue.
I am using transactional replication on SQL server 2008 standard edition. Distributor is on the subscriber server and using pull subscription. Every morning around same time distributor seems to stop replicating transaction from publisher. When I run
"sp_MSenum_distribution @name = '%',@show_distdb =0"
, distributor status shown is idle(4).
After few hours it starts responding and sync after 4-5 hr subscription DB.
Any help would be appreciated.
Thanks
Vivek
July 5, 2012 at 11:39 pm
check in replication monitor and restart the agent, if not resolve then run trace on server and find cause for it.
July 6, 2012 at 12:38 am
On replication monitor - Distributor To Subscriber History shows "No
replicated transactions are available." whereas Publisher to distributor keep working fine by showing "Delivering replicated transactions, xact count: x and command count: y".
Restarting distribution agent and log reader agents has no effect. What I find is that after a bulk transaction on production server distribution agent goes in idle condition. After that distribution clean up, Agent history clean up and distribution DB's differential backup starts getting blocked by log reader agents for 4-5 hrs.
Thanks for reply.
Vivek
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply