SQL Server AlwaysOn Quickstart

Explore SQL Server AlwaysOn high availability and disaster recovery solutions in this comprehensive 1-hour session. Gain insights into various protection levels offered through Windows Clustering, SQL Clustering, and Availability Groups. Learn how these components work together to safeguard databases, and delve into availability group configuration. Discover new capabilities and updates in SQL Server 2014. Cover topics such as multi-site clustering, flexible failover policy, database prerequisites, and availability group architecture. Understand concepts like automatic and manual failover, multiple replicas, and availability group listeners. Perfect for database administrators and IT professionals seeking to enhance their SQL Server management skills.

Intro
Technical Assistance
Ryan Adams
Objectives
What does Always On do for me?
What services can be clustered?
Multi-site Clustering
TempDB
Flexible Failover Policy
Requirements
Database Prerequisites
WSFC Underlying Support for AGS
Availability Group Architecture
Avati-database Failover
Multiple Replicas
Automatic
Manual
What are they?
Availability Group Listener
Summary