Restoring from an Amazon RDS Instance to Another Amazon RDS Instance

Perform this procedure from Amazon RDS SQL client where you performed the backup.

When you perform this type of restore, the Amazon RDS database instance name and physical path do not need to be edited because the restore goes to the default path.

If you just change the database name to perform an out-of-place restore to the same instance, it does not work because the database file name already exists in the default path.

Before You Begin

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

Procedure

  1. From the navigation pane, go to Protect > Applications > Cloud Apps.

    The Cloud Apps page appears.

  2. Click the Amazon SQL tile.

    The Apps page appears.

  3. In the Restore column for the Amazon app, click Restore.

    The Backup content dialog box appears.

  4. Optional: Select a backup. From the Showing latest backup list, select one of the following options:

    • To show the latest backup, select Show Latest Backup.

    • To show a backup at a specific time, select Show backup as a of a specific date, and then type the date and time.

    • To show backups for a date range, select Show backup for a date range, and then specify the dates.

  5. Select the database that you want to restore, and then click Restore.

    The Restore options dialog box appears.

  6. In the Destination server list, select the Amazon RDS SQL server to which you want to restore the data.

  7. In the Destination instance list, select the SQL server instance to which you want to restore the data.

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

  9. In the Staging path on proxy client box, specify the full path on the destination client where the Commvault software stages the database.

  10. To overwrite the files of any other database that is currently using the database that you specify, select the Unconditionally overwrite existing databases or files check box.

  11. To restore a database after dropping all existing connections to the database, select the Drop connections to database check box.

  12. Optional: To change the database name, under Data files, select the file, and then in the Database name box, type the new name.

  13. Click Submit.

Loading...