November 19, 2020 at 5:57 pm
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?
November 20, 2020 at 6:10 pm
Thanks for posting your issue and hopefully someone will answer soon.
This is an automated bump to increase visibility of your question.
November 20, 2020 at 9:32 pm
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.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply