Search
InstantDoc ID
GO

Browse By: Author | Issue

December 23, 2008 06:23 PM

How to Upgrade to SQL Server 2008 from SQL Server 2000

Learn the prerequisites you’ll need, the steps you’ll take, and some possible gotchas.
Rating: (0)
Orin Thomas
SQL Server Magazine
InstantDoc ID #100820
Executive Summary: Businesses and organizations that still use Microsoft SQL Server 2000 will have to upgrade at some point. They can't put off the task indefinitely, either, because the next version of SQL Server probably won't support a direct upgrade from SQL Server 2000. SQL Server 2008 supports direct in-place upgrades from SQL Server 2000, letting those organizations leap-frog SQL Server 2005 and go directly to S...

...This article is for paid Professional Members only.

Already a Professional Member? Please log in now:

NOT A PROFESSIONAL MEMBER? YOU CHOOSE:

Professional Membership

Monthly

Annual

VIP Membership

Monthly

Annual

Compare Member Benefits

Add a Comment

Hi focasio!

I passed your question on to the article's author, Orin Thomas, to see if he knew if the 2008 installer leaves behind the SQL Server 2000 tools. Orin says "No, the tools appear to have been removed."

I hope this answered your question. Please let me know if you have any more questions.

Thanks for your great question!

Megan Keller

Associate Editor, SQL Server Magazine

mkeller@sqlmag.com

Megan8/31/2009 3:44:26 PM

For an In-Place upgrade from 2000, does the 2008 installer leave behind the SQL 2000 tools? This seems to be the case when an ugrade from 2005 to 2008 is performed. I have done upgrades from 2000 to 2005 and the installer removed all 2000 tools and programs. I have performed 5 upgrades from 2005 to 2008 and the 2005 Mgmt Tools, support files, etc are left behind by the 2008 upgrade. Needed to be removed manually. Just wondering if anyone has any experience with this from 2000 to 2008.
Thanks

Frank8/6/2009 6:39:40 PM

You must log on before posting a comment.

Are you a new visitor? Register Here

© 2010 Penton Media, Inc.

Windows is a trademark of the Microsoft group of companies. Windows IT Pro is used by Penton Media Inc. under license from owner.