This topic provides an overview of the features that are provided by ApsaraDB RDS for SQL Server. The features that are supported vary based on the SQL Server version, RDS edition, and storage type that are used.

Note In the following tables, ticks (✔️) indicate that a feature is supported, and crosses (❌) indicate that a feature is not supported.

SQL Server 2019

Category Feature SQL Server 2019
EE SE
RDS Cluster Edition RDS High-availability Edition
Standard SSD ESSD PL1, ESSD PL2, and ESSD PL3 Standard SSD ESSD PL1, ESSD PL2, and ESSD 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 ❌ ❌ ❌ ❌
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 ✔️ ✔️ ✔️ ✔️
DBCC ✔️ ✔️ ✔️ ✔️
Account management Create an account on an ApsaraDB RDS for SQL Server instance ✔️ ✔️ ✔️ ✔️
Reset the password of an account on an ApsaraDB RDS for SQL Server instance ✔️ ✔️ ✔️ ✔️
Modify the permissions of an account on an ApsaraDB RDS for SQL Server instance ✔️ ✔️ ✔️ ✔️
Authorize 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 an endpoint 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 monitoring data 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 instance 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 transparent data encryption (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 ✔️ ✔️ ✔️ ✔️

SQL Server 2017

Category Feature SQL Server 2017
EE SE
RDS Cluster Edition RDS High-availability Edition
Standard SSD ESSD PL1, ESSD PL2, and ESSD PL3 Standard SSD ESSD PL1, ESSD PL2, and ESSD 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 ❌ ❌ ❌ ❌
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 ✔️ ✔️ ✔️ ✔️
DBCC ✔️ ✔️ ✔️ ✔️
Account management Create an account on an ApsaraDB RDS for SQL Server instance ✔️ ✔️ ✔️ ✔️
Reset the password of an account on an ApsaraDB RDS for SQL Server instance ✔️ ✔️ ✔️ ✔️
Modify the permissions of an account on an ApsaraDB RDS for SQL Server instance ✔️ ✔️ ✔️ ✔️
Authorize 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 an endpoint 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 monitoring data 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 instance 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 ✔️ ✔️ ✔️ ✔️

SQL Server 2016

Category Feature SQL Server 2016
EE SE Web
RDS High-availability Edition RDS Basic Edition RDS High-availability Edition RDS Basic Edition
Standard SSD ESSD PL1, ESSD PL2, and ESSD PL3 Standard SSD ESSD PL1 Standard SSD ESSD PL1, ESSD PL2, and ESSD PL3 Standard SSD ESSD PL1
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 ❌ ❌ ❌ ❌ ❌ ❌ ❌ ❌
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 ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️
DBCC ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️
Instance upgrade Upgrade an ApsaraDB RDS for SQL Server instance from the RDS Basic Edition to the RDS High-availability Edition ❌ ❌ ✔️ ✔️ ❌ ❌ ✔️ ✔️
Account management Create an account on an ApsaraDB RDS for SQL Server instance ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️
Reset the password of an account on an ApsaraDB RDS for SQL Server instance ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️
Modify the permissions of an account on an ApsaraDB RDS for SQL Server instance ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️
Authorize 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 an endpoint 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 monitoring data 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 instance 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 ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️

SQL Server 2012

Category Feature SQL Server 2012
EE EE Basic SE Web
RDS High-availability Edition RDS Basic Edition RDS High-availability Edition RDS Basic Edition
Standard SSD ESSD PL1, ESSD PL2, and ESSD PL3 Standard SSD ESSD PL1 Standard SSD ESSD PL1, ESSD PL2, and ESSD PL3 Standard SSD ESSD PL1
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 ❌ ❌ ❌ ❌ ❌ ❌ ❌ ❌
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 ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️
DBCC ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️
Instance upgrade Upgrade an ApsaraDB RDS for SQL Server instance from the RDS Basic Edition to the RDS High-availability Edition ❌ ❌ ✔️ ✔️ ❌ ❌ ✔️ ✔️
Upgrade an RDS instance from SQL Server 2012 to SQL Server 2016 ❌ ❌ ✔️ ✔️ ❌ ❌ ✔️ ✔️
Account management Create an account on an ApsaraDB RDS for SQL Server instance ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️
Reset the password of an account on an ApsaraDB RDS for SQL Server instance ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️
Modify the permissions of an account on an ApsaraDB RDS for SQL Server instance ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️
Authorize 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 an endpoint 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 monitoring data 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 instance 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 ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️

SQL Server 2008 R2

Category Feature SQL Server 2008 R2
RDS High-availability Edition
Local SSD Standard SSD ESSD PL1, ESSD PL2, and ESSD 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 ✔️ ❌ ❌
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 ✔️ ✔️ ✔️
DBCC ❌ ✔️ ✔️
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 on an ApsaraDB RDS for SQL Server instance ✔️ ✔️ ✔️
Modify the permissions of an account on an ApsaraDB RDS for SQL Server instance ✔️ ✔️ ✔️
Authorize 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 an endpoint 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 monitoring data 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 instance 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 ✔️ ✔️ ✔️