MSRepl_Commands

I followed your advise Hilary,
"query MSDistribution_status in your distribution database - this will help
you to understand where the problem is
Otherwise run the distribution clean up agent."
Distribution Agent doesn't appear to be clearing these old transactions.
Is there a way to clean out the old Undelivered commands that I told the Agent to skip/ignore?
Any suggestions on how I can get MSRepl_Commands table back under 3 million rows?
Thanx!
JLS
A quick and dirty way to do this is to drop the subscriptions and then
recreate them using a nosync subscription.
You can also manually delete them if you are very careful and know which
ones to remove. If you are using anonymous subscriptions they will hang
around longer than if you are using named subscriptions. Can you convert
them to named subscriptions?
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
"JLS" <jlshoop@.hotmail.com> wrote in message
news:%231mF$ZW4FHA.400@.TK2MSFTNGP09.phx.gbl...
I followed your advise Hilary,
"query MSDistribution_status in your distribution database - this will help
you to understand where the problem is
Otherwise run the distribution clean up agent."
Distribution Agent doesn't appear to be clearing these old transactions.
Is there a way to clean out the old Undelivered commands that I told the
Agent to skip/ignore?
Any suggestions on how I can get MSRepl_Commands table back under 3 million
rows?
Thanx!
JLS
|||I don't use anonymous subscriptions.
What is the harm in deleting from msrepl_commands?
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message news:uToQ7yb4FHA.3948@.TK2MSFTNGP09.phx.gbl...
A quick and dirty way to do this is to drop the subscriptions and then
recreate them using a nosync subscription.
You can also manually delete them if you are very careful and know which
ones to remove. If you are using anonymous subscriptions they will hang
around longer than if you are using named subscriptions. Can you convert
them to named subscriptions?
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
"JLS" <jlshoop@.hotmail.com> wrote in message
news:%231mF$ZW4FHA.400@.TK2MSFTNGP09.phx.gbl...
I followed your advise Hilary,
"query MSDistribution_status in your distribution database - this will help
you to understand where the problem is
Otherwise run the distribution clean up agent."
Distribution Agent doesn't appear to be clearing these old transactions.
Is there a way to clean out the old Undelivered commands that I told the
Agent to skip/ignore?
Any suggestions on how I can get MSRepl_Commands table back under 3 million
rows?
Thanx!
JLS