Restore the data of an RDS SQL Server instance

Restore data to an existing RDS instance

You can restore the data of one or more databases from an RDS instance by backup set or time to this RDS instance or to another existing RDS instance.

This function is available to SQL Server 2012 and SQL Server 2016.

1. Log on to the RDS console.
2. In the upper-left corner, select the region where the target RDS instance is located.
3. Find the target RDS instance and click the instance ID.
4. In the left-side navigation pane, click Backup and Restoration.
5. In the upper-right corner, click Restore.
6. In the displayed dialog box, select Restore to Existing Instance and click OK.
7. Set the following parameters and click OK.
   Note

   • If two databases have the same name, you must select New Name and modify the database names.
   • A new database name can contain lowercase letters, digits, underscores (_), and hyphens (-).

   Parameter	Description
   Restore Method	By Time: You can select any time point within the specified log retention period. For more information about how to view or change the log retention period, see Back up the data of an RDS SQL Server instance. By Backup Set: You can specify a full or incremental backup set from which you want to restore data.
   Restore Time	Select the time point from which you want to restore data. This parameter is displayed when the Restore Method parameter is set to By Time.
   Backup Set	Select the backup set from which you want to restore data. This parameter is displayed when the Restore Method parameter is set to By Backup Set.
   Instance	Select the destination RDS instance to which you want to restore data. By default, the system displays the RDS instances (including the source RDS instance) that are created by the same Alibaba Cloud account, located in the same region, and use the same DB engine version as the source RDS instance. Note If a large number of RDS instances are displayed, you can enter keywords in the search field to find the RDS instance you want.
   Databases to Restore	Select the databases you want to restore. By default, all databases of the source RDS instance are displayed and selected. If you want to restore the data of the whole instance, make sure that all databases are selected. If you want to restore one or more databases, make sure that these databases are selected. Set the names of the restored databases. By default, the system uses the original database names. Note The names of the restored databases cannot be the same as those of the existing databases in the destination RDS instance.

Restore data to a new RDS instance

You can restore the data of an RDS instance by backup set or time to a new RDS instance. If you choose to restore data by backup set, you can restore some or all databases in the selected backup set.

You must pay for the new RDS instance.

This function is available to SQL Server 2012, SQL Server 2016, and SQL Server 2017.

1. Log on to the RDS instance.
2. In the upper-left corner, select the region where the target RDS instance is located.
3. Find the target RDS instance and click the instance ID.
4. In the left-side navigation pane, click Backup and Restoration.
5. In the upper-right corner, click Restore.
6. In the displayed dialog box, select Restore to New Instance and click OK.
7. Select a billing method and set the parameters of the new RDS instance.

   Parameter	Description
   Restore Mode	By Time: You can select any time point within the specified log retention period. By Backup Set: You can specify a full or incremental backup set from which you want to restore data.
   Restore Point	Select the time point from which you want to restore data. This parameter is displayed when the Restore Method parameter is set to By Time.
   Backup Set	Select the backup set from which you want to restore data. This parameter is displayed when the Restore Method parameter is set to By Backup Set.
   Database	All: to restore all databases in the selected backup set. Part: to restore some databases in the selected backup set. If you select this option, you must select the databases you want to restore from the left list, and add them to the right list.
   Edition/Zone/CPU and Memory/Capacity/Network Type/Duration	For more information, see Create an RDS SQL Server instance.
   Quantity	Specify the number of RDS instances you want to purchase. You can create up to five RDS instances at a time for data restoration.

8. Click Buy Now.
9. On the Order Confirmation page, select Terms of Service, Service Level Agreement, and Terms of Use, and click Pay Now to complete the payment.

Restore data to the source RDS instance through a temporary instance