From the course: Microsoft SQL Server 2016 Essential Training
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Overview of high availability in SQL Server 2016 - SQL Server Tutorial
From the course: Microsoft SQL Server 2016 Essential Training
Overview of high availability in SQL Server 2016
- [Instructor] In this section, we're going to talk about the different high availability options in SQL Server 2016. When we talk about high availability we're talking about techniques and technologies to mask the effect of hardware, software, or network failure, maintain functionality, and minimize downtime. So basically, if something goes wrong, we want to hide that from the users and also minimize the amount of time that users can't access the database. All of the techniques involve some sort of secondary server. So, we'll have a main server, our primary server, and if something goes wrong with it, we can move the load to a secondary server that will have a copy of all or almost all of the data that was on the primary server. The high availability techniques in SQL Server 2016 are failover clustering, always-on availability groups, log shipping, and replication. Replication has some functionality in high availability. There's also other reasons to do replication other than high…
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.