June 21, 2018 at 4:56 am
The 'Distribution clean up: distribution' job has been set to run every 10 minutes but lately, it seems to run continuously. The things I have looked at so far are:
1. If the 'Transaction retention' is set the same as whats on the script on the job e.g. EXEC dbo.sp_MSdistribution_cleanup @min_distretention = 0, @max_distretention = 72
2. The size of the [dbo].[MSrepl_commands] table, which understandably is growing as a result of the job not completing
Is there anything which could be done to resolve this issue?
Thank you in advance!
June 21, 2018 at 7:32 am
tt-615680 - Thursday, June 21, 2018 4:56 AMThe 'Distribution clean up: distribution' job has been set to run every 10 minutes but lately, it seems to run continuously. The things I have looked at so far are:1. If the 'Transaction retention' is set the same as whats on the script on the job e.g. EXEC dbo.sp_MSdistribution_cleanup @min_distretention = 0, @max_distretention = 72
2. The size of the [dbo].[MSrepl_commands] table, which understandably is growing as a result of the job not completing
Is there anything which could be done to resolve this issue?
Thank you in advance!
You can try to clean it up in chucks by changing the retention settings and running sp_MSdistribution_cleanup manually. This article can walk you through that process:
Replication: Distribution Cleanup
It often (not always) works. But you still need to identify why things got backed up. Did you find any errors for the job previously? You can also try running a trace while that job is running - filter to just that job - to see if there are issues when the job is running. Did you check in general for any replication errors - select from MSrepl_errors in the distribution database.
Sue
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply