SQL Server Administration and Maintenance

SQH01 Stretching SQL Server Failover Clustered Instances & Availability Groups to a Disaster Recovery Site

12/08/2016

8:00am - 9:15am

Level: Intermediate to Advanced

Edwin Sarmiento

Managing Director

15C

Dealing with SQL Server Failover Clustered Instances and Availability Group for local high availability is already complicated with many external dependencies such as the network and the Windows Server Failover Cluster (WSFC.) It becomes even more complicated when you stretch it out to a disaster recovery site. In this session, learn the five things you need to consider when you implement SQL Server Failover Clustered Instances and Availability Group for disaster recovery. You'll cover how Active Directory, DNS, WSFC heartbeat and quorum configuration affects deployments of SQL Server Failover Clustered Instances and Availability Group in a disaster recovery site and how to properly configure a client application for connectivity.

You will learn:

  • Five things to consider when stretching SQL Server failover clustered instances and Availability Groups to a disaster recovery site
  • How to properly configure Active Directory and DNS as part of a SQL Server failover clustered instances and Availability Groups topology
  • How to properly configure Windows Server Failover Clustering heartbeat and quorum for disaster recovery implementations