SQL Server 2014: Standby Servers Require Software Assurance

With the release of SQL Server 2014 one of the first questions that come to mind is licensing. Rather than trying to tackle the whole subject in one go we’ve decided to highlight one of the key changes, which focuses around Enterprise Edition.

Prior to SQL Server 2014, many organisations were able to deploy a single standby server without licensing SQL Server. Log shipping, mirroring, and even failover clustering was allowed for an unlicensed passive node, provided that the passive node didn’t become the primary for more than 28 days. That’s now gone.

If you want to have a standby node, you have to buy software assurance. Read the SQL Server 2014 Licensing Datasheet and at the bottom of page three, it reads “Beginning with SQL Server 2014, each active server licensed with SA coverage allows the installation of a single passive server used for fail-over support.” The passive secondary server doesn’t need to have a complete SQL Server license, but you must have Software Assurance.

In short, Software Assurance (SA) is a yearly fee that customers pay to get access to the latest and greatest versions of products as well as unlock additional features that may have complex deployment scenarios.

Topics: Microsoft


Recent Posts

How Twitter Experienced the 2018 Champions League Final

read more

Why should you outsource your SQL Server DBA duties?

read more

Project Harar Fundraising

read more

Contact us today

 

 

Database Managed Services