Updated on 2026-11-13 GMT+08:00

Creating a Manual Backup

Scenarios

RDS for SQL Server allows you to create manual backups for primary instances that are running properly. You can restore data from these backups to ensure data reliability.

When an instance is performing a backup, its data is copied, compressed, and uploaded to the OBS. The backup duration depends on the amount of instance data, and the average backup speed is 60 MB/s.

Constraints

  • When a DB instance is deleted, its automated backups are also deleted but its manual backups are retained.
  • To create manual backups, ensure that your account balance is greater than or equal to $0 USD.
  • Creating a backup increases disk I/O utilization. Perform this operation during off-peak hours.
  • By default, system databases are not backed up when you manually create full backups or database-level backups.

Billing

Backups of the enterprise and standard editions are saved as packages in OBS buckets. The web edition does not support backup compression. For the billing details, see How Is RDS Backup Data Billed?

Procedure

  1. Log in to the RDS console.
  2. Click in the upper left corner and select a region.
  3. On the Instances page, locate the target instance and choose More > Create Full Backup in the Operation column.

    Alternatively, click the instance name, choose Backups & Restorations in the navigation pane, and click Create Backup.

  4. On the displayed page, select Full Backup as the backup type, enter a name for the backup, and add a description.

    Figure 1 Creating a full backup
    Table 1 Parameter description

    Parameter

    Description

    Backup Name

    The backup name is case-sensitive and can contain 4 to 64 characters. It must start with a letter. Only letters, digits, hyphens (-), and underscores (_) are allowed.

    Backup Description

    The description can contain a maximum of 256 characters and cannot contain carriage returns or other special characters (! < " = ' > &).

  5. Click OK to submit the backup task.
  6. The backup duration depends on the amount of instance data. After the backup is created, its status is Completed and its backup method is Physical backup.
  1. Log in to the RDS console.
  2. Click in the upper left corner and select a region.
  3. On the Instances page, locate the target instance and choose More > Create Full Backup in the Operation column.

    Alternatively, click the instance name, choose Backups & Restorations in the navigation pane, and click Create Backup.

  4. On the displayed page, set Databases as the backup type, enter a name and description for the backup, and select the databases to be backed up.

    Figure 2 Creating a database-level backup
    Table 2 Parameter description

    Parameter

    Description

    Backup Name

    The backup name is case-sensitive and can contain 4 to 64 characters. It must start with a letter. Only letters, digits, hyphens (-), and underscores (_) are allowed.

    Backup Description

    The description can contain a maximum of 256 characters and cannot contain carriage returns or other special characters (! < " = ' > &).

    Database

    You can only select databases that you have created.

  5. Click OK to submit the backup task.
  6. The backup duration depends on the amount of instance data. After the backup is created, its status is Completed and its backup method is Physical backup.