New changes for SQL Server High Availability and Disaster Recovery: Microsoft recently announced changes to the benefits available for organisations who purchase Software Assurance (SA) with their SQL Server licenses.
Organisations with SQL Server and SA coverage are now able to utilise up to two passive SQL Servers at no additional cost and therefore make significant, as well as cost effective, business continuity improvements to their critical database infrastructure.
Historically, the SA benefit allowed for just one passive SQL Server to be licensed at no additional cost for use in a High Availability scenario when licensing a primary server located on premises. Additional core licenses were required to license any extra servers required for Disaster Recovery, or for databases replicated to an Azure SQL VM. This posed a significant license cost for businesses that required low recovery time and recovery point objectives. For many organisations, the total cost of ownership (TCO) for SQL Server in this scenario is very high, especially when the passive instance may never be used. For this reason, many organisations rely on third party tools, hypervisor availability function, SAN replication or basic SQL Server technologies to provide a level of disaster recovery which may provide a very long recovery time and sub optimal recovery point objectives. For organisations who cannot afford the infrastructure investment to implement a second data centre, using Azure offers a cost-effective solution, but not when replicating SQL Server databases to an Azure SQL VM, where historically no passive license benefit was offered.
The following two diagrams show the old licensing rules which were required when licensing a typical on premises SQL configuration utilising one local and one remote replica, and the licenses required when replicating to an Azure SQL VM:
With the new SA improvements, Microsoft now allow up to two passive servers at no additional cost. Organisations are now free to implement a complete High Availability and Disaster Recovery architecture for their critical databases, without having to pay extra for the privilege.
With the option to replicate data to an Azure SQL VM, also at no additional license cost, the barrier to explore hybrid architectures has been removed.
The following two diagrams show the new SA benefit for the same architecture design highlighted earlier:
One additional benefit Microsoft have provided with this change is that it isn’t available just for the latest version of SQL Server. This SA Benefit improvement is retrospective to all supported versions of SQL Server meaning anyone running SQL Server 2012 and up can take advantage of these changes.
This SA Benefit change seems too good to be true, and it mostly is, however, to be fully compliant with these license changes there are several terms and conditions which must be adhered too.
With these new changes, there is now a cost-effective way to instantly improve the High Availability and Disaster Recovery capabilities of your SQL Server infrastructure, with little financial penalty. Ultima can assist your organisation with the ability to assess, design and implement the right solution for your requirements.
Ultima provides several Professional Services engagements to support your database business continuity needs:
Please speak with your Ultima Account Manager or contact us below if you would like to discuss any of these options further.