SQL Server Performance Forum – Threads Archive
Active/Passive w/ ReplicationBrad, or anyone, Have you found the only real issue to be the location of the snapshot folder when setting up for merge or transactional replication in an Active/Passive clustered environment?
I think during failover the replication will have the problems to run. Satya SKJ
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.
What is the issue? Use the SQL Server virtual name in your UNC path and put the folder on one of the shared disks. During failover the issue would be the same as when stopping/starting a single server with replication.