You can restore an Amazon RDS for SQL Server instance to an on-premises SQL Server instance.
Perform this procedure from the Amazon RDS for SQL Server client where the backup that you want to restore was performed.
Procedure
-
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 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.