Article ID: 314947 - Last Review: June 23, 2003 - Revision: 2.2

INF: How to Upgrade Virtual Servers from SQL Server 2000 Enterprise Evaluation Edition to SQL Server 2000 Enterprise Edition

View products that this article applies to.

This article was previously published under Q314947

SUMMARY

This article describes how to upgrade SQL Server virtual servers from SQL Server 2000 Enterprise Evaluation Edition to SQL Server 2000 Enterprise Edition without losing the data that is stored in the databases of SQL Server 2000 Enterprise Evaluation Edition.

Note You can also follow the steps in the "More Information" section of this article to upgrade your virtual servers to SQL Server 2000 Enterprise Edition before your evaluation period expires.

Back to the top

MORE INFORMATION

After the 120-day evaluation period expires, SQL Server 2000 may not start. You may receive the following error message in the Event log:

SQL Server evaluation period has expired.

If you want to continue using the product after this period, purchase and install the licensed version of Enterprise Edition SQL Server 2000 as the virtual server.

After you purchase a license for SQL Server 2000, you cannot upgrade your virtual servers by running SQL Server 2000 Setup. To upgrade your virtual servers from SQL Server 2000 Enterprise Evaluation Edition to SQL Server 2000 Enterprise Edition, follow these steps:

Stop the SQL Server services.
Copy all the database files (.mdf, .ndf, and .ldf) from the default SQL Server data folder and any other data files that are used by SQL Server to a temporary location.

Note Make sure that you also copy all the database files of master databases and the other system and required databases.
In Control Panel, use Add/Remove Programs to remove SQL Server 2000 Enterprise Evaluation Edition.
Install SQL Server 2000 Enterprise Edition as a virtual server.

Note During installation, make sure that you use the data folder that you used when you installed SQL Server 2000 Enterprise Evaluation Edition.
After the installation is complete, copy all the database files from the temporary location to the SQL Server data folder.

Note If your instance of SQL Server is running, take the instance of SQL Server offline from Cluster Administrator before you copy the data files.

Back to the top

REFERENCES

For additional information about how to upgrade your stand-alone servers to SQL Server 2000 Enterprise Edition, click the following article number to view the article in the Microsoft Knowledge Base:

281574 (http://support.microsoft.com/kb/281574/EN-US/ ) INF: How to Upgrade to SQL Server 2000 Retail Version After SQL Server 2000 Evaluation Edition Expires

For additional information about SQL Server 2000 Setup, click the following article number to view the article in the Microsoft Knowledge Base:

257716 (http://support.microsoft.com/kb/257716/EN-US/ ) INF: Frequently Asked Questions - SQL Server 2000 - Setup

For additional information about how to upgrade SQL Server 7.0 Evaluation Edition, click the following article number to view the article in the Microsoft Knowledge Base:

237303 (http://support.microsoft.com/kb/237303/EN-US/ ) INF: How to Upgrade SQL Server 7.0 Evaluation Edition to Retail Version

Back to the top