SQL Server Performance

sql 2000 replication and cluster failover

Discussion in 'Performance Tuning for SQL Server Replication' started by shahab03, Nov 29, 2006.

  1. shahab03 Member

    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
  2. satya Moderator

    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.
  3. shahab03 Member

    are you saying that by using replication I am deactivating my failover capibility?
  4. satya Moderator

  5. MohammedU New Member

    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.

Share This Page