How does one purge the Msrepl_commands table in the Distribution
database? My table has 3447147 rows & I think this is excessive. Any
suggestions?
query MSDistribution_status in your distribution database - this will help
you to understand where the problem is
Otherwise run the distribution clean up agent.
Hilary Cotter
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
<jlshoop@.hotmail.com> wrote in message
news:1129691264.949911.252410@.z14g2000cwz.googlegr oups.com...
> How does one purge the Msrepl_commands table in the Distribution
> database? My table has 3447147 rows & I think this is excessive. Any
> suggestions?
>
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment