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

Back Up and Restore Amazon RDS for SQL Server 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.

Configuration Prerequisites

The solution includes the following components:

  • A Windows 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 for Amazon RDS SQL Database Backups.

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.

  1. 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/*"
        ]
    }
]
}

  2. 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.

  3. 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.

Backups

Perform a backup operation. For more information, see Backing Up Amazon RDS SQL Databases.

Restores

Determine your restore source and destination, and then perform one of the following tasks:

Loading...