Downgrade SQL2K Enterprise to SQL2K Standard

Is it possible to downgrade SQL from Enterprise to Standard Edition, or do you have to remove the previous installation (uninstall) and reinstall. Meaning you would also have to restore all user databases? Thanks.

No. Downgrading from SQL Enterprise edition to Standard edition is not supported.

But if you also have licsense and media of SQL Standard edition and your machine has enough resources such as free disk space, you can install SQL Standard edition side by side with Enterprise Edition, which is supported. Then you can transfer data from Enterprise edition to Standard edition. At the end, you can uninstall Enterprise edition if necessary.

sql