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 availability so it's not just…