question

jfkilleen avatar image
jfkilleen asked

Availability Groups - Licensing question for Passive Secondary.

Hi

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

John

availability-groups
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

· Write an Answer
Kev Riley avatar image
Kev Riley answered

As soon as an AG becomes primary on the secondary server, it needs to be licensed.

Yes, SA gives the ability to have passive secondary servers for HA or DR for free, the operative word there being 'passive'. If you have AGs mixed across servers, then those servers are no longer purely passive for HA or DR, you are effectively scaling-out.

The SA benefit is the free license for 1 on-prem HA, 1 on-prem DR and 1 Azure DR.

Without SA, you need to pay for those

https://cloudblogs.microsoft.com/sqlserver/2019/10/30/new-high-availability-and-disaster-recovery-benefits-for-sql-server/

10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.