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.
Overview
Syllabus
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
Taught by
PASS Data Community Summit
Related Courses
-
Administering Microsoft SQL Server Availability Groups
-
HA - DR in SQL Server - Putting the Puzzle Pieces Together and Planning for the Future
-
AlwaysOn en SQL Server 2016
-
SQL Server 2016 Always On Availability Groups Enhancements
-
Always-On Enhancements in SQL Server 2014
-
AlwaysOn AG - What's New on SQL Server
