Say Goodbye to SQL Server 2008 & 2008 R2 as Microsoft Drops Support for it
Warning! If your organization is using Microsoft SQL Server 2008 R2, then you have entered into the Microsoft world of ‘End of Extended Support’. Actually, SQL Server 2008 and 2008 R2 are in the extended support phase of their life cycle. What does this term mean for enterprises using SQL Server 2008 R2? Keep reading this article to know more.
Recently, Microsoft announced SQL Server 2008 R2 extended support will end on July 9th ,2019. It means Microsoft will not accept requests for warranty, its change system support, changes in design, or new features during extended support phase. In short, no security updates for any version of SQL Server 2008 or R2 will be released.
The mainstream support was already ended for SQL Server 2008 and SQL Server 2008 R2. Adding to it, Windows Server 2008 and 2008 R2 will be no longer supported by Microsoft on Jan, 2020. Although, extended support will continue for a while, so it is the right time to take steps to upgrade the SQL Server 2008 version for high protection and risk management.
In this post, readers will learn the planning required for a successful migration to a new version of SQL Server and Windows Server. Well, before we delve into the migration plan for SQL Server 2008 and R2, let’s have a brief idea what actually ‘End of Extended Support’ is!
Every single product has its own life cycle. Extended Support is the last phase of any product life span. When an extended support ends, there will be no new features and security updates provided to that product.
As a result, the organization body that still using SQL Server 2008 after the end of support will have a great risk for its data. Because cyber attacks become more active on unsupported versions that have a great risk on security and compliance. Therefore, it is highly recommended to the customers either they upgrade to a newer version of SQL Server or move to different platforms for better performance and high security.
Here, users will know the pros as well as the cons of SQL Server 2008/2008 R2 end of support;
Benefits of Upgrading MS SQL Server 2008 and 2008 R2
Drawbacks of Not Upgrading SQL Server 2008
Microsoft offers extended security updates options for the users who need more time for the migration. This option will help the users to manage their database for three more years after the end of support deadline.
Depending on the requirement ,you have three migration options for the users who are using SQL Server 2008 and SQL Server 2008 R2.
Coming July 2019, extended support for Microsoft SQL Server 2008 and 2008R2 will end by the Microsoft. Hence, new security updates, features and many more will no longer be provided by SQL Server 2008 or 2008 R2. So, it is important for the organizations to prepare for the migration otherwise the sensitive data could be at risk.