Back up and Restore Amazon RDS SQL Databases
Commvault provides a solution that you can use to perform backup and restore operations on Amazon RDS SQL Server databases. Only full backups are supported for Amazon RDS SQL instances.
The Amazon Relational Database Service (RDS) provides configuration and scaling resources to host relational databases in the Amazon Web Services (AWS) cloud.
The solution includes the following components:
- A SQL client that meets the following requirements:
- Has port 1433 open so that it can communicate with the Amazon RDS instance
- The SQL Agent must be installed
- An Amazon RDS SQL instance
- An Amazon S3 bucket
- Master account credentials for the Amazon RDS SQL instance
If you cannot use a master account for the backup and restore operations, create a non-master user account with required permissions. For more information, see Creating a Non-Master User Account.
Note: If you upgraded from Service Pack 9 or Service Pack 10, then you can continue to use your existing client for backup and restore operations. You must create pseudo-clients for any additional Amazon RDS instances that you want to protect.
- Configure the Amazon database instance to have the native backup and restore option. For more information, see the Amazon article, Microsoft SQL Server Native Backup and Restore Support.
When configuring the backup and restore support, verify that the IAM role associated to the option group has the AWS permission policy to the S3 bucket or object with the following permissions:
- List (ListBucket)
- Read (GetBucketLocation, GetObject, ListMultipartUploadParts)
- Write (AbortMultipartUpload, PutObject)
The following sample script assigns the permissions policy to the IAM role:
- Add a pseudo-client for the Amazon account. For more information, see Creating a Pseudo-Client for an Amazon RDS Account.
An account can contain multiple RDS SQL instances.
- Add a SQL server to the pseudo-client for each Amazon RDS instance that you want to protect. For more information, see Adding Amazon RDS SQL instances to the Pseudo-client.
Perform a backup operation. For more information, see Backing Up Amazon RDS SQL Databases.
Determine your restore source and destination, and then perform one of the following tasks:
- Restore the Amazon SQL RDS backup to an Amazon RDS instance. For more information, see Restoring from an Amazon RDS Instance to Another Amazon RDS Instance.
- Restore an on-premises instance to an Amazon RDS instance. For more information see Restoring from an On-Premises SQL Instance to an Amazon RDS Instance.
- Restore an Amazon SQL RDS instance to an on-premises database. For more information see Restoring from an Amazon RDS Instance to an On-Premises SQL Database.
Last modified: 5/18/2021 9:00:03 AM