SQL Server 2019 - Downgrade licence from Enerprise to Standard

Jean Yalbir 0 Reputation points
2024-02-07T09:49:19.3866667+00:00

Hello Folks, I've got a question please regarding the fesability to downgrade my SQL Server licence to Standard. Currently, i have SQL Server 2019 Enterprise installed on 2 servers with AlwaysOn (so 2 replicas). I've got 10 databases in the Always On with 5 availability groups. My question is, according to the number of databases and availability groups, can i downgrade my SQL Server licence from Enterprise to Standard ? Thanks in advance for your feedback; Jean

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,670 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Olaf Helper 44,296 Reputation points
    2024-02-07T10:02:01.05+00:00

    No, not supported, see https://learn.microsoft.com/en-us/sql/sql-server/editions-and-components-of-sql-server-2019?view=sql-server-ver16 "6 Standard edition supports basic availability groups. A basic availability group supports two replicas, with one database."


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.