Restoration Solutions
If your database is damaged or mistakenly deleted, you can restore it from backups.
Restoring a Mistakenly Deleted Instance
- RDS moves unsubscribed yearly/monthly instances and deleted pay-per-use instances to the recycle bin. You can rebuild a DB instance that was deleted up to 7 days ago from the recycle bin. For details, see Rebuilding a DB 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
|
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
- You can restore data to an RDS for SQL Server instance from backups. For details, see Restoring from Backup Files to RDS for SQL Server Instances and PITR: Restoring a DB Instance to a Point in Time.
- You can migrate data to an RDS for SQL Server instance using Data Replication Service (DRS) or Data Admin Service (DAS). For details, see Migration Solution Overview.
Restoring or Migrating Data to a Self-Managed SQL Server Database
- You can restore data to a self-managed SQL Server database from backups. For details, see Restoring from Backup Files to a Self-Managed SQL Server Database Using SSMS.
- You can migrate data to a self-managed SQL Server database using DRS. For details, see From Microsoft SQL Server to Microsoft SQL Server.
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot