January 2, 2013 at 5:37 am
Hi,
We are reconfigured publication and subscription but undistributed commands to subscriber is showing very huge
No command to be distributed :7777
Please find the attachment....Help me how can i resolve this
January 2, 2013 at 5:54 am
Hi Friend,
If the number of undistributed commands was very high and increasing. Go and restart the sql server agent at the distributor, and like magic the undistributed commands was back down to 0 again.
Regards,
Kumar
January 2, 2013 at 6:42 am
These commands need to be apply at subscriber right then how can i restart SQL Server Agent.....Is this resolve this kind off issues.
What it mean by undistributed commands. If i restart agent, How to these can be applied to subscribers.
In Replication monitor, Status of Subscriptions are showing as Uninitialized subscribers.
January 2, 2013 at 7:20 am
From the replication monitor as you can see the value for Performance critical, Expiring soon/Expired, and Uninitialized subscription are warnings. When a warning is displayed, the Status column also displays if an agent is running. For example, the status could be Running, Performance critical. So confirm whether you see any value in Status column.
I believe the below steps wil answer for your queries..
1.I stopped SQL Server Agent on my Distribution server in order to effectively stop all replication jobs (although I probably could have manually stopped each of the individual replication jobs instead).
2.I re-ran EXEC dbo.sp_MSdistribution_cleanup @min_distretention = 0, @max_distretention = 1 in order to clean-up the distribution history older than 1 hour. This outputted that no transactions were removed.
3.I re-ran sp_browsereplcmds and saw that I still had a number of transactions in MSrepl_commands.
4.I restarted SQL Server Agent which restarted all the replication jobs.
5.Magically, the undistributed commands went to zero!
6.A quick re-run of sp_browsereplcmds showed that I still had the same number of transactions in MSrepl_commands. I
Regards,
Kumar
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply