SQl 2019 AlwaysOn Basic for Standard Ediiton

Vishal 1,351 Reputation points
2020-12-18T11:14:19.577+00:00

Hi Experts,

Request you to help if the Basic Alwayson is applicable for SQl 2019 standard edition. If so , is there any changes from SQL 2016 and 2017 versions

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,059 questions

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. David Browne - msft 3,756 Reputation points
    2020-12-18T14:06:59.82+00:00

    It's still there, with no changes from the previous version.

  2. Cris Zhan-MSFT 6,566 Reputation points
    2020-12-21T04:39:22.923+00:00

    Hi @VishalGarg-2318,

    Only the Standard edition of SQL Server 2016 and later supports basic availability groups.

    According to the documents: Editions and supported features of SQL Server 2019 (15.x) and What's new in SQL Server 2019 (15.x), there is no special description for the change to the basic availability groups.
    A basic availability group always only supports two replicas, with one availability database.

    ------------------------------------------------------------------------------------------------

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

    What can I do if my transaction log is full?--- Hot issues November

    How to convert Profiler trace into a SQL Server table -- Hot issues November