SQL Server Administration and Maintenance

SQW04 SQL Server High Availability and Disaster Recovery

11/18/2015

11:00am - 12:15pm

Level: Intermediate

Chad Churchwell

Premier Field Engineer

Microsoft

This session will cover the different methods used to make SQL Server highly available, as well as to protect your SQL Server instance in the event of a disaster. We'll compare the pros and cons of each technology and discuss design decisions when choosing a technology. We'll cover clustering, log shipping, mirroring, and AlwaysOn Availability groups.

You will learn:

  • The different technologies available in SQL Server
  • The limitations and use cases for each technology
  • Information to take back to your organization to make recommendations for a solid HA/DR plan