0

For setting up Always On Availability Groups in SQL Server I know you need to have at least Enterprise Edition for SQL Server 2012, 2014, or 2016.

Do you also need the Datacenter or Enterprise Edition of Windows Server 2012 or 2016 for Always on, or can you set this up properly on Windows Server Standard 2012 or 2016?

  • Just to add starting from SQL Server 2016 we have Basic Availability Group in standard edition which is trimmed version of availability groups. – Shanky Aug 24 '18 at 8:02
2

Do you also need the Datacenter or Enterprise Edition of Windows Server 2012 or 2016 for Always on, or can you set this up properly on Windows Server Standard 2012 or 2016?

Windows Server Standard Edition is fine.

Starting with Windows Server 2012 every feature of Windows Server is available in Standard Edition. In particular Standard Edition supports Windows Server Failover Clustering which is needed for some Always On capabilities.

  • We plan to use Windows Server Failover Clustering (WSFC) so we don't need to setup shared storage instead of Failover Cluster Instances (FCI), Given this scenario I believe Windows Server Standard would serve our needs. If you say that every feature of Windows Server is available in Standard Edition, what makes Windows Server Datacenter any different than Windows Server Standard and when would you need Windows Server Datacenter Edition instead of Windows Server Standard edition? – equipe9 Aug 23 '18 at 23:55
  • When you license a server with Windows Server Datacenter Edition you can run Windows in any number of VMs on that server. – David Browne - Microsoft Aug 24 '18 at 0:18

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.