Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2003
    Posts
    60

    Angry Unanswered: Changing Remote Distributor

    SQL 2000.

    If I have a server setup to use a remote server for replication distribution can I actually change which server is the distributor?

    Example

    Server1 has publications
    Server2 is distributor for Server1's Publication
    Server3 is new hardware

    Can i Make Server3 replace Server2 as the distributor?

    How can I do this?

  2. #2
    Join Date
    Nov 2005
    Posts
    122
    No (and yes).

    Microsoft says "No" (I have asked), the distributor server name cannot be changed. The reason is that this name is used in various replication system tables.

    You can of course track down all system tables where the distributor name is used and change it. I tried it just for fun on a test system and it worked, but I would never do it on a production system and I would never recommend doing it to anybody.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •