Freigeben über

End of mainstream support for SQL Server 2000

  • Artikel

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: SQL Server 2000,support

Comments

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

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

  • Anonymous
    April 14, 2008
    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.

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

  • Anonymous
    April 14, 2008
    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

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