RDS for SQL Server Constraints

RDS for SQL Server only supports DB instances under the License Included model and does not support "bring your own license" (BYOL). After a DB instance is created, it contains the Microsoft SQL Server software license.

To ensure data security, there are certain constraints on using RDS for SQL Server.

RDS for SQL Server DB instances are classified into three types: single, primary/standby, and cluster. Different types support different functions.

Quotas

Table 1 Quotas
Item	Constraints	Description
Number of databases	A maximum of 100 (can be increased)	-
Number of database accounts	Unlimited	-
Read replica	A maximum of five read replicas can be created for a DB instance.	For more information, see Introducing Read Replicas.
Tags	A maximum of 20 tags can be added for a DB instance.	For more information, see RDS for SQL Server Tags.
Free backup space	RDS provides free backup space of the same size as your purchased storage space.	After you pay for the storage space of your DB instance, you will get a backup space of the same size for free. For more information, see How Is RDS Backup Data Billed?
Retention period of automated backups	The default value is 7 days. The value ranges from 1 to 732 days.	For more information, see Configuring an Intra-Region Backup Policy.
Audit logs	The maximum size of an audit log file is 50 MB. Up to 50 audit log files can be displayed.	For more information, see Log Management.

Naming

Table 2 Naming
Item	Constraints
Instance name	4 to 64 characters long Must start with a letter. Only letters (case sensitive), digits, hyphens (-), and underscores (_) are allowed.
Database name	1 to 64 characters long Only letters, digits, hyphens (-), underscores (_), and periods (.) are allowed. It cannot start or end with an RDS for SQL Server system database name. RDS for SQL Server system databases include master, msdb, model, tempdb, resource, rdsdistribution, and rdsadmin. Databases cannot be created for a DB instance that is being restored or whose instance class is being changed. Databases with HA relationships can be renamed only after the replication relationships are removed.
Account name	1 to 128 characters long Only letters, digits, hyphens (-), and underscores (_) are allowed. It must be different from system accounts. System accounts include rdsadmin, rdsuser, rdsbackup, and rdsmirror.
Backup name	4 to 64 characters long Must start with a letter. Only letters (case sensitive), digits, hyphens (-), and underscores (_) are allowed.
Parameter template name	1 to 64 characters long Only letters (case sensitive), digits, hyphens (-), underscores (_), and periods (.) are allowed.

Security

Table 3 Security
Item	Constraints
rdsuser roles	The administrator account of RDS for SQL Server is rdsuser, which has roles processadmin, public, and dbcreator but does not have the following roles: bulkadmin diskadmin securityadmin serveradmin sysadmin
rdsuser password	8 to 32 characters long Must contain at least three types of the following characters: uppercase letters, lowercase letters, digits, and special characters (~!@#$%^*-_+?,). For more information, see Resetting the Administrator Password.
Database port	RDS for SQL Server instances can use port 1433 (default) or ports 2100 to 9500 (excluding 5355 and 5985). For RDS for SQL Server 2017 and 2019 Enterprise, Standard, and Web editions, ports 5050, 5353, and 5986 cannot be used, either. For more information, see Changing a Database Port.
Disk encryption	If you enable disk encryption during instance creation, the disk encryption status and the key cannot be changed later. For more information, see Performing a Server-Side Encryption.
VPC	The VPC where a DB instance is located cannot be changed after the instance is created.
Security group	By default, you can create a maximum of 100 security groups in your cloud account. By default, you can add up to 50 security group rules to a security group. For more information, see Configuring Security Group Rules.
System account	To provide O&M services, the system automatically creates system accounts when you create RDS for SQL Server DB instances. These system accounts are unavailable to you. rdsadmin: an account that has the sysadmin role and is used to query DB instance information, monitor instance status, rectify faults, migrate data, and restore data. rdsmirror: a primary/standby replication account, used to create mirroring endpoints. rdsbackup: a backup account, used for backend backup. Mike: a Windows system account of RDS for SQL Server. It is used to initialize SQL statements during the DB instance initialization, including creating the rdsadmin database and related accounts.
Instance parameter	To ensure the optimal performance of RDS, you can modify parameters in the parameter template you created as needed. For more information, see Modifying RDS for SQL Server Instance Parameters.

Instance Operations

Table 4 Instance operations
Item	Constraints
Instance deployment	ECSs where DB instances are deployed are not directly visible to you. You can only access the DB instances through IP addresses and database ports.
High CPU usage	If the CPU usage is high or close to 100%, data read/write and database access will become slow, and an error will be reported during data deletion. For details, see Modifying RDS for SQL Server Instance Parameters.
Rebooting a DB instance	DB instances cannot be rebooted through commands. They must be rebooted through the RDS console.
Viewing backups	You can download backups for local storage. To download a backup, you can use OBS Browser+ or the download URL. For more information, see Downloading a Backup File.
Log management	RDS for SQL Server logging is enabled by default and cannot be disabled.
Recycle bin	RDS allows you to move deleted pay-per-use DB instances to the recycle bin. You can rebuild a DB instance that was deleted up to 7 days ago from the recycle bin.

Functions

Table 5 Functions
Item	Single	Primary/Standby	Cluster
Maximum number of databases	100 (can be increased)	100 (can be increased)	100 (can be increased)
Number of database accounts	Unlimited	Unlimited	Unlimited
Creation of user, LOGIN, or database	Supported	Supported	Supported
Database-level DDL trigger	Supported	Supported	Supported
Database permission authorization	Supported	Supported	Supported
KILL permission	Supported	Supported	Supported
LinkServer	Coming soon	Coming soon	Supported
Distributed transaction	Coming soon	Coming soon	Supported
SQL Profiler	Supported	Supported	Supported
Tuning Adviser	Supported	Supported	Supported
Change Data Capture (CDC)	Supported	Supported	Supported
Change tracking	Supported	Supported	Supported
Windows domain account login	Supported	Supported	Supported
Email	Not supported	Not supported	Supported
SQL Server Integration Services (SSIS)	Not supported	Not supported	Not supported
SQL Server Analysis Services (SSAS)	Not supported	Not supported	Not supported
SQL Server Reporting Services (SSRS)	Not supported	Not supported	Supported
R Services	Not supported	Not supported	Not supported
Common Language Runtime (CLR)	Not supported	Not supported	SAFE supported
Asynchronous communication	Not supported	Not supported	Not supported
Policy management	Not supported	Not supported	Not supported
Private domain name	Supported	Supported	Supported
SQL Agent job	Supported	Supported	Supported

Parent topic: Constraints

Предыдущая статья

RDS for PostgreSQL Constraints

Следующая статья

Related Services

Была ли эта статья полезна?

Поддержка Юридические документы