January 29, 2007 at 4:08 am
Hi,
Our Distribution database is growing phenominally.
The reason for this growth is due to sp "sp_expired_publication_cleanup" being disabled. We had disabled it, since this procedure, seems deleting subcription(s),irrespective of the data is in queue or not
Is there any way we can reduce the Distribution database size ? I would like to reduce the size on a weekly basis (via scheduled task)
Our environment is SQL Server 2000 and using merge replication across 50+ databases.Replication is set to sync on a continuous mode and there no are pending transactions to be made sync.
Rangark.
January 30, 2007 at 11:34 am
Rangark,
If I remember your previous posts correctly, you disabled the cleanup because you had data queued up for subscribers that was being deleted before the subscriber had a chance to get the data. Now that you have disabled the cleanup, the data will continue to queue in the distribution database until all 50+ subscribers have retrieved it. Just one subscriber being unable to connect to get the data in the queue will result in it staying in the distribution database.
If you want to reduce the size, then re-enable your cleanup job, choosing an expiration for the subscriptions that is a reasonable compromise between not losing data and having it grow forever. Either that, or check to see which subscribers are not retrieving their subscriptions and either drop them manually or "fix" them so they get the data.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply