AlwaysOn Availability Group with 2 Groups and 2 Primary RRS feed

  • Question

  • Hi everybody

    I have to different Groups and two SQL Server. Normally I will have an primary and a secondary node. But in this case the secondary node is passive and waiting until a failover. <o:p></o:p>

    My idee is to use each SQL Server for one Group as the primary. Is it is possible that a primary Server can be a secondary
    Server for another group like following example?

    SQL Server 1 (Node1)
        Group "Config" -> Primary
        Group "Content" -> Secondary

    SQL Server 2 (Node2)    
        Group "Config" -> Secondary
        Group "Content" -> Primary

    It is possible to access all the data on the same
    alias name?

    Thanks for helping


    Thursday, March 20, 2014 12:37 PM


All replies