Results 1 to 3 of 3

Thread: Replication - Dropping a Table

  1. #1
    Join Date
    Nov 2002
    Posts
    23

    Question 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

  2. #2
    Join Date
    Nov 2002
    Posts
    84
    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

  3. #3
    Join Date
    Nov 2002
    Posts
    23
    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
  •