sql2k standard to enterprise edition

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Mecn - 16 May 2008 20:40 GMT

Hi,

any step by step procedures that lead me to upgrade sp2k sp4 standard
edition to sql2k enterprise edition without prod databases retoring...

thanks,

Reply to this Message

Erland Sommarskog - 16 May 2008 21:23 GMT

> any step by step procedures that lead me to upgrade sp2k sp4 standard
> edition to sql2k enterprise edition without prod databases retoring...

Essentially, run SQL Server Setup from the CD, run, and reapply the service
pack and you're done.

For step-by-step procedures, see Books Online, Installing SQL Server->
Overview of Installing SQL Server->Upgrade an Existing Installation of
SQL Server.

Signature

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

Reply to this Message

Mecn - 16 May 2008 21:55 GMT

Thanks for reply. We have prod dbs there in sql2k sp4 standard edition.
After I done with upgrade as you mentioned, my prod dbs would be OK?

thanks

>> any step by step procedures that lead me to upgrade sp2k sp4 standard
>> edition to sql2k enterprise edition without prod databases retoring...
[quoted text clipped - 6 lines]
> Overview of Installing SQL Server->Upgrade an Existing Installation of
> SQL Server.

Reply to this Message

Erland Sommarskog - 16 May 2008 22:33 GMT

> Thanks for reply. We have prod dbs there in sql2k sp4 standard edition.
> After I done with upgrade as you mentioned, my prod dbs would be OK?

Yes. But by all means, try it out on a test machine first, so that you
are comfortable with the procedure.

Signature

Reply to this Message