Share via

what's the max number of async replicas in SQL Server 2016 and 2019

sakuraime 2,341 Reputation points
2020-11-30T06:40:24.453+00:00

what's the max number of async replicas in SQL Server 2016 and 2019 ??

SQL Server Other
0 comments
Accepted answer
  1. CathyJi-MSFT 22,396 Reputation points Microsoft External Staff
    2020-11-30T07:46:15.263+00:00

    Hi @sakuraime ,

    Nine replicas. For SQL 2019 and SQL 2016 are both Nine.

    For Availability replicas: Each availability group supports one primary replica and up to eight secondary replicas. All of the replicas can run under asynchronous-commit mode. Please refer to Restrictions (Availability Groups).

    Best regards,
    Cathy

    If the response is helpful, please click "Accept Answer" and upvote it.

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.