From the course: SQL Server 2016: Administer a Database Infrastructure
Join today to access over 22,500 courses taught by industry experts or purchase this course individually.
Manage failover - SQL Server Tutorial
From the course: SQL Server 2016: Administer a Database Infrastructure
Manage failover
- Since each node in an availability group holds an identical copy of the database, any secondary node can become the primary node at a moment's notice. The process of choosing a new primary node is called a failover. In an always on availability group, there are three types of failovers that can occur. An automatic failover without data loss occurs when the primary and secondary replicas are set to the synchronous-commit mode, the secondary replica is currently synchronized, the failover mode is set to automatic, the primary replica goes offline unexpectedly, and the conditions of the flexible failover policy are met. We'll talk about the flexible failover policy in just a moment. The next type of failover is a planned manual failover, also without data loss. This is also simply called a manual failover. This situation is triggered by a database administrator. Like the automatic failover, the primary and secondary replicas need to be in the synchronous-commit mode, and the secondary…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.