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
Last activity: Jun 11, 2024, 02:49 PM