"ThomBeaux" <ThomBeaux@NoSpam.Com> wrote in message
news:9421D30A-1F0D-4CC8-8980-00C09DDA6837@microsoft.com...
> Our distribution database in up to 9 GBs, after only 3 weeks...
>
> What job cleans out data from this database?
>
> What do I need to check to verify this?
> --
> Thanks and God Bless,
> ThomBeaux

"Hilary Cotter" wrote:

> Is that all. What's your secret?
>
> Check space usage to see if this is the actual size and ensure its not the
> transaction log bloat.
>
> The distribution database is a queue which is purged by the distribution
> clean up task. For anoymous subscribers you can get data hanging around till
> the retention period has elapsed (or the lesser of the retention period and
> the history).
>
> It is normal for it to grow quite large if your publisher is replicating a
> lot of commands.
>
> --
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
>
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> "ThomBeaux" <ThomBeaux@NoSpam.Com> wrote in message
> news:9421D30A-1F0D-4CC8-8980-00C09DDA6837@microsoft.com...
> > Our distribution database in up to 9 GBs, after only 3 weeks...
> >
> > What job cleans out data from this database?
> >
> > What do I need to check to verify this?
> > --
> > Thanks and God Bless,
> > ThomBeaux
>
>