News & Events

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.

Get in touch

For more information or to schedule a demo please contact us

Contact us

News

DSP winners at the UK Oracle User Group Awards 2017/18

DSP attended the UK Oracle User Group Partner of the Year Awards last week, and we came away with awards for both categories in which we were nominated

Read more
View All

Event

"Self Managing Databases: Fable, Fantasy or the Future"

Join us for lunch and to hear some war stories from staff and customers with experience of Oracle Database Cloud Service. We'll also understand more about the Autonomous Database and how Oracle will compete with AWS.

Read more
View All

Blog

How to choose the right MSP for Your Business

How has the role of an MSP changed in the past decade, and what should your selection criteria be for choosing an MSP to work with your business?

Read more
View All