August 13, 2014 at 5:15 pm
Hi ,
I want to downgrade SQL server 2008 enterprise edition to SQL server 2008 r2 standard edition, it will allow to work ? can you please help me on this.
August 14, 2014 at 1:05 am
Depends if your using any Enterprise edition features.
Check sys.dm_db_persisted_sku_features in all of your databases to see if your using anything which is Enterprise only.
You will then need to check what is in Enterprise vs Standard at the server and/or agent level that you may be using, like online index rebuilds etc which wont show up in the above DMV.
If you do use anything Enterprise only it needs to be removed before moving to standard.
August 14, 2014 at 2:33 am
naresh.talla (8/13/2014)
Hi ,I want to downgrade SQL server 2008 enterprise edition to SQL server 2008 r2 standard edition, it will allow to work ? can you please help me on this.
You will not be able to do this via the SQL Server setup it is an unsupported path. You would need to deploy a new instance at Standard edition and migrate between the 2. As Anthony has already pointed out you should ensure that no features are currently in use which could be lost as part of the migration
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 14, 2014 at 9:20 am
Or, you'll need to uninstall and then reinstall SQL Server. Not my preferred approach, but one that will work.
Be sure you have good backups in place before you do any of these things.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
August 14, 2014 at 9:25 am
Grant Fritchey (8/14/2014)
Be sure you have good backups in place before you do any of these things.
+1
There are plenty of ways to get the databases down to standard edition on a future version of SQL Server. All of them should start with a known good backup.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
August 18, 2014 at 5:52 am
no , not allow to work.
August 18, 2014 at 6:44 am
There's an article here that might be useful;
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply