Post reply

DISTRIBUTED availability group - how many SEPARATE databases can it contain?

  • September 29, 2022 at 4:28 pm

    #4093514

    To my knowledge, a DAG can have up to 17 REPLICAs, but that is all replicas of the SAME database.

    Is it possible for a DAG to contain 2 (or more) SEPARATE databases? I think not unless I'm doing something wrong 🙂

     

  • September 30, 2022 at 5:10 pm

    #4094093

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

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

  • October 1, 2022 at 3:19 pm

    #4094365

    I think you are expecting multiple availability groups yes possible for different Db's.

    Regards
    Durai Nagarajan

  • October 3, 2022 at 8:23 am

    #4094741

    Distributed AGs were an Enterprise only feature (prior to SQL 2019 CU17).

    So if you are running any version prior to that you can have multiple DBs in the AG and also the DAG as enterprise edition allows for multiple DB AOAGs.

    Now if your on Standard 2019 CU17 your limited to BAG and DAG so there you can only have 1 database in the BAG and therefore 1 database in the DAG.

     

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

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