Updated on 2023-09-26 GMT+08:00

Deleting a Pay-per-Use DB Instance or Read Replica

Scenarios

To release resources, you can delete DB instances or read replicas billed on the pay-per-use basis as required on the Instances page. (To delete DB instances or read replicas billed on the yearly/monthly basis, you need to unsubscribe from the order. For details, see Unsubscribing a Yearly/Monthly DB Instance.)

Constraints

  • DB instances cannot be deleted when operations are being performed on them. They can be deleted only after the operations are complete.
  • If a backup of a DB instance is being restored, the instance cannot be deleted.
  • If you delete a pay-per-use DB instance, its automated backups will also be deleted and you will no longer be billed for them. Manual backups, however, will be retained and generate additional costs.
  • If you delete a primary DB instance, its standby DB instance and read replicas (if any) are also deleted automatically. Exercise caution when performing this operation.
  • You will not be billed for the instances that were not successfully created.
  • Deleted DB instances cannot be recovered and resources are released. Exercise caution when performing this operation. If you want to retain data, create a manual backup first before deleting the DB instance.
  • You can rebuild a DB instance that was deleted up to 7 days ago from the recycle bin.
  • You can use a manual backup to restore a DB instance. For details, see Restoring from Backup Files to RDS for SQL Server Instances.

Deleting a Pay-per-Use DB Instance

  1. Log in to the management console.
  2. Click in the upper left corner and select a region and a project.
  3. Click in the upper left corner of the page and choose Databases > Relational Database Service.
  4. On the Instances page, locate the primary DB instance to be deleted and click More > Delete in the Operation column.

    Figure 1 Deleting a DB instance

  5. In the displayed dialog box, click Yes.
  6. If you have enabled operation protection, click Send Code in the displayed Identity Verification dialog box and enter the obtained verification code. Then, click OK.

    Two-factor authentication improves the security of your account and cloud product. For details about how to enable operation protection, see Identity and Access Management User Guide.

  7. Refresh the DB instance list later to confirm that the deletion was successful.

Deleting a Pay-per-Use Read Replica

  1. Log in to the management console.
  2. Click in the upper left corner and select a region and a project.
  3. Click in the upper left corner of the page and choose Databases > Relational Database Service.
  4. On the Instances page, locate the target DB instance and click . All the read replicas created for the DB instance are displayed.
  5. Locate the read replica to be deleted and click More > Delete in the Operation column.

    Figure 2 Deleting a read replica

  6. In the displayed dialog box, click Yes.
  7. If you have enabled operation protection, click Send Code in the displayed Identity Verification dialog box and enter the obtained verification code. Then, click OK.

    Two-factor authentication improves the security of your account and cloud product. For details about how to enable operation protection, see Identity and Access Management User Guide.

  8. Refresh the DB instance list later to check that the deletion is successful.