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.
Procedure
-
From the navigation pane, go to Protect > Databases.
The Instances page appears.
-
In the row for the instance, click the action button , and then click Restore.
The Backup content dialog box appears.
-
Select the content to restore, and then click Restore.
The Restore options dialog box appears.
-
From the Destination server list, select the SQL server to restore the data to.
-
From the Destination instance list, select the SQL server instance to restore the data to.
-
From the Proxy client list, select the access node to use for the restore.
-
In the Staging path on proxy client box, enter the full path for the location to stage the database to.
-
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.
-
To restore a database after dropping all existing connections to the database, select the Drop connections to database check box.
-
To change the database name, do the following:
-
Under Data files, select the file.
-
In the Database name box, enter the new name.
-
-
Click Submit.