You can recover data directly to an instance, and the specified backup data overwrites the data of the instance, but the data generated after creation of the specified backup data is lost. We recommend that you create a temporary instance for data recovery and migration to guarantee higher security.

Note
This method is only applicable to databases of SQL Server 2008 R2.

Procedure

  1. Log on to the RDS console.
  2. Select the region where the target instance is located.
  3. Click the ID of the target instance to enter the Basic Information page.
  4. Click Backup and Recovery in the left-side menu.
  5. Click the Backup List tab.
  6. Select a time range for recovery and click Query.
  7. Select the target backup file and click Coverage Restoration, as shown in the following figure.

  8. Click Confirm in the dialog box to recover data to the master instance.