Dear team,
I have below VMware Infra VM in our environment.
vCenter Server
MSSQL(Database Server)
SSO
Inventory Server.
On MSSQL server currently we have MSSQL2012 Enterprise Edition is installed, Now Company wants to degrade SQL version to Standard.
For that I need ur asisstance, how to plan sucessfully downgrade activity.
Regards
Mr VMware
I have never tried this but found one blog on this :Downgrade from SQL Server Enterprise Edition to Standard Edition
Dear Team,
I have created below POA for said activity, just want to confirm below POA is correct or if some point is missing please add the same.
Stop VC Server service
Stop SSO service
Take VC DB backup and save it on network drive
Take RSA DB backup and save it on network drive
Take SQL server snapshot
Uninstall MSSQL Enterprise edition
Reboot the server
Install MSSQL STD edition
Restore VC DB and RSA DB
Start VC server service
Start SSO service
Try to connect VC
Check historical data (Performance / Task / Events)
Do let me know if any step is missing so that i will schedule this activity ASAP.
regards
Mr Vmware
Overall plan looks good to me. I hope you have refereed above blog post on this.
While restarting you may have to start SSO service first and then VC.