> Documentation > Backup and Restore Agents > Databases > Amazon Web Services > Amazon RDS > Amazon RDS Protection Using Native Database Export or Dump Utility > Amazon RDS for SQL Server

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

You can restore an on-premises SQL instance to an Amazon RDS instance. You can perform the restore operation from the on-premises SQL database client.

Before You Begin

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

    Note

    The backup must be a single stream traditional backup. By default, the SQL iDA uses 2 streams. Before running a backup on on-premises server, you must go to the data storage policy tab of a subclient and change the number of streams to 1. For more information about data streams for SQL backups, see Configuring Data Streams for Backups Using the SQL Server Agent. If you select a point-in-time restore, the Commvaultsoftware restores the full backup and discards the log backups.

  • To avoid timeout during database restore, add the nConcurrentUploadRequestCount additional setting to the number of concurrent requests that can be used to upload the native backup file to the Amazon S3 bucket during the restore operation. To the SQL client, add the additional setting as shown in the following table.

    For instructions about how to add additional settings from the CommCell Console, see Add or Modify an Additional Setting.

Property

Value

Name

nConcurrentUploadRequestCount

Category

MSSQL

Type

Integer

Value

The number of requests.

Procedure

  1. From the CommCell Browser, go to Client Computers > client > SQL Server.

  2. Right-click the instance, point to All Tasks, and then click Browse and Restore.

    The Browse and Restore dialog box appears.

  3. On the SQL Server tab, select Restore out of place.

  4. On the Time Range tab, select Latest Backup, and then click View Content.

  5. Select the databases to restore, and then click Recover All Selected.

    The Restore Options dialog box appears.

  6. On the General tab, provide the destination information.

    1. From the Destination Server list, select the Amazon RDS SQL server.

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

    3. In the Staging Path on Proxy Client box, specify the full path on the source client where the Commvault software stages the database.

      You can use Browse to select the folder.

    4. To change the database name, in the Database column, type a new name for the database.

      Repeat this step for each database that you want to change.

  7. Click OK.

Loading...