Insufficient data from Andrew Fryer

The place where I page to when my brain is full up of stuff about the Microsoft platform

End of mainstream support for SQL Server 2000

End of mainstream support for SQL Server 2000

  • Comments 6
  • Likes

My first ever blog post was about the features of SQL Server 2000 that won’t work in SQL Server 2008, and as I have mentioned before,  SQL Server 2000 will come out of Mainstream support today!  What this means is that SQL Server 2000 will still be the subject of security fixes, and you can still get paid support for it, but other fixes will only be available if you take out extended support, which you have to pay for.

I know of several large organisations who will take out extended support and have planned for this.  However if you weren’t aware of this then all I can suggest is that you look to migrate as soon as possible and in the meantime consider taking out extended support in the meantime if your database is mission critical.

The key resources for upgrade have been the subject of several of my recent posts but too summarise:

  • Compatibility Mode enables SQL Server to emulate the functionality of an earlier release
  • Upgrade Advisor reports on what you need to do before and after an upgrade and can be downloaded here.
  • TechNet Forums will show allow you to see what issues others have come across and how these were resolved. The forum for SQL server install and upgrade is here
Technorati Tags: ,
Comments
  • The subject say it all, as of today the mainstream support for SQL Server 2000 (SP4) and SQL Server 2005

  • The subject say it all, as of today the mainstream support for SQL Server 2000 (SP4) and SQL Server 2005

  • Sad. SQL 2000 is a very good product. I find 2005 MGT studio to be clunky and very slow. And now they don't want to release an SP3 for all of the patches they have released on top of SP2. I have found SP2 to be very buggy.

  • Just curious!  Where in the subject did it mention SQL Server 2005?  -- My eyesight is not what it used to be!

  • Ron, I am puzzled; you're correct I didn't mention sql server 2005 in this post, but it isn't in my technorati tags or the categories either.

    Andrew

  • SQL Server 2005 SP1 is also out of mainstream support, if you see on my blog post you will get more information.

Your comment has been posted.   Close
Thank you, your comment requires moderation so it may take a while to appear.   Close
Leave a Comment