The first piece of good news is that there is still enough time to make all the important decisions and preparations. So there’s no need to panic – but neither should the issue be postponed indefinitely.
Essentially there are three options to deal with the end of support for Windows Server and SQL Server, and the following will introduce you to what they are:
- Upgrade the servers to the current version
- Buy the “Extended Security Updates”
- Migrate the servers to Azure
Solution #1: Upgrade the servers to the current version
Probably the most obvious thing to do is to upgrade the servers from 2008 to the latest – or at least a more recent – version. Besides the expenditure on actual migration, this may also involve incurring costs for a new license. But when buying their current license, many companies picked one with Software Assurance (SA) and therefore the right to receive the most recent version. In this case they would not have to pay extra for licenses.
Companies in this position would be advised to migrate to the latest version, for instance Windows Server 2019. Firstly this prevents them having to repeat the whole process just a few years later, and secondly the technological advances from 2008 to 2019 are immense. The following example illustrates wonderfully how much has happened in the last ten years: When Windows Server 2008 hit the markets, the first iPhone had only recently been released in Germany. And plenty has happened since then with SQL and Windows Server, not just on the smartphone sector.
Solution #2: Buy the “Extended Security Updates”
Of course there are scenarios in which this kind of migration is not doable, for instance if software is installed on the server that has certain technical dependencies which need a 2008 version. Microsoft caters to these cases with its paid “Extended Security Updates”.
The “Extended Security Updates” will be made available by Microsoft for the coming three years – but, as things stand, are only available to customers with an Enterprise Agreement (EA, EAS or SCE) who purchased their Windows Server or SQL Server with active Software Assurance or as a subscription. What’s more, the costs for Extended Security Updates are quite considerable and are quoted by Microsoft at 75% of the price for a fully licensed version of the latest Windows Server, i.e. SQL Server. Bear in mind, though, that the updates only need to be bought for the servers that actually need them. In addition, the updates are extended annually, so customers can gradually reduce the costs by implementing incremental migration.
It is not quite clear at present how the Extended Security Updates will be purchased. But they will be available no later than at the end of support for the specific server.
Solution #3: Migrate the servers to Azure
There is a third option for companies that would have difficulty migrating their servers and who are reluctant to fork out on the Extended Security Updates, although it is predicated on the ability to run the servers and their applications in a virtual environment: Migrating the servers to Azure.
In keeping with the general focus on cloud topics, Microsoft is also offering the option of receiving the aforementioned Extended Security Updates free of charge if the customers migrate their 2008 or 2008 R2 versions of SQL Server and Windows Server to virtual machines mounted on Azure.
The first thing that’s needed is, of course, an Azure environment. Azure can be purchased in many different ways, and it comes with application scenarios that go beyond simply hosting virtual machines. For example, an SQL Server in Azure can be operated as a “database as a service”, in which patches or availability are assured automatically. Our experts would also be available to you for technical migration to the cloud, backing up your Azure environment and managing the costs.
There’s also some good news for customers that have active Software Assurance for their SQL Server and Windows Server. They receive a hybrid use benefit and can save almost 80% of the costs for their virtual machines.