ApsaraDB RDS:Set the log backup frequency to every 5 minutes

Architecture

Benefits

• Enhanced data protection: The data protection window is reduced from 30 minutes to 5 minutes, which significantly enhances data security.

• Optimized log backup load distribution: The setting helps evenly distribute the backup tasks within every 30 minutes, which improves system efficiency.

• Reduced potential risks: More frequent backups can effectively reduce the risk of data loss in cases of unexpected operations or extreme scenarios.

Limits

• RDS instances that run SQL Server 2008 R2 are not supported.

• Serverless RDS instances and RDS instances that use shared instance types are not supported. For more information, see Serverless ApsaraDB RDS for SQL Server instances and Instance families.

• If the secondary database preferred backup mode is enabled for your RDS instance, the log backup frequency of every 5 minutes and incremental backup are not supported. For more information, see Backup description.

• If you have upgraded the entry point to the Backup Strategy tab, you cannot set the log backup frequency to every 5 minutes. For more information, see Back up an ApsaraDB RDS for SQL Server instance.

Billing rules

Each RDS instance is allocated a free quota on backup storage. If the total size of the backup files of your RDS instance does not exceed the free quota, you are not charged for backup storage. If the total size of the backup files exceeds the free quota, you are charged for the excess storage. For more information about the free quota and billing rules, see Backup storage fees.

Procedure

Go to the Instances page. Find the RDS instance that you want to manage and click the instance ID. In the left-side navigation pane of the page that appears, click Backup and Restoration. In the Data Backup Settings section of the Backup Strategy tab, click Edit. In the dialog box that appears, set the Log Backup Frequency parameter to Every 5 Minutes.

References

• You can change the log backup frequency to every 30 minutes or view the backup settings of your RDS instance in the ApsaraDB RDS console. For more information, see Back up an ApsaraDB RDS for SQL Server instance.

• You can call an API operation to change the log backup frequency to every 5 minutes. For more information, see ModifyBackupPolicy.

  • If the Log Backup Frequency parameter is set to Every 5 Minutes, you must set the BackupLog parameter to Enable and can leave the LogBackupFrequency parameter empty.

  • If the Log Backup Frequency parameter is set to Every 30 Minutes, you can leave the BackupLog parameter empty and set the LogBackupFrequency parameter to LogInterval.

  • If the Log Backup Frequency parameter is set to Same as Data Backup, you can leave the BackupLog and LogBackupFrequency parameters empty.

• You can call an API operation to query the backup settings of your RDS instance. For more information, see DescribeBackupPolicy.

FAQ

• How do I view the log backup usage of my RDS instance?

  You can view the log backup usage in the Usage Statistics section of the Basic Information page of the RDS instance in the ApsaraDB RDS console.

  

• Does the backup frequency change affect the existing backup tasks?

  No, the backup frequency change takes effect only on new backup tasks.

• Can I specify different backup frequencies for different periods of time?

  No, you cannot specify backup frequencies based on the period of time. We recommend that you select a backup frequency based on your business requirements.