Restoring from an Amazon RDS Instance to Another Amazon RDS Instance

You can restore an Amazon RDS for SQL Server instance to a different Amazon RDS for SQL Server instance. This is an out-of-place restore.

When you perform this type of restore, you don't need to edit the physical path, because the restore uses the default path. If you edit the database name to perform an out-of-place restore to the same instance, AWS internally modifies the datafiles, since a database with the same data file names already exists. If a database with the same name already exists on the destination instance, it is deleted and recreated.

Before You Begin

Perform a full backup. For more information, see Backing Up Amazon RDS SQL Databases.

Procedure

1. From the CommCell Browser, click Client Computers > client > SQL Server.

2. Right-click the instance, point to All Tasks, and then click Browse and Restore.

   The Browse and Restore dialog box appears.

3. On the Time Range tab, select Latest Backup, and then click View Content.

4. Select the databases to restore, and then click Recover All Selected.

   The Restore Options dialog box appears.

5. On the General tab, provide the destination information.

   1. From the Destination Server list, select the Amazon RDS SQL server.

   2. From the Proxy Client list, select the proxy server that you want to use for the restore.

   3. To restore the database to the same location from where it was backed up, select the Unconditionally overwrite existing database or files check box.

   4. In the Staging Path on Proxy Client box, specify the full path on the destination client where the Commvault software stages the database. You can use Browse to select the folder.

   5. Optional: To change the database name, in the Database column, type a new name for the database.

      Repeat this step for each database that you want to change.

6. Click OK.