Skip to main content
Database Administrators

Return to Question

Became Hot Network Question
formatting the code
Source Link
SqlWorldWide
SqlWorldWide
  • 13.6k
  • 3
  • 29
  • 54

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

SELECT feature_name
FROM sys.dm_db_persisted_sku_features;
GO

Output

feature_name

Compression

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

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

Source Link
Vikas Kanoujiya
Vikas Kanoujiya
  • 31
  • 1

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

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