Help Center/ Relational Database Service_RDS for SQL Server/ User Guide/ Data Restorations/ Restoration Solutions
Updated on 2026-09-11 GMT+08:00
View PDF
Share

Restoration Solutions

If your database is damaged or mistakenly deleted, you can restore it from backups.

Restoring a Mistakenly Deleted Instance

  • Using the recycle bin: RDS allows you to move unsubscribed yearly/monthly instances and deleted pay-per-use instances to the recycle bin. You can rebuild an instance that was deleted up to 7 days ago from the recycle bin. For details, see Rebuilding an Instance.
  • You can restore a deleted instance from its retained manual backups. For details, see Restoring from Backup Files to RDS for SQL Server Instances.

Restoring Mistakenly Deleted or Modified Data of a DB Instance

Table 1 Restoration solutions

Solution

Category

Storage Type

Restoration Time Point

Scope

Restore To

Time Required

Cloud SSD

Extreme SSD

Point in Time When a Backup Was Generated

Any Point in Time Within a Specified Range

All Databases and Tables

Certain Databases and Tables

Existing Instance Other than the Original Instance

Restoring an entire instance

Restoration from backups

√

√

√

x

√

x

√

Depending on how much data there is in the instance

Point-in-time recovery (PITR)

√

√

√

√

√

x

√

Depending on how much data there is in the instance

Restoring or Migrating Data to an RDS for SQL Server Instance

Restoring or Migrating Data to a Self-Managed SQL Server Database

Parent Topic: Data Restorations