May 25, 2016 at 6:26 am
I have 2 SQL server instances that needs to be downgraded from SQL 2014 Enterprise to SQL 2014 Standard.
on one of the instances, there is Integration Catalog db enabled (SSISDB) and other instance is configured as a report server. (reportserver/reportservertemp dbs, no user dbs).
What steps should I take to downgrade these systems?
Many thanks!
May 25, 2016 at 3:21 pm
Pretty sure there is not a "downgrade edition" option in setup only an "upgrade edition" one. You could possibly do a side by side migration and restore the databases to the standard edition. That's probably not the answer you want to hear as it of course would require some down time.
May 26, 2016 at 3:37 am
edited - read the Q wrong 😀
May 26, 2016 at 3:53 am
Yes, you need to reinstall as Standard (or build a new server and install on there) and then restore the databases on it, including the system databases. First, though, check that you're not using any features that are only supported in Enterprise. If, for example, you restore a database with partitioned tables on Standard Edition, you won't be able to recover that database.
John
May 26, 2016 at 6:48 am
John Mitchell-245523 (5/26/2016)
Yes, you need to reinstall as Standard (or build a new server and install on there) and then restore the databases on it, including the system databases. First, though, check that you're not using any features that are only supported in Enterprise. If, for example, you restore a database with partitioned tables on Standard Edition, you won't be able to recover that database.John
You can check if you are likely to bump into this problem by looking at the dm_db_persisted_sku_features DMV
Thomas Rushton
blog: https://thelonedba.wordpress.com
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply