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.
| 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 MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
 |
|
|
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. |
|
|
|
|
|
|
Changing Server from Enterprise to Standard