• Relational Database Service

rds
  1. Help Center
  2. Relational Database Service
  3. User Guide
  4. Managing DB Instances
  5. Backups and Restorations
  6. Creating a Manual Backup

Creating a Manual Backup

Scenarios

RDS allows you to create manual backups of a running primary DB instance. You can use these backups to restore data.

NOTE:

When you delete a DB instance, its automated backups are also deleted but its manual backups are retained.

Method 1

  1. Log in to the management console.
  2. Click in the upper left corner and select a region and a project.
  3. Click Service List. Under Database, click Relational Database Service to go to the RDS console.
  4. On the Instance Management page, locate the target DB instance and choose More > Create Backup in the Operation column.
  5. In the displayed dialog box, enter a backup name and description. For Microsoft SQL Server, select a target database for which you want to create a backup. Then, click OK.

    • The backup name must consist of 4 to 64 characters and start with a letter. It can contain only uppercase letters, lowercase letters, digits, hyphens (-), and underscores (_).
    • The description must consist of a maximum of 256 characters and cannot contain the carriage return character or the following special characters: >!<"&'=
    • The time required for creating manual backups depends on the data volume.

  6. After a manual backup has been created, you can view and manage it on the Instance Management page.

    You can also click the target DB instance and manage its backup on the Backups & Restorations page.

Method 2

  1. Log in to the management console.
  2. Click in the upper left corner and select a region and a project.
  3. Click Service List. Under Database, click Relational Database Service to go to the RDS console.
  4. On the Backup Management page, click Create Backup.
  5. In the displayed dialog box, select a primary DB instance, select the database to be backed up for Microsoft SQL Server, specify Backup Name and Description, and click OK.

    • A backup can only be created for an available primary DB instance. You cannot create a backup for a DB instance that is being backed up or for which a backup is already being created.
    • The backup name must consist of 4 to 64 characters and start with a letter. It can contain only uppercase letters, lowercase letters, digits, hyphens (-), and underscores (_).
    • The description must consist of a maximum of 256 characters and cannot contain the carriage return character or the following special characters: >!<"&'=
    • The time required for creating manual backups depends on the data volume.

  6. After a manual backup has been created, you can view and manage it on the Instance Management page.

    You can also click the target DB instance and manage its backup on the Backups & Restorations page.

Method 3

  1. Log in to the management console.
  2. Click in the upper left corner and select a region and a project.
  3. Click Service List. Under Database, click Relational Database Service to go to the RDS console.
  4. On the Instance Management page, click the target DB instance.
  5. On the Backups & Restorations page, click Create Backup. In the displayed dialog box, select the database to be backed up for Microsoft SQL Server, specify Backup Name and Description, and click OK.

    • The backup name must consist of 4 to 64 characters and start with a letter. It can contain only uppercase letters, lowercase letters, digits, hyphens (-), and underscores (_).
    • The description must consist of a maximum of 256 characters and cannot contain the carriage return character or the following special characters: >!<"&'=
    • The time required for creating manual backups depends on the data volume.

  6. After a manual backup has been created, you can view and manage it on the Instance Management page.

    You can also click the target DB instance and manage its backup on the Backups & Restorations page.