This topic describes how to back up an ApsaraDB RDS for SQL Server instance. You can configure a backup policy that allows ApsaraDB RDS 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 for your RDS instance. Each RDS instance is allocated a free quota for backup storage. If your usage exceeds the free quota, you are charged for the excess usage. We recommend that you specify a backup cycle based on your business requirements to make the best use of the free quota. For more information, see View the free quota for backup storage of an ApsaraDB RDS for SQL Server instance.
- You must familiarize yourself with the billing methods and billable items of backup storage. For more information, see Pricing, billable items, and billing methods.
- You must familiarize yourself with the billing standards of backup storage. For more information, see Backup storage fees of an ApsaraDB RDS for SQL Server instance.
- We recommend that you back up your RDS instance during off-peak hours and do not execute DDL statements during a backup. DDL statements trigger locks on tables, and the backup may fail as a result of the locks.
- If your RDS instance contains a large amount of data, a backup may require a long period of time.
- Backup files are retained based on the retention period that you specify. Before the specified retention period elapses, we recommend that you download the backup files that you require to your computer.
- If your RDS instance runs the RDS Basic Edition, High-availability Edition, or Cluster Edition, your RDS instance collects traffic statistics from the network interface controllers of the operating system that is used. In this case, the volume of traffic on your RDS instance surges during a backup.
Overview of data backups 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 the data of your RDS instance to a specific point in time within
the last 30 minutes in the event of SSD damage or other unexpected failures. This
is supported when your RDS instance runs the RDS Basic Edition.
|
Configure a backup policy for automatic backups
ApsaraDB RDS can automatically back up your instance based on the backup policy that you specify.
Manually back up your RDS instance
FAQ
- Can I disable the data backup feature for my RDS instance?
No, you cannot disable the data backup feature for your RDS instance. However, you can reduce the backup frequency to at least twice a week. The data backup retention period must be within the range of 7 days to 730 days.
- Can I disable the log backup feature for my RDS instance?
No, you cannot disable the log backup feature for your RDS instance.
Operations
Operation | Description |
---|---|
Create a backup task | Creates a data backup for an ApsaraDB RDS instance. |
Query data backup files | Queries the data 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. |