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
>
Wednesday, March 7, 2012
Distributor
Labels:
clear,
database,
distributor,
errors,
hihow,
logusing,
microsoft,
mysql,
oracle,
server,
sp_repldone,
sp_replflush,
sql
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment