FAQ - AWS Prescriptive Guidance

FAQ

This section provides answers to commonly raised questions about downgrading from SQL Server Enterprise edition to Standard edition and using Amazon RDS for SQL Server.

Can I change the Amazon RDS for SQL Server edition that I'm running for a DB instance (for example, from SQL Server 2016 Standard edition to Enterprise edition)?

Yes, to change the edition and retain your data, take a snapshot of your running DB instance, and create a DB instance of the desired edition from that snapshot. Then delete the old DB instance, unless you want to keep it running.

Which Microsoft SQL Server database editions are available with Amazon RDS for SQL Server?

Amazon RDS supports Microsoft SQL Server versions 2012–2019 and the following editions:

  • Enterprise

  • Standard

  • Web

  • Express

For more information about supported versions and editions, see Microsoft SQL Server on Amazon RDS.

If I change the Amazon RDS for SQL Server edition (for example, change from Enterprise edition to Standard edition), do I need to buy new licenses?

When you set up an Amazon RDS DB instance for Microsoft SQL Server, the software license is included. This means that you don't need to purchase SQL Server licenses separately. AWS holds the license for the SQL Server database software.

What types of licensing options are available with Amazon RDS for SQL Server?

When you set up an Amazon RDS DB instance for Microsoft SQL Server, the software license is included. This means that you don't need to purchase SQL Server licenses separately. AWS holds the license for the SQL Server database software. Amazon RDS pricing includes the software license, underlying hardware resources, and Amazon RDS management capabilities.

What are the licensing policies for using Amazon RDS for SQL Server?

Amazon RDS for SQL Server uses the License Included service model, so you do not need separately purchased SQL Server licenses. The SQL Server database software has been licensed by AWS for your use subject to Section 10.4 of the AWS Service Terms.

How does the license option impact DB instance scaling?

DB instances running SQL Server can be scaled up and down at any point, subject to the prevailing hourly pricing for each DB instance class.

How can I migrate from an on-premises or an Amazon EC2 Enterprise edition of SQL Server to Standard edition on AWS?

Migrating from Enterprise edition to Standard edition requires logical export of data from the Enterprise edition database and importing the data into the Standard edition database instance. To move your data, use backup and restore or AWS Database Migration Service (AWS DMS).

How can I reduce downtime when downgrading my Enterprise edition SQL Server database to Standard edition?

To reduce overall downtime, bulk load data into your Standard edition database. You can use backup and restore and logical replication tools such as AWS DMS to synchronize your Standard edition database.

Can I have high availability in my Standard edition of Amazon RDS for SQL Server?

Amazon RDS currently uses synchronous replication technology and automatic failover functionality to provide Multi-AZ deployments for SQL Server DB instances. Multi-AZ deployments are available for all SQL Server database editions that are supported by Amazon RDS.

How can I monitor the performance of my Amazon RDS for SQL Server Standard edition DB instance?

To monitor your Standard edition DB instance, you can use Amazon RDS Performance Insights, Enhanced Monitoring, and Amazon CloudWatch.

Can I have encryption on my Amazon RDS for SQL Server Standard edition DB instance?

Amazon RDS can encrypt your Amazon RDS DB instances. Data that is encrypted at rest includes the underlying storage for DB instances, its automated backups, read replicas, and snapshots. To enable encryption in transit, you can use Secure Sockets Layer (SSL) encryption for a SQL Server DB instance with the rds.force_ssl parameter.

How is Amazon RDS for SQL Server supported?

If you have an active AWS Support account, you can contact AWS Support for service requests relating to Amazon RDS or SQL Server.

How do I know if Amazon RDS supports a specific SQL Server database feature?

The SQL Server features that Amazon RDS for SQL Server supports vary, depending on the edition of SQL Server. For information about the SQL Server features that Amazon RDS currently supports, see the Amazon RDS User Guide.