question

Tim avatar image
Tim asked

SQL 2000 End of Life 4/9 Who is still using it?

With SQL 2000 End of life nearing on April 9th, just 22 short days away, I was wondering who still has SQL 2000 in production. I for one have several instances active and in production with SQL 2000. All are third party applications that based on the version of the app we have installed does not support SQL 2005 or above. All of my SQL 2000 instances have a plan in place to be upgraded and or replaced within the next 6 months but I will still be past the point of support which makes me feel uncomfortable. Who else is in a similar situation and what are you planning to do to mitigate your risk such as only running it in a VM with a clone of the OS, or exception out the server from patching to eliminate risk of a change breaking it?
sql-server-2000end-of-life
1 comment
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Great question.
0 Likes 0 ·
raadee avatar image
raadee answered
I have a couple of customers that are stuck with SQL 2000 instances for business reasons. So our approach is: 1. Virtualize all the servers so that the hardware aspect is covered. 2. Create a up to date clone of the server/os. 3. Make sure that all dependencies for the databases/system are scripted or documented. 4. Create a recovery plan per database/system for the virtualized server/clone. 5. A "no touch" policy for the server, only patch if really necessary. 6. Charge the departments that "own" these databases/server appropriately for the "special treatment".
1 comment
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Good stuff.
1 Like 1 ·
ThomasRushton avatar image
ThomasRushton answered
*wave* Yup, I still have SQL2000 in production - SP3a and SP4. The joys of looking after legacy systems. What we're doing, though, is mothballing systems after migrating data out into the newish parent company.
2 comments
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

+1 purely out of sympathy
2 Likes 2 ·
So glad I got rid of my last one 4 years ago! Easy I guys when the devs are in-house!
0 Likes 0 ·
tanglesoft avatar image
tanglesoft answered
Moved as much as we could to SQL Server 2005/2008 and ran in compatibility mode which was fine for some applications such as Dynamics GP, FileNet or thick client VB apps. However other applications such as BizTalk, SharePoint or Dynamics CRM were not so we had to move 2000 eventually.
1 comment
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Ah, FileNet... there's a name from the past!
1 Like 1 ·
cowboy_coder avatar image
cowboy_coder answered
Can we just pay $1 million to get support from someone?
3 comments
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

You can also pay me 1 million to support it. :)
1 Like 1 ·
I would have to do both? B^)
1 Like 1 ·
You can sign a CSA with Microsoft, I believe those start around 1.2 million depending on the size of your organization and then pay per instance of SQL 2000 you want supported. I have heard that can range between 50-75k per instance. Again depends on the number of instances. I also believe the per instance support is an annual charge. You would have to confirm with your MS license guru.
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.