One of the most popular software assurance benefits for SQL Server customers is the ability to deploy SQL Server High Availability and Disaster Recovery architectures with the best TCO. Starting Nove...
Updated Sep 25, 2020
Version 4.0
Blog Post
Glad I found these videos! Really appreciate you creating and posting them, as they go a long way in helping understand the SQL licensing rules around HADR! I do want to confirm however, as going through various points of reference around Standard vs Enterprise editions, has left me wondering and am hoping you can clarify!
I currently have a Primary instance of Standard SQL 2019 w/SA, running in a VM with 4 cores assigned to it. I have licensed all 4-cores (with dual 2-core packs). Within this instance I have 8 individual databases.
My first question is... with the new HADR benefits that you've described in the videos above... does it pertain to this instance with all 8 individual databases, or is there a limit to how many databases are supported under a Standard Edition (w/SA) Instance?
Second question is... understanding that we can have 3 PASSIVE secondary's (for HA, DR and DRinAz)... do the secondary's need Windows Server licenses, or does Mobility licensing come into play, since these are not active OSEs?
Thanks!