Going From SQL Enterprise to SQL Standard

We mistakenly installed SQL Enterprise on a production server, and it should've been SQL Standard. How can we go from Enterprise to Standard? Will we have to move the database to a different SQL server, then uninstall SQL Enterprise and install SQL Standard? Or, is there an easier way?Hi,
I feel that we can not come down from Enterprise to Standard, but the other
way is possible.
I think you may need to Reinstall standard edition and copy back the
databases. Please wait for 2 more days till all our experts confirm the
possibilities.
Incase if you need to reinstall then,
As a precausion take a backup of all databases
do
1. Stop current sql server service
2. Copy all mdf and ldf to a safe folder
3. Uninstall SQL server EE
4. nstall SQL server Standard and SP3a with same folder structure as old
5. Copy back the mdf and ldf files to same folders as old
6. start sql server.
Mostly the sql server will be up will all the databases, if not use the
backup files we backup to restore each databases.
Thanks
Hari
MCDBA
Thanks
Hri
MCDBA
"Mickey" <mmorris@.tacenergy.com> wrote in message
news:FFF4D5BD-1569-4FEB-988C-D2D9820E78AD@.microsoft.com...
> We mistakenly installed SQL Enterprise on a production server, and it
should've been SQL Standard. How can we go from Enterprise to Standard?
Will we have to move the database to a different SQL server, then uninstall
SQL Enterprise and install SQL Standard? Or, is there an easier way?