Prepare for sql server

Prepare for SQL Server 2008 R2
End of Life Support Today

Prepare for SQL Server 2008

Sometimes in life we need an upgrade – it’s human to want the latest and greatest – and Microsoft is no exception. Their tried and true SQL Server 2008 / 2008 R2 has served its purpose and lasted an entire decade. It is time to move on – well, almost time to move. You have until July 9, 2019 before Microsoft no longer supports either version. Microsoft has described the potential options here and we’ll discuss below what your next best steps are as you prepare your organization for this change. Remember, October is National Cyber-Security Awareness month and vulnerable servers are never a good idea.

Why Should You Care?

Security and Non-Compliance: The first thing to realize is that yes, this is a serious implication for your business and you do need to take action to ensure your business is not left vulnerable to security threats. Unpatched servers are the number one risk to organizations today in regards to security. In 2017, the largest data breach recorded affected over 140 million users and was caused by an unpatched server.

What Are Your Options?

Luckily you do have options – there is no one size fits all and Microsoft has allowed for various scenarios depending on what is best for your business and its current and future state. SoftwareONE Microsoft Advisory Services is here to help you determine which scenario is best for you.


Many SQL 2008/2008R2 servers can be upgraded to the latest version – often times at no extra licensing cost via Software Assurance


Refactor or Rebuild your applications to leverage Platform as a Service (PaaS)

Migrate to Azure

This is the only option to allow an organization to maintain existing versions and editions without paying for extended support. Microsoft is extending SQL Server 2008/2008 R2 support through 2022 for servers migrated to Azure.

Pay Microsoft for Extended Support

Normally this is a last resort as the typical costs are exponentially higher than the other options listed above and can be short term focused.

Looking for Support on SQL Server and Windows Server 2008 / R2?

To learn more you can read our "The ultimate Guide to SQL 2008 End of Support" or talk to one of our MAS consultants directly.

Read "The ultimate Guide to SQL 2008 End of Support"
  • woensdag 10 oktober 2018

Reageer op dit artikel

Laat een reactie achter om ons te laten weten wat je van dit onderwerp vindt!

Laat een bericht achter


Dan Ortman, Author SoftwareONE Blog

Dan Ortman Microsoft Advisory Services Practice Lead

Publisher Advisory | Microsoft

Related Articles

Tech news

What’s been going on in the world of tech?

The tech world is such a rapidly developing field that it may sometimes be hard to stay up-to-date. With our monthly IT insights you won’t lose overview. Read about the latest vendor news and trending topics.

Adobe DC: New Features for Efficient Workflows and Mobile

Adobe DC: New Features for Efficient Workflows and Mobile

Adobe has used the 2019 Fall update to integrate a whole stack of new features in Acrobat and the Document Cloud. This article takes a closer look at the new features.

Azure Reserved

Achieve Full Cost Control with Azure Reserved Instance

Using Reserved Instances (RI) such as pre-reserved Azure VM instances can help you reduce the investments in the compute share of a virtual machine drastically. We show you how!