-
Replication - Dropping a Table
I'm new to replication and would like to know how to drop an article published for replication. I believe I need to follow these steps, but I am unsure.
Step (1)
exec sp_dropsubscription @publication = N'db name',
@article = N'article name',
@subscriber = 'subscriber name',
@destination_db = N'db name'
Step (2)
exec sp_droparticle @publication = N'db name',
@article = N'article name'
Step (3)
drop the article on the publisher
Step (4)
drop the article on the subscriber
Is this the correct sequence or am I missing something.
Thanks, Dave
-
Note: Snapshot and transactional replication
If you drop the subscription on an article in an immediate-sync publication, you cannot add it back unless you drop the subscriptions on all the articles in the publication and add them all back at once.
An article cannot be removed if one or more subscriptions exist.
remove article from the subscriptions first and then remove the article from publisher
Basically it will not allow you to remove the article from the publisher if you have a subscriber.
I hope this helps
Thanks,
Anu
-
Thanks. I'll give it a try.
Dave
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|