Re: SQL Enterprise Eval => SQL Standard



Utahduck (Utahduck@xxxxxxxxxxx) 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@xxxxxxxxxxxxx

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
.



Relevant Pages

  • Re: [Sql Server 2008 RCO]Where is SSMS ?
    ... upgrading from CTP6 is supported, but there are many who have had problems ... There is absolutely no reason to uninstall anything of SQL 2005. ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (microsoft.public.sqlserver.tools)
  • Re: Class does not support aggregation
    ... attached it to the SQL Server 2005 Standard instance. ... select on tables in the database I have no problem. ... Microsoft SQL Server Management Studio ... Books Online for SQL Server 2005 at ...
    (comp.databases.ms-sqlserver)
  • Re: Move database from sqlexpress to sql standard -wss
    ... uninstalling the 2nd instance and upgrading the ... express to standard instead seems like the best option to me. ... Links for SQL Server Books Online: ...
    (microsoft.public.sqlserver.server)
  • Re: SQL Server 2005 Express to SQL Server 2005 Standard
    ... to SQL Server 2005 Standard? ... No need for data migration at all. ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (comp.databases.ms-sqlserver)
  • [newbie] Licensing and clustering
    ... I am currently thinking about upgrading one SQL Server to a 2 node cluster. ... Currently the server is running W2000 Server & SQL Server 2000 Standard ...
    (microsoft.public.windows.server.clustering)