Post reply

Contained Availability Groups and Replication

  • June 14, 2024 at 4:19 pm

    #4428510

    Hi,

    I have a couple of questions around contained AOAG:

    1. Is it still the case that you cannot replicate a database within a contained AOAG?
    2. Are you able to replicate to the nodes involved in the cluster outside of the contained AOAG?

    TIA

  • June 15, 2024 at 5:10 pm

    #4428697

    Thanks for posting your issue and hopefully someone will answer soon.

    This is an automated bump to increase visibility of your question.

  • June 24, 2024 at 8:22 pm

    #4431174

    I have been working with Contained Availability groups for the last few months and I am NOT impressed so far.

    Hope this answers your questions:

    You cannot use a Contained Availability group with a Distributed Availability Group - Microsoft does not support it and that is because when you create the DAG you cannot have any databases in the Availability Group that is on the other set of servers.  Let me know if this makes sense

    The problem I am finding with Contained AG

    -When setting up a maintenance plan like Index Rebuild or DBCC on the Contained AG you only cover the databases in that AG, so you need to create another maintenance plan for all the local databases and the databases that are in regular availability groups

    -The only benefit so far that I am seeing is that you can create a login at the contained level master database and you do not have to create it at each replica

    -The other weird thing I noticed is that when you use the listener of the contained AG to connect to SQL server using SSMS you do not see the contained MSDB_agname and MASTER_agname databases.

    I cannot speak to everything - maybe there are plenty of other good reasons for using the contained availability group, but in my simple implementation its really not doing me any good.

     

    Jeff

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

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