Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 Changing Server from Enterprise to Standard

Author  Topic 

jbates99
Constraint Violating Yak Guru

396 Posts

Posted - 2013-10-13 : 23:16:16
I have been asked if we can switch some of our database server from MSSQL 2008 R2 Enterprise license to Standard. We do have some that are lightly used and can likely perform ok with Standard if I find we're not using any advanced features that are only available in Enterprise.

When switching editions I assume I would have to uninstall the Enterprise instance and reinstall a Standard instance. There is no way to configure an Enterprise instance to run as Standard, is that correct?

I would appreciate feedback from anyone who has "downgraded" a license.
Thank you. Jack

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-10-14 : 01:47:13
yep..you need to uninstall enterprise edition and install standard edition again. you need to take detach dbs before and store mdf,ndf,ldf files somewhere. After installing reattach them back. Be aware that there would be downtime for the clients accessing dbs until it becomes available again.

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page

jbates99
Constraint Violating Yak Guru

396 Posts

Posted - 2013-10-14 : 15:28:26
Thanks visakh16. Yes I'm aware of how to save the databases. Whew! Lots of work but we can save several thousands of dollars.
Go to Top of Page
   

- Advertisement -