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

How it works

Limitations

• RDS instances running SQL Server 2008 R2 are not supported.

• Serverless ApsaraDB RDS instances and instances using shared instance types are not supported. For details, see Serverless instances and Instance families.

• If the secondary database preferred backup mode is enabled, the 5-minute log backup frequency and incremental backup are not supported. For details, see Backup features.

• If the entry point has been upgraded to the Backup Strategy tab, this setting is not available. For details, see Back up an ApsaraDB RDS for SQL Server instance.

Billing

Each RDS instance has a free quota for backup storage. If the total size of backup files stays within the free quota, no charge applies. Excess storage is billed. For free quota details and pricing, see Backup fee.

Set the log backup frequency

1. Go to the Instances page, find your instance, and click the instance ID.

2. In the left-side navigation pane, click Backup and Restoration.

3. On the Backup Strategy tab, go to the Data Backup Settings section and click Edit.

4. Set Log Backup Frequency to Every 5 Minutes.

The change takes effect immediately. To switch back to every 30 minutes, set Log Backup Frequency to Every 30 Minutes.

The frequency change applies only to new backup tasks. Existing backup tasks are not affected.

FAQ

How do I view log backup usage?

Go to the Basic Information page of your RDS instance in the ApsaraDB RDS console and check the Usage Statistics section.

Can I set different backup frequencies for different time periods?

No. The backup frequency applies uniformly across all time periods. Select a frequency based on your RPO requirements.

Related topics

• Review or change backup settings in the ApsaraDB RDS console: Back up an ApsaraDB RDS for SQL Server instance

• Change the log backup frequency via API using ModifyBackupPolicy:

  Log backup frequency	BackupLog	LogBackupFrequency
  Every 5 minutes	Enable	(leave blank)
  Every 30 minutes	(leave blank)	LogInterval
  Same as data backup	(leave blank)	(leave blank)

• Query backup settings via API: DescribeBackupPolicy