SQL Server Performance Forum – Threads Archive

Revert Enterprise Edition to Standard Edition

Thanks for the answers to my question concerning running Enterprise and Standard Editions on the same box. Another question in the same vein. Can I "convert" an existing Enterprise Edition instance into a Standard Edition instance just by using the Standard Edition cd and doing an reinstall of the instance? It would not be too hard to backup the dbs, uninstall and reinstall the instance, and then restore the dbs but it would be less trouble to just do it "in place". Thanks again,
HW

As far I now, no.
You have to uninstall EE first.
Luis Martin
Moderator
SQL-Server-Performance.com One of the symptoms of an approaching nervous breakdown is the belief that one’s work is terribly important
Bertrand Russell
All postings are provided â€œAS ISâ€ with no warranties for accuracy.

I have come accross same situation to the cost-cutting on one environment. But couldn’t get any easy solution to do this. What I have done was; done complete backup of of users and system databases and uninstall SQL2KEE and Installed SQL2ESE. While doing this, make sure the Service Packs should be similary in both version. Other wise while restore master and msdb restoration, it gave me errors till I do that. -Johnson

If you want the standard edition to be a default one as the Enterprise Edition one, then you must uninstall EE and then reinstall SE, otherwise install SE as named instance and use BACKUp/RESTORE method and transfer logins too. KBAs and article to deal with databases & user logins:
http://support.microsoft.com/default.aspx?scid=kb;en-us;224071
http://support.microsoft.com/?id=314546
http://vyaskn.tripod.com/troubleshooting_orphan_users.htm HTH Satya SKJ
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

]]>