SQL Server 2014 Fail Over Cluster Instace with Replication

  • Hi

    I want to implement 2 node Active/Active sql server fail over cluster instance (Version 2014) with database replication, integration & reporting service, appreciate if someone can give the clear guidance to archive this challenge

    Node 1

    Instance 1 Active

    Separate Shared Storage for database file (E:)

    Node 2

    Instance 2 Active

    Separate Shared Storage for database file (F:)

    Node 1

    Database 1 should be replicate to node2

    Node 2

    Database 2 should be replicate to node1

    1. Is this possible to do

    2. If node 1 instance 1 fails, instance 1 should be fail over to Node 2 with the replication

    2.1 if Node 1 instance 1 fails will the replication continue working

    3. If node 2 instance 2 fails, instance 2 should be fail over to Node 2 with the replication

    3.1 if Node 1 instance 1 fails will the replication continue working

    so any help or advice would be greatly appreciated.

    Thanks

    Harshana

  • If configured correctly, replication will resume after a SQL Server restart, and a failover can be seen as a SQL Server restart. So, if you replicate from instance 1 to instance 2, and instance 1 fails over to another node, replication should resume.

    But if I understand your question correctly, you are asking some very basic questions for a very complicated scenario. Personally, I would not recommend using either clustering or replication in production without a thorough understanding of the technology, and I surely would not recommend using both. If I may ask, what requirements do you have to use both clustering and replication?

    Robert van den Berg

    Freelance DBA
    Author of:

  • Hi Robert

    Thank you very much for your reply.

    Anyhow I have installed & configured correctly now its up & running.

    Thanks again your reply.

    Harshana

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply