SQl 2019 AlwaysOn Basic for Standard Ediiton

Vishu 1,556 Reputation points

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

2 answers

Sort by: Most helpful
  1. David Browne - msft 3,771 Reputation points

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

    0 comments No comments

  2. Cris Zhan-MSFT 6,611 Reputation points

    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

    0 comments No comments