change the subscription server name without breaking replication

  • Currently we have replication setup from server A to server B n Server C and from server B to server C. We are planning to move the server B to cluster environment. Currenly all the replication is based on physical server name. We have an alias name for the server B, lets suppose it as D. Is there any way we can change the existing replication setup to use server D instead of server B without breaking replication? or do we have to setup from scratch? So server B acts as a publisher to server C so we have to change publication server name and subscription server name.

  • I tested it. It has to be physical server name.

  • thats right it has to be physical name even in repl tables it stored based on physical names.

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

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