• tcronin 95651 - Tuesday, May 1, 2018 9:12 AM

    Quick question may be if I setup AG with 2 servers with one read only intent, and primary fails, can it fail over to Read only intent?  If so when primary comes back online can they reverse roles?

    The other node will become the primary (R/W) replica.

    Check that you are covered for licensing because there can be licensing implications for using both nodes (but not always, so it depends on your company's individual agreement).