Multi-AZ deployment ___________ supported for Microsoft SQL Server DB Instances.
A.
is not currently
B.
is as of 2013
C.
is planned to be in 2014
D.
will never be
Multi-AZ deployment ___________ supported for Microsoft…
Multi-AZ deployment ___________ supported for Microsoft SQL Server DB Instances.
Outdated question. It’s currently supported.
http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_SQLServerMultiAZ.html
Amazon RDS supports Multi-AZ with Mirroring for the following SQL Server versions and editions:
SQL Server 2016: Standard and Enterprise Editions
SQL Server 2014: Standard and Enterprise Editions
SQL Server 2012: Standard and Enterprise Editions
SQL Server 2008 R2: Standard and Enterprise Editions
Amazon RDS supports Multi-AZ with Mirroring for SQL Server in all AWS Regions, with the following exceptions:
Not supported
US West (N. California)
Asia Pacific (Singapore)
AWS GovCloud (US)
Supported in most cases
Asia Pacific (Sydney) – Supported for DB instances in VPCs.
Asia Pacific (Tokyo) – Supported for DB instances in VPCs.
South America (São Paulo) – Supported on all DB instance classes except m1 or m2.
It is now supported.
Multi-AZ Deployments for Microsoft SQL Server with Database Mirroring
Amazon RDS supports Multi-AZ deployments for DB instances running Microsoft SQL Server by using SQL Server Database Mirroring. Multi-AZ deployments provide increased availability, data durability, and fault tolerance for DB instances. In the event of planned database maintenance or unplanned service disruption, Amazon RDS automatically fails over to the up-to-date standby so database operations can resume quickly without manual intervention. The primary and standby instances use the same endpoint, whose physical network address transitions to the mirror as part of the failover process. You don’t have to reconfigure your application when a failover occurs.
https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_SQLServerMultiAZ.html