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 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).
No, you can’t even get it online just long enough to rip out those features. If so, SQL Server just won’t let you bring the database online. At that time, SQL Server checks to see whether any Enterprise Edition features are 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. Blitz Result: Enterprise Edition Features in Use
0 kommentar(er)
