As of April 12, 2016, extended support on MSSQL 2005 has ended. This date has long been indicated by Microsoft and MSSQL 2005 is now officially a thing of the past.
The end of extended support does not mean that the software no longer works, or that the licenses have expired. Your database will continue to work. It only indicates that you cannot fall back on the Microsoft for any software problems. Any (security) issue that is still discovered will not be solved, but will be dismissed with “MSSQL 2005 is out of support, you will have to upgrade”. There are now reports on the internet that this is indeed the attitude of Microsoft.
From an operational point of view this is possible, but keep in mind the following:
In short: you run a potential risk if you continue to work with this version.
Before you upgrade your environment, a number of factors should be taken into account:
This depends, among other things, on which choices you make. However, there are a number of factors that influence and that you should take into account:
It is clear that you have to make choices and that these choices have consequences. Are you not yet sure which choice to make or do you want to spar with a specialist about which choice to make?
Call DBA.nl !
We would be happy to discuss with you to find a suitable solution.
DBA.nl is the all-round database expert specialized in setting up, maintaining and monitoring database environments. In addition, we provide advice and remove performance problems.
Since last June, we have switched to a working method based on customer teams within DBA.nl....
DBA.nl has launched a new service management system. The choice fell on Topdesk....
DBA.nl, the database experts, may continue to manage the database environment of RID de Liemers....