Post reply

New distribution server on SQL 2K5 Transaction Replication

  • July 22, 2009 at 11:26 am

    #136592

    we are planning to move distributor server on new server since currently we are running publisher and distributor on same server, currently we have 4 subscribers , wondering when we change the distributor do we need full replication set up again or any other option to avoid full setup again?

    Thanks much!!

  • July 22, 2009 at 12:15 pm

    #1028583

    you'll have to drop the subscription and resubscribe to the publications.

    The probability of survival is inversely proportional to the angle of arrival.

  • July 22, 2009 at 5:57 pm

    #1028720

    subscription should not be an issue also i am using PULL subscription but the issue i am concerned with publication how it will be taken care without dropping and re-creating?

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

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