Microsoft SQL Server has many native options to support high availability (HA) and disaster recovery (DR), to help ensure business continuity for your database workloads. This guide outlines an ideal configuration for SQL Server on Amazon Elastic Compute Cloud (Amazon EC2) in the Amazon Web Services (AWS) Cloud. Rehosting SQL Server on Amazon EC2 provides a self-managed system where you can retain full control over database operations and configuration.

The guide discusses SQL Server hybrid HA/DR options that include various AWS services and infrastructure, and provides guidance on infrastructure components and settings, including instance classes, storage options, configuration, and HA/DR setup. This document also explains how a given HA/DR strategy might fit into an example use case that has specific recovery time objective (RTO) and recovery point objective (RPO) requirements, and covers a few recovery scenarios, including relevant architecture diagrams. This guide doesn’t provide solutions designed for specific applications or requirements. It presents some HA/DR options based on RTO and RPO, so you can choose an architecture that matches your requirements.

https://docs.aws.amazon.com/prescriptive-guidance/latest/sql-server-ec2-ha-dr/welcome.html