Features not supported and features with limited support - Amazon Relational Database Service
Services or capabilities described in Amazon Web Services documentation might vary by Region. To see the differences applicable to the China Regions, see Getting Started with Amazon Web Services in China (PDF).

Features not supported and features with limited support

The following Microsoft SQL Server features aren't supported on Amazon RDS:

  • Always On Availability Groups (AGs)

  • Backing up to Microsoft Azure Blob Storage

  • Buffer pool extension

  • Custom password policies

  • Data Quality Services

  • Database Log Shipping

  • Database snapshots (Amazon RDS supports only DB instance snapshots)

  • Extended stored procedures, including xp_cmdshell

  • FILESTREAM support

  • File tables

  • Machine Learning and R Services (requires OS access to install it)

  • Maintenance plans

  • Performance Data Collector

  • Policy-Based Management

  • PolyBase

  • Replication

  • Resource Governor

    In a multi-tenancy environment, we recommend understanding performance requirements and considerations to minimize problems due to workload competition for resources.

  • Server-level triggers

  • Service Broker endpoints

  • Stretch database

  • TRUSTWORTHY database property (requires sysadmin role)

  • T-SQL endpoints (all operations using CREATE ENDPOINT are unavailable)

  • WCF Data Services

The following Microsoft SQL Server features have limited support on Amazon RDS:

The following features aren't supported on Amazon RDS with SQL Server 2022:

  • Suspend database for snapshot

  • External Data Source

  • Backup and restore to S3 compatible object storage

  • Object store integration

  • TLS 1.3 and MS-TDS 8.0

  • Backup compression offloading with QAT

  • SQL Server Analysis Services (SSAS)

  • Database mirroring with Multi-AZ deployments. SQL Server Always On is the only supported method with Multi-AZ deployments.