Posted by Erland Sommarskog on 05/02/07 21:40

Utahduck (Utahduck@hotmail.com) writes:
> We've got a SQL 2000 Server running the Enterprise 120-day trial.
> Normally you can retain the information by upgrading it to the full-
> blown version of Enterprise edition. However, we have decided to go
> with the Standard version instead. Will I need to BACKUP the data and
> do a complete install then RESTORE or can I "upgrade" it to Standard?

According to the topic "Upgrading an Existing Installation of SQL Server"
in Books Online, Evaluation to Standard is a supported upgrade. There is
a footnote, about an exception for failover clusters, but since you are
aiming for Standard, I guess that does not apply to you.

I'm a little curious, though, that in this day and age that you have
settled for SQL 2000 and not SQL 2005.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

• Next in forum: Re: Need to tune a table for performance gains
• Prev in forum: Re: INSERT - one record at a time
• Thread view: Re: SQL Enterprise Eval => SQL Standard

[Reply to this message]