All Products
Search
Document Center

ApsaraDB RDS:Use the snapshot backup feature

Last Updated:Mar 18, 2024

ApsaraDB RDS for SQL Server supports the snapshot backup feature. The snapshot backup method is faster and support a larger amount of data than the physical backup method.

Feature description

ApsaraDB RDS for SQL Server supports snapshot backup and physical backup. The data from physical backup files can be restored at a speed of up to 20 MB per second. Each physical backup supports up to 4 TB of data. If you want to restore a large amount of data, the restoration process may require a long period of time.

The snapshot backup feature is developed based on Volume Shadow Copy Service, which is provided by Microsoft. This feature allows you to periodically back up data snapshots on cloud disks and use the snapshots to quickly restore data to a point in time. For more information, see Volume Shadow Copy Service. The snapshot backup feature provides the following benefits:

Comparison between snapshot backup and physical backup

Item

Physical backup

Snapshot backup

Log backup frequency

Physical backups support the following log backup frequencies:

  • Same as Data Backup

  • Every 30 Minutes

The log backup frequency is fixed as Every 30 Minutes.

Restoration speed

The restoration is fast. The restoration speed varies based on the specifications of your RDS instance.

The restoration is extremely fast. The restoration speed is not affected by the amount of data. The speed of restoring data from a snapshot backup is higher than the speed of restoring data from a physical backup.

  • Restore data to a new RDS instance

    • The time that is required to restore data from a backup set is approximately 30 minutes. This includes the time that is required to create an RDS instance and the time that is required to restore the data from the backup set.

    • The time that is required to restore data to a point in time varies based on the log backup file that is used. This includes the time that is required to create an RDS instance and the time that is required to restore the data from the log backup file.

  • Restore data to an existing RDS instance

    • The time that is required to restore data from a backup set is approximately 10 minutes.

    • The time that is required to restore data to a point in time varies based on the log backup file that is used.

Note

The log backup files that are used are generated between the point in time at which the most recent snapshot backup file is generated and the point in time to which you want to restore data.

Amount of data supported

Up to 4 TB of data is supported.

Up to 16 TB of data is supported.

Impact on instance performance

A large number of resources are consumed. This significantly affects the performance of your RDS instance. We recommend that you perform a physical backup during off-peak hours.

Only a small number of I/O resources are consumed. This does not significantly affect the performance of your RDS instance. You can perform a snapshot backup at any time.

Backup file download

Physical backup files can be downloaded.

Snapshot backup files cannot be downloaded.

Prerequisites

  • The RDS instance meets the following requirements:

    • The RDS instance uses enhanced SSDs (ESSDs). Serverless RDS instances are not supported.

    • The RDS instance was created after January 01, 2021.

  • If the RDS instance runs RDS Basic Edition or RDS High-availability Edition, make sure that the cross-region backup feature is disabled. If the cross-region backup feature is enabled, you must disable it before you enable the snapshot backup feature. For more information, see Use the cross-region backup feature.

  • The AliyunServiceRoleForDBS service-linked role is created by using your Alibaba Cloud account if you use the backup feature of ApsaraDB RDS for the first time. For more information, see How do I create a service-linked role for DBS?

Usage notes

  • If your RDS instance runs RDS Basic Edition or RDS High-availability Edition, the snapshot backup feature does not support cross-region backups. For more information, see Use the cross-region backup feature.

  • Snapshot backup files cannot be downloaded.

  • Snapshots are created based on cloud disks instead of backup files. As a result, the snapshot backup feature does not support incremental backups.

    Note

    Snapshots use the incremental snapshot chain mechanism. This mechanism retains the status of snapshot at each point in time. As a result, a snapshot backup only backs up the incremental and updated data on cloud disks.

Billing rules

Each RDS instance is allocated a free quota for backup storage. If the backup storage of your RDS instance does not exceed the free quota, you are not charged for backup storage. If the backup storage exceeds the free quota, you are charged for the excess storage that you use. For more information about the free quota and billing rules, see Billable items and pricing for the backup storage of an ApsaraDB RDS for SQL Server instance.

Procedure

By default, an RDS instance uses the physical backup method. You can manually change the backup method to snapshot backup.

  1. Go to the Instances page. In the top navigation bar, select the region in which the RDS instance resides. Then, find the RDS instance and click the ID of the instance.
  2. In the left-side navigation pane of the page that appears, click Backup and Restoration.

  3. On the Backup Strategy tab of the Backup and Restoration page, click Edit in the Data Backup Settings section.

  4. In the dialog box that appears, set the Backup Method parameter to Snapshot Backup and click Save.

    Note
    • After you change the backup method to Snapshot Backup, physical backups are not regularly performed. However, you can still select Physical Backup to perform a physical backup when you manually back up your RDS instance. For more information, see Back up an ApsaraDB RDS for SQL Server instance.

    • After you change the backup method to Snapshot Backup, the log backup frequency is fixed as Every 30 Minutes.

References