CODEWITHSUNDEEP
failovertransactional-replication
user3625272
user3625272

Reputation: 1

WSFC with SQL transactional replication issue

On my UAT environment, I have 2 nodes, WSFC and SQL transactional replication is setup. Sometime we failover From Node A (Active) to Node B (passive), when Node B becomes active after I failover the replication will break I have to set it up using the script, or GUI. so far all databases are small BUT my question: is there a way to failover nodes without messing up replication? Thanks

Upvotes: 0

Views: 55

Answers (0)

Related Questions