After a 10-year run, Microsoft has ended support for SQL Server 2008 R2 on the 9th July 2019, creating very real risks for compliance and protecting your critical data. While Microsoft has given organisations plenty of time and advice on how to prepare, finding a reliable solution that meets your business needs can be a challenging task.

With that in mind, now is the perfect time to look at your options and future proof your business by ensuring your vital data is held on a supported platform. Here are your options to consider as you prepare for SQL Server 2008 R2 End of Support (EOS).

 

Don’t do anything – Accept Significant Risks

Your first option is to choose to do nothing, however, this is probably the most risky position to take. Once critical security updates stop being applied to your database server, you are exposing your business to vulnerabilities that can be exploited by cyber criminals. Verizon has identified that database servers are the most susceptible assets to data breaches in their 2018 Data Breach Investigations Report.

Failing to have a secure environment for your data will also negatively impact your business’s compliance with industry regulations or your corporate compliance requirements. Worse, in the event of a breach, your company directors and officers are personally liable under Australia’s Data Breach legislation.

 

Purchase Extended Security Updates for up to 3 Years – Raising Costs Significantly

Microsoft has provided an option for businesses to purchase extended security updates for up to 3 years, to give businesses more time to plan their upgrade to a newer, supported version, of SQL Server. The extended security update comes at a significant cost to your business, which could be up to 75% of the full license fees and these charges need to be paid upfront.

While this option may not be the first choice for a business because of these associated costs, you will still need to secure your databases to continue your normal business operations. Purchasing the extended support does provide a way forward, at least for the next few years, to run your databases without the security risks – and protect your business.

 

Migrate to Microsoft Azure– Achieve Cost Savings and Better Performance

The third option is to migrate your databases to the Azure public cloud. Hosting your database on this platform is the most cost-effective option for your business because Azure offers free security updates to address your security needs and compliance requirements. Migrating to the cloud also opens opportunities to transform your business, with a flexible environment that can adapt to your changing needs, along with improving business performance.

Migrating production databases to Azure can sound daunting and resource intensive. While your internal DBA and operational resources might be tied up with the core business functions, a new database migration project does not have to be deprioritised. Highly skilled and experienced service providers can handle this migration for you, and free up your operational resources to focus on core business activities –  like keeping your business running.

 

 

If your organisation is considering a move to Microsoft Azure, Interactive can help. We have broad and deep expertise in the managed services area. Our services include:

CMS Discover – for a low-impact, automated review of your infrastructure and workloads.

CMS Migrate – for an automated lift & shift migration to Azure.

CMS Secure –  for a deep set of security services including advanced perimeter and host security, SIEM, 100% Australian-based Cyber Security Operations Centre to completely secure your new deployment on Azure.

Managed Azure Services – for managed services to suit every budget and continually optimise your new Azure deployment.

Database as a Service – for expert DBAs specialising in migration and management of Microsoft SQL databases on Azure.

We have over 30 years of data protection experience. We are a Microsoft Gold Partner and ISO 27001, ISO 9001 compliant.

Our Australia based customer service team and 24×365 Australian NOC are here to help you every step of the way: Learn more.

 

References:

2018 Data Breach Investigations Report, Verizon, https://www.documentwereld.nl/files/2018/Verizon-DBIR_2018-Main_report.pdf