Sample Header Ad - 728x90

Can we downgrade edition from SQL Server 2016 Enterprise to Standard when we have compression feature enabled?

3 votes
1 answer
567 views
I have a production database running on SQL Server 2016 Enterprise. I ran the below query to check the edition-specific feature and see the compression feature in use. Can we still downgrade the edition? Query ---------- SELECT feature_name FROM sys.dm_db_persisted_sku_features; GO Output ---------- feature_name ---------- Compression
Asked by Vikas Kanoujiya (31 rep)
Jun 11, 2024, 02:12 PM
Last activity: Jun 11, 2024, 02:49 PM