Post reply

restore 2012 Enterprise onto 2012 Standard

  • April 5, 2017 at 8:11 am

    #320219

    hello,

    we have a 2012 SP1 Ent server with no partitioning currently configured. We also have a 2016 SP1 server which can run simple partitioning.

    is there the ability to restore a 2012 Ent database using simple partitioning onto a 2016 SP1 which can accept simple partitioning? i know the mechanisms may be different...hence the question!

    thanks

  • April 5, 2017 at 8:41 am

    #1936818

    Hi,

    You can execute this SQL on the enterprise box to see if any enterprise features are being used;

    select * from sys.dm_db_persisted_sku_features

    If it doesn't return anything, then as far as I am aware you can backup the db from the enterprise edition and restore to standard. Not that I have tried.
    Note this is the case for any of the enterprise features being used not just partitioning as in your case. The restore will fail at the final step. Which, if its a large database, is a long to wait to find out it's not going to work.

    Rodney

  • April 5, 2017 at 10:02 am

    #1936846

    The partitioning mechanisms are largely the same. As Rod suggested, check the dmv to ensure no other enterprise feature is in use prior to attempting the restore.

    Here are the features that could show in that DMV.

    https://docs.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-db-persisted-sku-features-transact-sql

    • ChangeCapture. - available in 2016 standard sp1
    • ColumnStoreIndex. - available in 2016 standard sp1
    • Compression. - available in 2016 standard sp1
    • InMemoryOLTP. - available in 2016 standard sp1
    • Partitioning.  - available in 2016 standard sp1
    • TransparentDataEncryption.  enterprise only

    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

  • April 5, 2017 at 10:42 am

    #1936856

    ok thank you - was hoping to use simple partitioning on 2012 ent and restore to 2016 std....will add the partitioning to test db and see what it looks like in the dmv

    thanks

Viewing 4 posts - 1 through 4 (of 4 total)

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