Tuesday, February 21, 2012

Replication in SQL Server 2000

Hi,
I have Server A(Publishing Server) and Server B(Subscribed Server)
which are in replication. The replication type used is "Transactional
Push Model".
My requirement is to
1. Drop Table1 which is available in both Server A and Server B
2. Drop Table2 which is available in Server A and not in Server B
I have to do this without stopping replication across servers.
Kindly share any information that could be useful.
Thank you,
Praveen
Praveen,
in your post you don't mention which table(s) is involved in replication. If
I assume that tables 1 and 2 are both replicated, then this is strange as it
means server B hasn't initialized yet. Anyway, in general you need to run
sp_droparticle. However this only is acceptable if there aren't any
subscribers to an article, so you run sp_dropsubscription to remove the
subscriptions to a particular article, then sp_droparticle. After that you
delete the table as per usual (drop table table1 etc).
HTH,
Paul Ibison

No comments:

Post a Comment