Always on between Two SQL failover Cluster instances

  • i am having two Windows clusters. Two SQL cluster instances are there in each two node cluster (

    Data centre 1 :Windows Cluster 1-SQL2016CLUS1

    Node 1
    Node 2
    SQL 2016  failover cluster instance1 -SQL2016DB01
    SQL 2017  failover cluster instance2 -SQL2017DB01

    Data Centre 2: windows cluster 2-SQL2016CLuS2

    Node 3
    Node 4
    SQL 2016  failover cluster instance1 -SQL2016DB02
    SQL 2017  failover cluster instance2 -SQL2017DB02

    Now I want to configure Always On between two SQL 2016 cluster instances(SQL2016DB01 & SQL2016DB02)    
    How to configure?

    For configuring "Distrubuted Always On" We need to create AOAG right(with in same data centre)? How to create AOAG, because i have only one instance

  • vigneshbeece - Friday, May 18, 2018 2:39 AM

    i am having two Windows clusters. Two SQL cluster instances are there in each two node cluster (
    Data centre 1 :Windows Cluster 1-SQL2016CLUS1

    Node 1
    Node 2
    SQL 2016  failover cluster instance1 -SQL2016DB01
    SQL 2017  failover cluster instance2 -SQL2017DB01

    Data Centre 2: windows cluster 2-SQL2016CLuS2

    Node 3
    Node 4
    SQL 2016  failover cluster instance1 -SQL2016DB02
    SQL 2017  failover cluster instance2 -SQL2017DB02

    Now I want to configure Always On between two SQL 2016 cluster instances(SQL2016DB01 & SQL2016DB02)    
    How to configure?

    What operating system are you using for the cluster nodes?

    vigneshbeece - Friday, May 18, 2018 2:39 A


    For configuring "Distrubuted Always On" We need to create AOAG right(with in same data centre)? How to create AOAG, because i have only one instance

    A distributed AG is configured across existing AGs in separate clusters, which you do not seem to have configured

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • For the above requirement we cant configure "Always on" right?

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

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