This topic provides an overview of the features supported by ApsaraDB RDS instances that run SQL Server 2008 R2. In the following table, ticks (√) indicate that a feature is supported, and crosses (×) indicate that a feature is not supported.

Category Feature RDS High-availability Edition
Local SSD Standard SSD ESSD of PL1, ESSD of PL2, and ESSD of PL3
Data migration Migrate the data of an ApsaraDB RDS for SQL Server instance ✔️ ✔️ ✔️
Instance management Create an ApsaraDB RDS for SQL Server instance ✔️ ✔️ ✔️
Change the specifications of an ApsaraDB RDS for SQL Server instance ✔️ ✔️ ✔️
Migrate an ApsaraDB RDS for SQL Server instance across zones in the same region ✔️
Switch workloads over between primary and secondary ApsaraDB RDS for SQL Server instances ✔️ ✔️ ✔️
Restart an ApsaraDB RDS for SQL Server instance ✔️ ✔️ ✔️
Set the maintenance window of an ApsaraDB RDS for SQL Server instance ✔️ ✔️ ✔️
Release an ApsaraDB RDS for SQL Server instance ✔️ ✔️ ✔️
Manage ApsaraDB RDS for SQL Server instances in the recycle bin ✔️ ✔️ ✔️
Use DBCC statements on an ApsaraDB RDS for SQL Server instance ✔️ ✔️
Instance upgrade Upgrade an ApsaraDB RDS for SQL Server instance from SQL Server 2008 R2 to SQL Server 2012 or SQL Server 2016 ✔️
Account management Create an account on an ApsaraDB RDS for SQL Server instance ✔️ ✔️ ✔️
Reset the password of an account of an ApsaraDB RDS for SQL Server instance ✔️ ✔️ ✔️
Modify the permissions of an account of an ApsaraDB RDS for SQL Server instance ✔️ ✔️ ✔️
Grant permissions to the service account of an ApsaraDB RDS for SQL Server instance ✔️
Delete an account from an ApsaraDB RDS for SQL Server instance ✔️ ✔️ ✔️
Database management Create a database on an ApsaraDB RDS for SQL Server instance ✔️ ✔️ ✔️
Delete a database from an ApsaraDB RDS for SQL Server instance ✔️ ✔️ ✔️
Copy data from a self-managed SQL Server database to an ApsaraDB RDS for SQL Server instance ✔️ ✔️ ✔️
Database connection Connect to an ApsaraDB RDS for SQL Server instance ✔️ ✔️ ✔️
Configure endpoints for an ApsaraDB RDS for SQL Server instance ✔️ ✔️ ✔️
View and change the internal and public endpoints and port numbers of an ApsaraDB RDS for SQL Server instance ✔️ ✔️ ✔️
Apply for a public endpoint for an ApsaraDB RDS for SQL Server instance ✔️ ✔️ ✔️
Monitoring and alerting View the resource metrics, engine metrics, and deployment metrics of an ApsaraDB RDS for SQL Server instance ✔️ ✔️ ✔️
Set the monitoring frequency of an ApsaraDB RDS for SQL Server instance ✔️ ✔️ ✔️
Configure an alert rule for an ApsaraDB RDS for SQL Server instance ✔️ ✔️ ✔️
Network management Change the network type of an ApsaraDB RDS for SQL Server instance
Read-only instances and read/write splitting Create a read-only ApsaraDB RDS for SQL Server instance
Enable the read/write splitting feature for an ApsaraDB RDS for SQL Server instance
Modify the read weights of read-only ApsaraDB RDS for SQL Server instances
Security management Configure an IP address whitelist for an ApsaraDB RDS for SQL Server instance ✔️ ✔️ ✔️
Configure SSL encryption for an ApsaraDB RDS for SQL Server instance ✔️ ✔️ ✔️
Configure TDE for an ApsaraDB RDS for SQL Server instance ✔️ ✔️ ✔️
Configure a distributed transaction whitelist for an ApsaraDB RDS for SQL Server instance
Audit Manage the logs of an ApsaraDB RDS for SQL Server instance ✔️ ✔️ ✔️
Backup Back up an ApsaraDB RDS for SQL Server instance ✔️ ✔️ ✔️
Enable snapshot backups for an ApsaraDB RDS for SQL Server instance ✔️ ✔️
Enable cross-region backups for an ApsaraDB RDS for SQL Server instance ✔️ ✔️
Free quota for backup storage of an ApsaraDB RDS for SQL Server instance ✔️ ✔️ ✔️
Download the backup files of an ApsaraDB RDS for SQL Server instance ✔️ ✔️ ✔️
Restoration Restore the data of an ApsaraDB RDS for SQL Server instance ✔️ ✔️ ✔️
Tag management Create tags ✔️ ✔️ ✔️
Delete tags ✔️ ✔️ ✔️
Use tags to filter ApsaraDB RDS for SQL Server instances ✔️ ✔️ ✔️