SQL 2005 trial version update

30 pts.
Tags:
SQL
SQL 2005
SQL 2008
SQL Server Enterprise Edition
SQL Server upgrades
I installed SQL 2005 trial version on a production server and the 6 months are almost up. I would like to go to SQL 2008 since I can get a very good deal for it. What options do I have? Can I just upgrade over the trial version or I need to uninstall 2005 and reinstall 2008. The 2005 is a trial for the Enterprise version and the 2008 is Standard. Would this be a problem? Are there any compatibility issues with this plan of moving to SQL 2008. Since it's a production server, I can't take any risks. Thank you for your help!
ASKED: November 7, 2008  7:13 PM
UPDATED: November 10, 2008  3:06 PM

Answer Wiki

Thanks. We'll let you know when a new response is added.

To perform an in-place upgrade of SQL 2005 Evaluation edition to other SQL Server full blown editions, simply run the setup and it will identify the existing installation, and will run an upgrade check. It will then let you know if the upgrade is possible or not. If the upgrade is possible, simply go through the setup wizard and it will automatically upgrade the already installed instance of evaluation edition.

Upgrading from Evaluation Edition 2005 after it has expired is a different story entirely

Now, this becomes a little tricky. You have to first uninstall SQL 2005 Eval edition and then install the full blown edition on the machine.

In case you want to keep the existing databases, you can use the SAVESYSDB parameter at command prompt. For more information on this, refer to KB 914158…

If You receive an error message when you try to upgrade an expired installation of SQL Server 2005 Evaluation Edition to a retail version of SQL Server 2005

his problem occurs because the Setup program cannot start the SQL Server service. When you install retail versions of SQL Server 2005, the Setup program tries to start the SQL Server service of the old installation of SQL Server 2005 Evaluation Edition. However, the service cannot start because the installation is expired. Therefore, the installation stops, and you receive the error messages.

WORKAROUND
To work around this problem, you must uninstall SQL Server 2005 Evaluation Edition. Then, install the retail version of SQL Server 2005. If you want to keep system databases and reuse the databases after a new installation, you can uninstall SQL Server 2005 at the command prompt by using the SAVESYSDB parameter. Then, install the retail version of SQL Server 2005 at the command prompt by using the USESYSDB parameter.

When SQL Server 2005 Evaluation Edition is expired, you cannot start the SQL Server service. If you want to move the user database to the retail version of SQL Server 2005, you can copy the user database files to a specified location. Then, you can attach the database to the retail version of SQL Server 2005.

For more information about how to install SQL Server 2005 at the command prompt, visit the following Microsoft Developer Network (MSDN) Web site:

http://msdn2.microsoft.com/en-us/library/ms144259.aspx

In case you are still running SQL 2000 Eval edition (I would doubt that), you can refer to KB 281574 for steps on how to upgrade the same to a full blown edition of SQL 2000.

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following