I understand that Enterprise with SA allows for a passive secondary server which does not require a license.
However If I have multiple Availability Groups on an instance, or multiple instances on a VM each its own AG and I have to failover just 1 AG, does the Secondary server need to be Licensed as there are now active databases on both servers as all other AGs are still on the 'primary'?
Hope that makes sense. I cant seem to find a definitive yes or no. I am thinking that the secondary does need to be licensed in this case which would render that feature of SA fairly useless for a lot of companies.
Thanks in advance