> Software > Protect > Databases > Amazon Web Services > Amazon RDS > Amazon RDS Using Export > SQL Server > Getting Started

System Requirements for Amazon RDS for SQL Server

Verify that your AWS infrastructure and access nodes meet the requirements for Amazon RDS for SQL Server backup and restore operations before you configure protection with Commvault.

Amazon RDS for SQL server environment

To back up and restore your Amazon RDS for SQL Server databases, your AWS environment must meet the following requirements:

  • Amazon RDS account: Required to access your RDS SQL instances.

  • Amazon RDS SQL instance: The database you plan to back up and restore.

  • Amazon S3 bucket for staging: Commvault uses this bucket to stage backup data during operations.

  • Native backup and restore option: Enable this option for the RDS SQL instance. For instructions, see Adding the native backup and restore option in the AWS documentation.

    The IAM role associated with the option group must have access to the S3 bucket as configured in the Amazon RDS SQL S3 permissions file.

Authentication requirements

You must use one of the following accounts for Amazon RDS for SQL Server backup and restore operations:

Use an Active Directory account

You can use an Active Directory (AD) account for backup operations when the following requirements are met:

  • Configure an Active Directory admin for the RDS instance on the Amazon AWS portal.

  • The AD account must be a local administrator on the access node.

  • The AD account must have the permissions required for a non-master user and the "Create any database" securable permission on the RDS SQL instance.

  • Enter the account in user_name@domain_name format.

  • Provide the AD account credentials in the SQL Agent Authentication tab at the agent level or the Accounts tab at the instance level.

AD account credentials are honored only when the server admin isn't set at either the agent or instance level.

Access nodes

Your deployment must include at least one access node that Commvault uses to perform backup and restore operations on the RDS database.

Access node configuration

  • Required packages: The SQL Server package is required on the access node.

  • Operating system: Access nodes must run one of the following supported operating systems:

    Operating system Processor architecture
    Amazon Linux 2 AMI (HVM) - Kernel 5.10, SSD Volume Type 64-bit (x86)
    Red Hat Enterprise Linux 9.x, 8.x x64, Compatible processors
    Rocky Linux 9.x, 8.x x64, Compatible processors
    Windows 2022, 2019, 2016 x64, Compatible processors

  • Supported instance families: For supported Amazon EC2 instance families that you can use as access nodes, see Supported Amazon EC2 Instance Families.

If you use the Access and Secret Key method for authentication, you can use an EC2 or an on-premises SQL client as the access node.

Supported configurations

SQL Server versions

Commvault supports all versions and editions of Microsoft SQL Server that AWS supports, including:

  • SQL Server 2022

  • SQL Server 2019

  • SQL Server 2017

  • SQL Server 2016

For current AWS SQL Server version support, see Microsoft SQL Server on Amazon RDS in the AWS documentation.

Network and infrastructure requirements

Access node connectivity

Access nodes must have the following network connectivity for backup and restore operations:

  • Upstream connectivity: Access nodes must have Layer 3 network connectivity to the upstream MediaAgent on port 8403. If the MediaAgent and access node are in different AWS accounts or different Virtual Private Clouds (VPCs), you can configure Amazon VPC peering. For more information, see VPC peering basics in the AWS documentation.

  • AWS service endpoints: Access nodes must have connectivity to regional and global AWS service endpoints. For more information, see Requirements for Connectivity to AWS Service Endpoints.

  • RDS database connectivity: Access nodes must be able to connect to the RDS instance over its database port, such as port 1433 for SQL Server, unless you configure a custom port.

Storage space

A minimum of 100 GB of disk space is recommended on the access node. If you configure a staging directory on the access node, the actual space needed depends on the database size and configured settings.

User account privileges

For UNIX-based access nodes, you don't require a root user account to install or operate the backup and restore solution. Use a non-root user account with sudo privileges for installation and operations. For more information, see installation of UNIX agents by a non-root user with sudo privileges.

×

Loading...