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

sakuraime 2,286 Reputation points

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.
9,802 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. AmeliaGu-MSFT 13,901 Reputation points Microsoft Vendor

    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,

    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 No comments