Post reply

Downgrading from Ent to Std

  • August 6, 2012 at 9:42 am

    #265321

    Hi all

    I was wondering if there was any decent articles on downgrading a SQL server from Ent to Std and what pit falls to be aware of.

    Also how can I check if my existing server is using any Enterprise only features?

    Thanks

  • August 6, 2012 at 11:56 am

    #1522210

    Well, I would reccomend the following steps:

    1.) Detach all existing databases, making a note of the physical file locations of all MDF, NDF, LDF & FilesStream objects.

    2.) Uninstall SQL Enterprise.

    3.) Reboot Server.

    4.) Install SQL Standard.

    5.) Attach all the databases.

    That way takes some work, but you will know it's done right.

  • August 6, 2012 at 1:25 pm

    #1522267

    There is no direct downgrade from 2008 Enterprise Edition to Standard Edition, so you would have to do one of the following:

    Setup a new server running Standard Edition, and migrate to that.

    Uninstall Enterprise Edition on the current server and install Standard Edition.

  • August 6, 2012 at 1:44 pm

    #1522278

    Thanks for the replies - fair enough a bit of work required but should be ok. What is the best way to determine if the existing SQL Server is using any Enterprise only functions?

  • August 7, 2012 at 3:15 am

    #1522450

    Query sys.dm_db_persisted_sku_features in each database, it will tell you what Enterprise features are being used.

  • August 7, 2012 at 3:55 am

    #1522466

    Hi and thanks. Unfortunately I am using SQL 2005 and this view doesn't seem to be supported grr...

  • August 7, 2012 at 4:08 am

    #1522476

    Ah, you posted in the 2008 forum, so you got a 2008 answer.

    I'm not aware of a 2005 equivilant, but you might find it on google or another search engine of your choice.

  • August 7, 2012 at 4:23 am

    #1522484

    So I did, google not my friend today am afraid.

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

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