question

GabriRomi-3998 avatar image
0 Votes"
GabriRomi-3998 asked ·

SQL Server Standard Edition 2019 Software Assurance

Hi,

activating a Server SQL Standard 2019 licence with Software Assurance package, is there a limitation on numbers of DB that i can put in HA or DR with passive replicas ?

Or i can implement the always on with the whole instance without limitation on number of DB ?


Many Thanks

sql-server-general
· 1
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi GabriRomi-3998,
Did the answers help you?
Please feel free to let us know if you have any other question.
If you find any post in the thread is helpful, you could kindly accept it as answer.
Best Regards,
Amelia

0 Votes 0 ·
Shashank-Singh avatar image
0 Votes"
Shashank-Singh answered ·

activating a Server SQL Standard 2019 licence with Software Assurance package, is there a limitation on numbers of DB that i can put in HA or DR with passive replicas ?

There is NO restriction on number of DB's you can put in any replica practically. You are ONLY limited by hardware in terms that if your hardware can support like 100 databases go ahead there is NO license violation. License is for SQL Server not for databases in AG.

Or i can implement the always on with the whole instance without limitation on number of DB ?

Yep go ahead.







·
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

AmeliaGu-msft avatar image
0 Votes"
AmeliaGu-msft answered ·

Hi GabriRomi-3998,
Software Assurance will not change any technical limitations of the standard edition.
Standard Edition only supports basic availability groups. A basic availability group supports two replicas, with one database.
Here are some limitations for basic availability groups:

  • Limit of two replicas (primary and secondary).

  • No read access on secondary replica.

  • No backups on secondary replica.

  • No integrity checks on secondary replicas.

  • No support for replicas hosted on servers running a version of SQL Server prior to SQL Server 2016 Community Technology Preview 3 (CTP3).

  • Support for one availability database.

  • Basic availability groups cannot be upgraded to advanced availability groups. The group must be dropped and re-added to a group that contains servers running only SQL Server 2016 Enterprise Edition.

  • Basic availability groups are only supported for Standard Edition servers.

  • Basic availability groups cannot be part of a distributed availability group.

  • You may have multiple Basic availability groups connected to a single instance of SQL Server.

In addition, on the Standard edition there is support for two nodes SQL Server FCI. And there is no special limit to the number of databases you can have on a Failover Cluster Instance (FCI) on Standard Edition.
Please refer to RDBMS high availability and Basic Always On availability groups which might help.
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.


·
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.