All Products
Search
Document Center

ApsaraDB RDS:Methods to restore an ApsaraDB RDS for SQL Server instance

Last Updated:Oct 21, 2024

This topic describes the methods that can be used to restore an ApsaraDB RDS for SQL Server instance.

Scenario

Method

References

Data restoration

Restoration to an existing RDS instance

Restore the data of an ApsaraDB RDS for SQL Server instance

Note

When you restore an individual database to an existing RDS instance, we recommend that you manually back up the database and then restore data to the point in time at which the manual backup file is generated. This method can be used to roll back data in scenarios such as application upgrades and releases. For more information, see Back up an ApsaraDB RDS for SQL Server instance.

Restoration to a new RDS instance (previously known as instance cloning)

Restoration to the original RDS instance by using a temporary RDS instance

Note

You can restore the data to the original RDS instance by using a temporary RDS instance. This method applies only to RDS instances that run SQL Server 2008 R2 with local SSDs.

Restoration across regions

Restore the data of an ApsaraDB RDS for SQL Server instance across regions

Restoration from backup files to a self-managed database

Download the backup files of an RDS instance. Then, restore data from the backup files to a self-managed database. For more information, see Download the data backup files and log backup files of an ApsaraDB RDS for SQL Server instance.

Migrate data to the cloud

Migration or restoration to a new RDS instance