Manage Learn to apply best practices and optimize your operations.

Upgrading SQL Server 2000 Standard Edition to Enterprise Edition

Is there a white paper or resource on how to upgrade from SQL Server 2000 Standard Edition to SQL Server Enterprise Edition?
Yes, there are several good resources. You should first get familiar with the Microsoft's advance Knowledge Base search engine. This exposes all of Microsoft's internal information about SQL Server to you. It allows you to drill down to specific Knowledge Base articles (sometimes called Q articles) with information about specific issues with almost every Microsoft product. For example, a search on "Upgrade Enterprise Edition" yields a large variety of hits including:

Installation order for SQL Server 2000 Enterprise Edition on Microsoft Cluster Server

Effects of moving a database from SQL 2000 Enterprise Edition to SQL 2000 Standard Edition

However, I've had a bit of experience upgrading from Standard Edition (SE) to Enterprise Edition (EE) and it's really easier than these documents make it seem. Assuming that you're installing EE on the same server as SE, I would detach the current user databases using sp_detach_db procedure. Take down SE, install and bring up EE. Then, reattach the user databases using sp_attach_dp procedure. You should be good to go!


Do you have comments on this Ask the Expert Q&A? Let us know.


Dig Deeper on Microsoft SQL Server Installation

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.