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 | ||
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 |