Wednesday, March 7, 2012

Distributor

Hi
How do you clear out the distributor? I am able to clear down the log
using sp_repldone, sp_replflush if there are large errors. However,
how do I clear out the distributor assuming that it's trying to
execute a sproc that might not have been replicated?
Thank you
Simon
Drop the subscriber and recreate it using a no-sync subscription.
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
<simon@.otr-tech.com> wrote in message
news:1182337698.395239.178640@.c77g2000hse.googlegr oups.com...
> Hi
> How do you clear out the distributor? I am able to clear down the log
> using sp_repldone, sp_replflush if there are large errors. However,
> how do I clear out the distributor assuming that it's trying to
> execute a sproc that might not have been replicated?
> Thank you
> Simon
>

No comments:

Post a Comment