Blitz Result: Enterprise Edition Features in Use

If you try to restore an Enterprise Edition database onto a Standard Edition server, the restore will chug right along until the very last step – bringing the database online.  At that time, SQL Server checks to see whether any Enterprise Edition features are in use.  If so, SQL Server just won’t let you bring the database online.  No, you can’t even get it online just long enough to rip out those features.

This part of our SQL Server sp_Blitz script checks the sys.dm_db_persisted_sku_features DMV in each user database and reports back which EE features are in use – like compression, partitioning, or Transparent Data Encryption (TDE).

To Fix the Problem

If you’ve got Standard Edition servers in your environment, be aware that you won’t be able to restore these databases onto those Standard Edition servers.  This is especially important in disaster recovery (DR) environments that might have been accidentally installed as Standard Edition.

This changes for some features with SQL Server 2016 SP1, where many Enterprise Edition features became available to Standard Edition users.

Return to sp_Blitz or Ask Us Questions