Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

change the subscription server name without breaking replication Expand / Collapse
Author
Message
Posted Wednesday, August 28, 2013 1:23 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, July 24, 2014 11:26 AM
Points: 381, Visits: 1,857
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.
Post #1489396
Posted Wednesday, August 28, 2013 2:15 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, July 24, 2014 11:26 AM
Points: 381, Visits: 1,857
I tested it. It has to be physical server name.
Post #1489408
Posted Tuesday, September 10, 2013 11:33 AM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: 2 days ago @ 1:54 PM
Points: 609, Visits: 426
thats right it has to be physical name even in repl tables it stored based on physical names.
Post #1493302
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse