Home Forums SQL Server 2008 SQL Server 2008 - General Restoring SQL2008 Enterprise Edition db into SQL2008 Standard edition question RE: Restoring SQL2008 Enterprise Edition db into SQL2008 Standard edition question

  • October 16, 2012 at 5:54 am

    #1549492

    GilaMonster (10/16/2012)

    Markus (10/16/2012)

    If, any of those are in there can I restore this into SQL2008R2 Standard Edition?

    No, the restore will fail.

    The DMV to check is sys.dm_db_persistent_sku_features (or something like that)

    Thanks,.... I was afraid of that...

    I have fired off an email asking them to verify that they are not using any of those features. I guess I should have done a lookup on the MSFT website for editions comparision before I posted as all that information was there. The database is 270gig so there is a possibility that they are using partitioning.