Extended support for SQL Server 2008 ends on 9 July 2019, which means Microsoft will no longer release security updates for any version of SQL Server 2008 or 2008 R2. Organisations running either version after the support cut-off date will be risking broken systems and compromised data, and may be in breach of industry compliance regulations such as the recently introduced General Data Protection Regulation (GDPR). Article 5(1) of the GDPR states that for compliance, personal data shall be:
“(f) processed in a manner that ensures appropriate security of the personal data, including protection against unauthorised or unlawful processing and against accidental loss, destruction or damage, using appropriate technical or organisational measures (‘integrity and confidentiality’).”
Further, every application relying on the database will be at risk, so it is vital for the health and security of your systems to upgrade.
Whilst 13 months may seem a long way off, now is the time to budget and plan either an on-premises SQL Server upgrade or make the move to the cloud with Azure SQL Database. We are happy to discuss the options for your organisation with you.
Source: Microsoft (datasheet)