Post reply

Replication doubt

  • March 5, 2009 at 11:33 am

    #155374

    I have replication configured between servers.

    On publisher server, there are subscriptions to 3 servers.

    Now, if one subscriber server is decommissioned then replication would fail right?

    To prevent replication failing, we need to drop the subscription on publisher right. Is there anything else that needs to be done.

    M&M

  • March 5, 2009 at 12:19 pm

    #954292

    Moin,

    Just use sp_dropsubscription(http://msdn.microsoft.com/en-us/library/ms184385(SQL.90).aspx) and get rid of that subscriber.

    EXEC sp_dropsubscription

    @publication = @publication,

    @article = N'all',

    @subscriber = @subscriber;

    GO

    MJ

  • March 5, 2009 at 12:48 pm

    #954315

    If one of the subscribers is shut down or otherwise drops off the network then the distribution agent for that subscription would fail, but the other subscribers should be fine. Eventually the failed subscription will expire and be marked for resynchronization. As Manu pointed out, it's best just to drop that subscription (ideally before you turn the machine off, but it can still be done afterwards).

    Kendal Van Dyke
    http://kendalvandyke.blogspot.com/[/url]

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply