This topic describes how to back up an ApsaraDB RDS for SQL Server instance. You can configure a backup policy that is used to automatically back up your RDS instance. You can also manually back up your RDS instance.
Precautions
- Backup files do not occupy the storage capacity that you purchased during instance creation. Each RDS instance is allocated with a free quota for backup storage. If your backup storage usage exceeds the free quota, you are charged additional fees. We recommend that you specify a proper backup cycle based on your business requirements to make the best use of the free backup quota. For more information, see View the free quota for backup storage of an ApsaraDB RDS for SQL Server instance.
- You must be familiar with the billing methods and billable items of backup storage. For more information, see Pricing, billable items, and billing methods.
- You must be familiar with the billing standards of backup storage. For more information, see ApsaraDB RDS pricing.
- Do not execute data definition language (DDL) statements during a backup. These statements trigger locks on tables, and the backup may fail as a result of the locks.
- We recommend that you back up your RDS instance during off-peak hours.
- If your RDS instance has a large volume of data, backing up your RDS instance may require a long time.
- Backup files are retained based on the specified retention period. We recommend that you download the required backup files to your computer before they are deleted.
- You cannot manually delete backup files.
Overview of data and log backups
Database engine | Data Backup | Log backup |
---|---|---|
SQL Server |
|
Note If the Backup Frequency parameter is set to Every 30 Minutes, you can restore your RDS instance to a point in time within the last 30 minutes
in the event of SSD damage or other unexpected failures. This applies to the RDS Basic
Edition.
|
Configure a backup policy to automatically back up your RDS instance
ApsaraDB RDS automatically backs up each RDS instance based on the specified backup policy.
Manually back up your RDS instance
FAQ
- Can I disable the data backup function of my RDS instance?
No, you cannot disable the data backup function of your RDS instance. However, you can reduce the backup frequency to as low as twice a week. The data backup retention period must be within the range from 7 days to 730 days.
- Can I disable the log backup function of my RDS instance?
No, you cannot disable the log backup function of your RDS instance.
Related operations
Operation | Description |
---|---|
Create backup set | Creates a backup for an ApsaraDB RDS instance. |
Query backup sets | Queries the backup files of an ApsaraDB RDS instance. |
Query backup settings | Queries the backup settings of an ApsaraDB RDS instance. |
Modify backup settings | Modifies the backup settings of an ApsaraDB RDS instance. |
Query backup tasks | Queries the backup tasks of an ApsaraDB RDS instance. |
Query log backup files | Queries the log backup files of an ApsaraDB RDS instance. |