Re: distribution database does not seem to shrink

Is the cleanup task working?

There is a problem with SP2 with the cleanup task. Microsoft is
advising you revert back to the SQL 2005 sp 1 procs.

Also, have you seen this?

http://support.microsoft.com/kb/947008/en-us


On Feb 3, 2:41 pm, "John Doe" <John...@xxxxxx> wrote:
Using SQL 2005 transactional replication. The space used in the data file is
around 10GB and all of our subscribers are up-to-date and the distribution
clean up job is running too and yet the size of used space does not seem to
reduce. It used to be that if all transactions made it to the subscribers
and if the clean job runs every 5 mins or so, the size should usually be in
the 100 MBs where I have seen it before ( atleast in SQL 2000)

Let me know how to figure out whats in that database thats consuming all the
space and why is it not clearing off

Thanks

.

Relevant Pages