AlwaysOn AAG over SQL Server 2016 and SQL Server 2019?

Worm, Sven 1 Reputation point
2021-02-18T15:29:56.317+00:00

Hi,

is it possible to add a SQL Server 2019 to a SQL Server 2016 AlwaysOn AAG?

Thanks for information

Sven

SQL Server Migration Assistant
SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
459 questions
{count} votes

1 answer

Sort by: Most helpful
  1. AmeliaGu-MSFT 13,936 Reputation points Microsoft Vendor
    2021-02-19T02:12:22.497+00:00

    Hi @Anonymous ,

    No, you cannot.
    Each server instance must be running the same version of SQL Server to participate in an Always On Availability Group. Please refer to Prerequisites for more details.

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