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

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

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass