ApsaraDB RDS for SQL Server supports log backups at 5-minute intervals. For a stricter recovery point objective (RPO), set the log backup interval to 5 minutes. The new setting takes effect immediately after configuration. You can also switch back to the 30-minute interval at any time based on your business needs. This switch is seamless and does not affect your running instance.
Architecture
Benefits
-
Enhanced data protection: Reduces the maximum data loss from 30 minutes to 5 minutes, improving data security.
-
Optimized log backup workload: Distributes backup tasks more evenly within each 30-minute period to improve system efficiency.
-
Reduced risk: Minimizes potential data loss from accidental operations or in extreme scenarios.
Limitations
-
This feature is not supported for instances that run SQL Server 2008 R2.
-
This feature is not supported for serverless instances or instances of the shared instance type.
-
If the Secondary Instance Preferred policy is enabled for your instance, you cannot set a 5-minute log backup interval or perform an incremental backup. For more information, see What is the secondary database preferred policy?.
-
If you have upgraded to the advanced backup policy feature, you cannot set the log backup interval to 5 minutes. For more information, see What are advanced backup policies?.
Billing
Each ApsaraDB RDS instance includes a free backup storage quota. Backups within this quota are free. A backup fee applies to usage that exceeds the free quota. For more information about the free quota and billing, see Backup fee.
Procedure
In the ApsaraDB RDS console, find your target instance on the Instances page. Then, navigate to the page. In the Backup Settings section, click Edit and set Log Backup Frequency to Every 5 Minutes.
Click Save.
Related documents
-
To change the log backup policy to every 30 minutes or view the current backup policy of an instance in the ApsaraDB RDS console, see Set or view the backup policy of an instance.
-
To change the log backup frequency to every 5 minutes by using an API, see Modify the backup policy of an instance.
-
Set the log backup frequency to every 5 minutes: Set the BackupLog parameter to Enable and leave the LogLogBackupFrequency parameter empty.
-
Set the log backup frequency to every 30 minutes: Leave the BackupLog parameter empty and set the LogBackupFrequency parameter to LogInterval.
-
Set the log backup frequency to be the same as data backup: Leave both the BackupLog and LogLogBackupFrequency parameters empty.
-
-
To view the current backup policy of an instance by using an API, see View the backup settings of an instance.
FAQ
-
Q: How do I check the current log backup usage for my instance?
A: In the ApsaraDB RDS console, go to the Basic Information page of your instance and find the Usage Statistics section.
The Backup Usage row shows the usage for Data and Log backups. A total of 50 GB of backup storage is free.
-
Q: Does changing the backup interval affect existing backups?
A: No, the change affects only subsequent backups.
-
Q: Can I set different backup intervals for different time periods?
A: No. You cannot schedule different backup intervals for different time periods. We recommend that you select a fixed backup frequency based on your business requirements.
In the Backup Settings dialog box, Log Backup Frequency provides three options: Same as data backup, Every 30 Minutes, and Every 5 Minutes. Choose the frequency that best suits your needs.