SQL server Downgrad

  • 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.

  • 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.

  • 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" 😉

  • 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

  • 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

  • no , not allow to work.

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply