• Relational Database Service

rds
  1. Help Center
  2. Relational Database Service
  3. User Guide
  4. Managing DB Instances
  5. Backups and Restorations
  6. Managing an Automated Backup Policy

Managing an Automated Backup Policy

Scenarios

When you create a DB instance, an automated backup policy with a 7-day backup retention period is enabled by default. You can also disable it. However, it is strongly recommended that you enable the automated backup policy for data restoration. After a DB instance is created, you can modify the automated backup policy as needed. RDS backs up data based on the automated backup policy you have set.

RDS automatically backs up data at the DB instance level. If a database is faulty or data is damaged, you can restore it from backups to ensure data reliability. Backups are saved as packages in OBS buckets to ensure data confidentiality and durability. Since backing up data affects the database read and write performance, you are advised to enable automated backups during off-peak hours.

The default automated backup policy is as follows:
  • Retention period: 7 days
  • Time window: An hour within 24 hours, such as 01:00-02:00 or 12:00-13:00
  • Backup cycle: Each day of the week

Enabling or Modifying an Automated Backup Policy

  1. Log in to the management console.
  2. Click in the upper left corner and select a region and a project.
  3. Click Service List. Under Database, click Relational Database Service to go to the RDS console.
  4. On the Instance Management page, click the target DB instance.
  5. On the Backups & Restorations page, click Modify Backup Policy. If you want to enable the automated backup policy, click .

    Retention Period refers to the number of days that your automated backups can be retained. Lengthening the retention period will improve data reliability.

    The backup retention period can range from 1 day to 732 days, and the time window is one hour. You are advised to select an off-peak time window for automated backups. By default, each day of the week is selected for Backup Cycle. You can change the backup cycle. A minimum of one day must be selected.

    After the automated backup policy is enabled, a full backup is triggered immediately. You do not need to set incremental backups (binlogs) because the system automatically performs an incremental backup every 5 minutes. Both the full and incremental backups are stored in OBS.

  6. Click OK.

Disabling the Automated Backup Policy

  • If the automated backup policy is disabled, automated backups will not be created and point-in-time recovery will not be available. After the automated backup is enabled, the time point will be set to the moment when you enabled the automated backup.
  • Deleting all automated backups may cause ongoing data restoration to be failed. Deleted backups cannot be recovered. Exercise caution when deleting automated backups.
  1. On the Instance Management page, click the target DB instance.
  2. On the Backups & Restorations page, click Modify Backup Policy. On the displayed page, click to disable the automated backup policy.

    For primary/standby Microsoft SQL Server DB instances, the automated backup policy cannot be disabled.

    You can determine whether to delete automated backups created in a specific period.
    • If you do not select Delete automated backups created in the following period, all automated backups within the retention period will be retained.
    • If you select Delete automated backups created in the following period, all automated backups within the retention period will be deleted.

  3. Click OK.