Create a database on an ApsaraDB RDS for SQL Server instance - ApsaraDB RDS

After you create an ApsaraDB RDS for SQL Server instance, you must create a database on the instance. This topic describes how to create a database on an RDS instance. This topic also describes the limits on the number of databases that you can create on an RDS instance.

Prerequisites

An RDS instance is created. For more information, see Create an ApsaraDB RDS for SQL Server instance.

Limits on the number of databases

An RDS instance that runs SQL Server 2008 R2 supports up to 50 databases. If your RDS instance runs other SQL Server versions, the maximum number of databases varies based on the RDS edition. You can use the following formulas to calculate the maximum number of databases:

RDS Cluster Edition/RDS High-availability Edition
You must extract the square root of the number of CPU cores, round the square root down to the integer, and then multiply the integer by 50. Assume that the obtained value is X. In this example, the maximum number of databases equals the smaller value between X and 300. For example, if your RDS instance runs SQL Server 2016 SE on RDS High-availability Edition and provides 4 CPU cores and 8 GB of memory, the RDS instance supports a maximum of 100 databases.
RDS Basic Edition
You must extract the square root of the number of CPU cores, round the square root down to the integer, and then multiply the integer by 100. Assume that the obtained value is X. In this example, the maximum number of databases equals the smaller value between X and 400. For example, if your RDS instance runs SQL Server 2019 SE on RDS Basic Edition and provides 4 CPU cores and 8 GB of memory, the RDS instance supports a maximum of 200 databases.

Note

min in the preceding formulas indicates that the smaller value between two values is used. For example, the value of min{100,300} is 100.

Procedure

Go to the Instances page. In the top navigation bar, select the region in which the RDS instance resides. Then, find the RDS instance and click the ID of the instance.
In the left-side navigation pane, click Databases.

On the page that appears, click Create Database, configure the following parameters, and then click Create.

Parameter	Description
Database Name	The name of the database. The name must be 2 to 64 characters in length and can contain letters, digits, underscores (_), and hyphens (-). The name must start with a letter and end with a letter or a digit. The database name cannot contain Chinese characters.
Supported Character Set	The character set of the database.
Description	The description of the database. The description can be up to 256 characters in length.

Click Create.

References

You can also call the CreateDatabase operation to create a database on an RDS instance.
You can use various methods such as Data Management (DMS) and Microsoft SQL Server Management Studio (SSMS) to connect to an RDS instance.

FAQ

What do I do if the error message Due to the limit number you can't create a database is displayed when I create a database on my RDS instance?

Causes: The error message is displayed because the number of databases that you can create on your RDS instance reaches the upper limit supported by the current instance specifications. The number of databases that you can create on an RDS instance is restricted by the specifications of the RDS instance. For more information about how to calculate the maximum number of databases that you can create on the RDS instance, see the "Limits on the number of databases" section of this topic.
Solutions: You can upgrade the specifications of your RDS instance to increase the maximum number of databases that you can create on the RDS instance.

When I create a database on an RDS instance, can I use Chinese characters for the database name?

No, you cannot use Chinese characters for the database name. If you specify Chinese characters for a database name, issues such as compatibility issues, script parsing difficulties, migration risks, and increased management complexity may occur. The name of a database on an RDS instance must be 2 to 64 characters in length and can contain letters, digits, underscores (_), and hyphens (-). The name must start with a letter and end with a letter or digit. You must conform to these naming conventions to ensure system stability and maintainability.