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

Perform this procedure from on-premises SQL database client.

Before You Begin

If the database is bigger than 4GB, then add the nConcurrentUploadRequestCount 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 on 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.

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. For more information about data streams for SQL backups, see Configuring Data Streams for Backups Using the SQL Server Agent.

From the CommCell Browser, click Client Computers > client > SQL Server.
Right-click the instance, point to All Tasks, and then click Browse and Restore.

The Browse and Restore dialog box appears.
On the Time Range tab, select Latest Backup, and then click View Content.
Select the databases to restore, and then click Recover All Selected.

The Restore Options dialog box appears.
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. To restore the database to the same location from where it was backed up, select the Unconditionally overwrite existing database or files check box.
4. 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.
5. Optional: 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.
Click OK.