What can one do when the distribution cleanup job is unable to cleanup the transactions in the distribution database?

2 votes

1 answer

73 views

sql-server replication sql-server-2019 transactional-replication

some of the tables inside my distribution database are very intensely populated as you can see: enter image description here

this was caused by adding a few large tables to the publication a couple of days ago the cleaning job is running regularly: enter image description here

Inside that job the following command is run:

EXEC dbo.sp_MSdistribution_cleanup @min_distretention = 0, @max_distretention = 72

it looks like it is not doing the cleaning as expected. what alternatives do I have?

Asked by Marcello Miorelli (17274 rep)

Jun 25, 2025, 02:31 PM
Last activity: Jun 26, 2025, 10:57 AM

What can one do when the distribution cleanup job is unable to cleanup the transactions in the distribution database?

Related Questions