Distributed Availability group open to read on the primary replica of the secondary AG

sakuraime 2,321 Reputation points
2021-03-12T12:36:33.157+00:00

For Distributed Availability group ,
is it possible to open read operation on the primary replica of the SECONDARY AG ??

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,758 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. AmeliaGu-MSFT 13,961 Reputation points Microsoft Vendor
    2021-03-15T06:11:53.093+00:00

    Hi @sakuraime ,
    Yes, the Distributed Availability group will only one copy of the databases participating in a distributed availability group that can accept inserts, updates, and deletions, the remain replicas can be Read-only.
    Please refer to Understand distributed availability groups which might help.

    Best Regards,
    Amelia

    If the answer is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread

    0 comments