sql 2000 replication and cluster failover | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

sql 2000 replication and cluster failover

what happens to replication in case sql server fails over to another node? does it break? or does it get moved to the other node as well? thanks shahab

When the Active node fails during a data replication process – data replication is not completed and Failover cannot be activated. Then, you must manually reset the second node to either remain as the passive node or switch it to be the active node. Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing.
are you saying that by using replication I am deactivating my failover capibility?

http://www.sql-server-performance.com/q&a_clustering.asp
http://www.sql-server-performance.com/faq/sqlviewfaq.aspx?faqid=110 Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing.
I don’t think there will be any issue when it fail over to other node because replication is cluster aware… I am using replication on cluster servers since long time and I never had any issue that the data replication prevented failsover to other node. I don’t think cluster failover prevented by data replication…Cluster failover is managed by the cluster service… When MSC gets three continuous connection failure responses it will force sql to restart or failover to other node depends on the error. Mohammed U.
]]>