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 post 1 (of 2 total)
You must be logged in to reply to this topic. Login to reply