Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
pauldavis
Starting Member
1 Post |
 Posted - 2004-12-07 : 04:39:55
|
| I have read in many places that I can upgrade from SQL 2000 standard edition -> Enterprise Edition, but if I have installed the enterprise edition on a server where I intended to use the standard edition, is there a simple way of changing the installaton so that it runs as the standard edition? As I understand the situation, I would have to backup msdb, detatch all my databases, backup master, move the files somewhere safe, uninstall SQL 2000, then do a fresh install of the standard edition, run the service packs, restore master, attatch the databases again, and then restore msdb. To be honest the thought of doing that of 20 servers over a couple of weekends doe not fill me with joy, so and ideas on how I can downgrade my servers would be very much appreciated. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-12-07 : 13:19:24
|
| You can not downgrade without uninstalling and reinstalling. I am pretty sure you can't upgrade the version either. You'd have to follow the same process to move up an edition.Tara |
 |
|
|
brandonl
Yak Posting Veteran
58 Posts |
Posted - 2004-12-07 : 13:51:18
|
quote:
Originally posted by tdugganI am pretty sure you can't upgrade the version either. You'd have to follow the same process to move up an edition.
According to MS, 2000 Std. to 2000 Ent. is a supported upgrade path. I am going to be doing that in the next few months, so we'll see if it's just MS propaganda  ~BrandonL |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-12-07 : 13:56:12
|
| [EDIT] Nevermind. I see you can do it via setup. I didn't know that. [/EDIT]Tara |
|
|
|
|
|
|
|
|
Changing Editions of SQL Server 2000