Help Center > > User Guide> Working with RDS for SQL Server> Backups and Restorations> Configuring an Automated Backup Policy

Configuring an Automated Backup Policy

Updated at: May 26, 2020 GMT+08:00

Scenarios

When you create a DB instance, an automated backup policy is enabled by default. For security purposes, the automated backup policy cannot be disabled. After the DB instance is created, you can customize the automated backup policy as required and then 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 set the automated backup time window to 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. The backup time is configured based on UTC time and is adjusted for daylight saving time, which changes at different times depending on the time zone.
  • Backup cycle: Each day of the week

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 RDS. The RDS console is displayed.
  4. On the Instance Management page, click the target DB instance.
  5. On the Backups & Restorations page, click Modify Backup Policy. Modify the automated backup policy, as shown in Figure 1.

    Figure 1 Modifying an automated backup policy
    • Retention Period refers to the number of days that your automated backups can be retained. Increasing the retention period will improve data reliability.
    • If you shorten the retention period, the new backup policy takes effect for all backup files. The backup files that have expired will be deleted.
    • The backup retention period indicates the number of days you want automated full and incremental backups of your DB instance to be retained. It ranges from 1–732 days. If you want to extend the retention period, contact customer service. The backup 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 and you can change it. At least one day must be selected.
    • You do not need to set incremental backups because the system automatically performs an incremental backup every 5 minutes. Both the full and incremental backups are stored in OBS.

  6. Click OK.

Did you find this page helpful?

Submit successfully!

Thank you for your feedback. Your feedback helps make our documentation better.

Failed to submit the feedback. Please try again later.

Which of the following issues have you encountered?







Please complete at least one feedback item.

Content most length 200 character

Content is empty.

OK Cancel