BASIC Availability Group - License Concern

• PearlJammer1

  SSCrazy Eights

  Points: 8485

  More actions

  November 19, 2020 at 5:57 pm

  #3811660

  SQL2017  Standard Edition installed on 2 nodes with a Windows2016 cluster underneath. Node 1 has 10 databases each in their own Basic Availability Group (BAG).

  Node 2 has the non readable databases and replicas.

  If I failover Database1 from Node1 to Node2, this database becomes readable on Node2 but the other 9 remain databases still remain unreadable. Is this now ok from a licensing point of view?  (Node 1 now has 9 active databases and 1 non-readable database/Node2 has 1 active db and 9 non readable).I am presuming the answer is 100% yes as then what would be the point of BAGS if you are not allowed to make 1 database active on a secondary node?

• Site Owners

  SSC Guru

  Points: 80342

  More actions

  November 20, 2020 at 6:10 pm

  #3812101

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.

• sterling3721

  SSChasing Mays

  Points: 658

  More actions

  November 20, 2020 at 9:32 pm

  #3812158

  If you have X licenses(X is the number of cores) for one node and software assurance(SA) for the other node, OR

  X licenses for one node and another X licenses for the other node

  , you are fine.

  If you only have X licenses for one node, your 2-node cluster is not license compliant.

  Please check with your license vendor/Microsoft partner.