You can restore an on-premises SQL Server instance to an Amazon RDS for SQL Server instance.
Before You Begin
-
Perform a full backup. For more information, see Backing Up Amazon RDS SQL Databases.
Note
The backup must be a single stream traditional backup. If you select a point-in-time restore, then the software restores the full backup and discards the log backups.
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 Amazon RDS 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.