Loading...

Amazon RDS SQL Server Databases

Commvault provides a solution that you can use to perform backup and restore operations on Amazon RDS SQL Server databases.

The Amazon Relational Database Service (RDS) provides configuration and scaling resources to host relational databases in the Amazon Web Services (AWS) cloud.

Configuration Prerequisites

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.

Configuration

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:

    "Statement":[
    {
    "Effect":"Allow",
    "Action":[
    "s3:ListBucket",
    "s3:GetBucketLocation",
    ],
    "Resource":[
    "arn:aws:s3:::bucket_name"
    ]
    },
    {
    "Effect":"Allow",
    "Action":[
    "s3:ListBucket",
    "s3:GetBucketLocation",
    "s3:GetObject",
    "s3:PutObject",
    "s3:ListMultipartUploadParts",
    "s3:AbortMultipartUpload"
    ],
    "Resource":[
    "arn:aws:s3:::bucket_name/*"
    ]
    }
    ]
    }

Last modified: 1/25/2021 5:53:37 PM