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.

Upgrade

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

Transform

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"
  • Wednesday 10 October 2018

Comment on this article

Leave a comment to let us know what you think about this topic!

Leave a comment

Author

Dan Ortman, Author SoftwareONE Blog

Dan Ortman Microsoft Advisory Services Practice Lead

Publisher Advisory | Microsoft

Related Articles

softwareONE-lifeHacks

SoftwareONE LifeHacks: Easily Create Surveys with Quick Poll Add-In

Although it has always been possible to create polls in Outlook, many users have preferred to draw on third-party solutions like Doodle & co. Now, a new Microsoft Add-In for Outlook is improving the obsolete poll function.

windows-7

Answering the Biggest Questions About Windows 7 End of Service

Windows 7 end of service in January 2020 will impact millions of users. Find out answers to commonly asked questions about Windows 7 end of service.

SQL 2008 end of support

Top Considerations When Building Your Roadmap for SQL Server 2008 End of Support

SQL Server 2008’s end of support disrupted many organizations. Learn how to proceed with your upgrade process by building a comprehensive SQL EoS roadmap.