Always On and High Availability for SQL
The Most Addictive Python and SQL Courses
NY State-Licensed Certificates in Design, Coding & AI — Online
Overview
Build a Learning Habit
Download Class Central's free printable study calendar
Download for Free
Explore the fundamental components of SQL Server's Always On High Availability Groups in this 53-minute video. Dive into this robust disaster recovery solution that replaced Database Mirroring technologies in SQL Server 2012. Learn how to configure two SQL instances to host replicas of database sets, ensuring zero or near-zero data loss. Understand why this technology has become the standard for critical production SQL Server instances. Cover topics including disaster recovery, active-passive configurations, database replication, SQL Server mirroring, Always On implementation in virtual machines, cluster services, and live migration. Gain insights into the evolution of SQL Server's high availability features and their practical applications in modern database management.
Syllabus
Introduction
Disaster Recovery
Sequel Server
Active Passive
Stand By
Database Replication
SQL Server Mirror
Always On
Always On in Virtual Machine
Virtual Machine Example
Cluster Service
Cluster Code
Live Migration
Taught by
Learnit Training