Active/Passive w/ Replication | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Active/Passive w/ Replication

Brad, 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
Moderator
http://www.SQL-Server-Performance.Com/forum
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.
]]>