March 1, 2005 at 2:45 pm
I have a SQL Server box running Windows 2000 Advanced Server sp4 with SQL Server 2000 Standard Edition. Can I upgrade to Enterprise Edition directly ? or do I have to unsinstall the Std. Edition and reinstall Ent. Edition ? Please help...Thanks.
-Jimmy
March 2, 2005 at 12:38 am
In theory you could upgrade.
Don't forget to make logins script and backups of your DBs in case of a some misunderstanding
March 2, 2005 at 2:28 am
Upgrade path is very simple. I did this on 8 production servers - with a reboot (not required - biut I did just to make sure) and then reapplied SP3a and reboot (just to be sure).
March 3, 2005 at 7:38 am
Thank you so much for the reply.
Athur, after your upgrade, did you have any problem with logins ?
Thanks again,
Jimmy
September 20, 2006 at 11:26 pm
I did upgrade to enterprise edition on a server, the setup has an upgrade option. Now I am trying to do the same upgrade on another server but the upgrade option is grayed out? Any info on this would be highly appreciated. Its win2k3 - sql2k standard sp4. My SQL Setup cd will drop it back to sp2 so I planed to apply sp4 after update. Now I am thinking I need a setup cd that installs to sp4 level for the upgrade option to be available.
October 18, 2006 at 7:59 am
We're going to upgrade our production box from Standard to Enterprise as well. If anyone has any suggestions or "gotchas" to pass along, that would be much appreciated.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply