Creating a Manual Backup
Scenarios
RDS for SQL Server allows you to create manual backups for primary instances that are running properly. You can restore data from these backups to ensure data reliability.
When an instance is performing a backup, its data is copied, compressed, and uploaded to the OBS. The backup duration depends on the amount of instance data, and the average backup speed is 60 MB/s.
Constraints
- When a DB instance is deleted, its automated backups are also deleted but its manual backups are retained.
- To create manual backups, ensure that your account balance is greater than or equal to $0 USD.
- Creating a backup increases disk I/O utilization. Perform this operation during off-peak hours.
- By default, system databases are not backed up when you manually create full backups or database-level backups.
Billing
Backups of the enterprise and standard editions are saved as packages in OBS buckets. The web edition does not support backup compression. For the billing details, see How Is RDS Backup Data Billed?
Procedure
- Log in to the RDS console.
- Click
in the upper left corner and select a region. - On the Instances page, locate the target instance and choose in the Operation column.
Alternatively, click the instance name, choose Backups & Restorations in the navigation pane, and click Create Backup.
- On the displayed page, select Full Backup as the backup type, enter a name for the backup, and add a description. Figure 1 Creating a full backup
Table 1 Parameter description Parameter
Description
Backup Name
The backup name is case-sensitive and can contain 4 to 64 characters. It must start with a letter. Only letters, digits, hyphens (-), and underscores (_) are allowed.
Backup Description
The description can contain a maximum of 256 characters and cannot contain carriage returns or other special characters (! < " = ' > &).
- Click OK to submit the backup task.
- The backup duration depends on the amount of instance data. After the backup is created, its status is Completed and its backup method is Physical backup.
- Log in to the RDS console.
- Click
in the upper left corner and select a region. - On the Instances page, locate the target instance and choose in the Operation column.
Alternatively, click the instance name, choose Backups & Restorations in the navigation pane, and click Create Backup.
- On the displayed page, set Databases as the backup type, enter a name and description for the backup, and select the databases to be backed up. Figure 2 Creating a database-level backup
Table 2 Parameter description Parameter
Description
Backup Name
The backup name is case-sensitive and can contain 4 to 64 characters. It must start with a letter. Only letters, digits, hyphens (-), and underscores (_) are allowed.
Backup Description
The description can contain a maximum of 256 characters and cannot contain carriage returns or other special characters (! < " = ' > &).
Database
You can only select databases that you have created.
- Click OK to submit the backup task.
- The backup duration depends on the amount of instance data. After the backup is created, its status is Completed and its backup method is Physical backup.
What is your overall rating for this page?
Thank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot