Solution to the "Data compression and vardecimal storage format are only supported on SQL Server Enterprise Edition" error for an ApsaraDB RDS for SQL Server instance - ApsaraDB RDS

Problem description

The following error message is displayed when I use my ApsaraDB RDS for SQL Server instance. [$Name] indicates the table name.

Recovery is writing a checkpoint in database 'xxx' (9). This is an informational message only. No user action is required. Database 'xxx' cannot be started in this edition of SQL Server because part or all of object '[$Name]' is enabled with data compression or vardecimal storage format. Data compression and vardecimal storage format are only supported on SQL Server Enterprise Edition. Database 'xxx' cannot be started because some of the database functionality is not available in the current edition of SQL Server

Causes

The error is caused by incompatible versions. SQL Server EE, SQL Server 2016 SE, and later SQL Server SE support the data compression feature. For more information, see Features of ApsaraDB RDS instances that run different SQL Server versions and RDS editions.

Solutions

You can use one of the following solutions to revolve the error:

Upgrade the major engine version of your RDS instance to a version that supports the data compression feature. For more information, see Upgrade the major engine version.
Disable the data compression feature. For more information, see Disable compression on a table or index.

Related operations

You can execute the following SQL statement to query the objects for which the data compression feature is enabled on your RDS instance:

SELECT name,
       type_desc,
       data_compression_desc
FROM sys.partitions p
JOIN sys.objects o ON p.object_id = o.object_id
WHERE p.data_compression_desc<>'NONE'
  AND o.type='U';

References

For more information about how to connect to an RDS instance from a client, see Connect to an ApsaraDB RDS for SQL Server instance.