Restoring an Amazon RDS Instance to an On-Premises SQL Server Instance

You can restore an Amazon RDS for SQL Server instance to an on-premises SQL Server instance.

Procedure

From the navigation pane, go to Protect > Databases.

The Overview page appears.
On the Instances tab, click the instance.

The instance properties page appears.
On the Overview tab, in the Recovery points section, choose the date and time for the backup you want to use, and then click RESTORE.

The Backup content page appears.
Select the content to restore, and then click RESTORE.

The Restore options dialog box appears.
From the Restore type list, select Cross instance restore.
From the Destination server list, select the server to restore the data to.
From the Destination instance list, select the instance to restore the data to.
Configure options related to the Destination server and the Destination instance you have selected.

The following three fields may or may not appear, depending on your destination server and destination instance selections.
1. To specify the access node, from the Access node list, select an access node.
2. To specify the staging instance, from the Staging instance list, select an instance.
3. To specify a staging path, in the Staging path box, enter the staging path on the access node or the destination server.
To change a database name, do the following:
1. Under Redirect options, which is under Data files, click the Edit (pencil) button in the row for the database.
  
  The Edit database options dialog box appears.
2. In the Database name box, enter the new name.
To specify pre or post commands, under Pre or Post options, which are under Advanced options, do the following:
1. In the Pre recovery command box, enter the path of the process to run before the restore.
2. In the Post recovery command box, enter the path of the process to run after the restore.
3. To run a post process for all restore operation attempts of a job phase, whether it is successful, interrupted, suspended, or when the job fails, select Run post restore process for all attempts.
4. To specify the user to run the pre and post commands, move the Run as User toggle button to the right and type the user name and password.
To select a Backup Gateway to use for the recovery, under Data path, from the Select MediaAgent list, select a Backup Gateway server.
To start the database in a suspended state, under Startup options, move the Start up in suspended state toggle to the right and type the Dependent job ID.
Click SUBMIT.