Protecting SQL Server Databases in Multiple AWS Cloud Zones and Regions

By Dave Bermingham, Technical Evangelist at SIOS Technology High availability and disaster recovery protections both require redundant resources configured to minimize or eliminate single points of failure. Because failures sometimes occur on a large scale, a best practice is to put some geographical distance between some of these resources. Amazon Web Services meets this need by offering multiple Availability Zones and Regions to facilitate business continuity during all likely failures—from a single server crashing to a widespread natural disaster. This article provides practical guidance to help database and system administrators tasked with protecting SQL Server databases running in the AWS…