March 16, 2022 at 3:46 pm
Hello,
We have installed Enterprise edition for SQL Serve cluster environment (Two node) based on client requirement. But, now client wanted to change the SQL server edition to Standard edition due to some licensing issue. Is there any option to downgrade SQL cluster from Enterprise to Standard edition or do i have to completely destroy the cluster and start all over again?
TIA.
March 16, 2022 at 6:03 pm
There is no way to do a downgrade to standard, you would have to do a complete uninstall and reinstall I’m afraid.
You may only upgrade
Dev -> Web -> Std -> Ent
March 16, 2022 at 6:37 pm
Actually, this can be done.
https://www.sqlskills.com/blogs/jonathan/downgrading-sql-server-editions/
I've used this method in the past successfully
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
March 16, 2022 at 7:00 pm
Well that’s still a uninstall reinstall it just saves having to script everything from master/msdb and having to replay it once the reinstall has completed.
March 16, 2022 at 7:08 pm
Correct. But depending upon the sizes of your databases, this can save an enormous amount of time.
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply