From the course: Microsoft SQL Server 2016: Installation and Administration

Unlock this course with a free trial

Join today to access over 25,300 courses taught by industry experts.

Always On

Always On - SQL Server Tutorial

From the course: Microsoft SQL Server 2016: Installation and Administration

Start my 1-month free trial Buy for my team

Always On

“

- [Instructor] The two main availability options that SQL Server 2016 supports and that will be used in place of mirroring, are always on fail over clustering and always on availability groups. We'll discuss the availability groups option in this video. The always on groups is intended to replace the legacy mirroring technology. Always on maximizes the availability of a set of user databases, typically for an enterprise. An availability group supports a failover environment for a discrete set of user databases, and those are typically known as availability databases. And these will fail over together. An availability group supports a set of read-write primary databases and one to eight sets of secondary databases. Optionally, secondary databases can be made available for read-only access and/or for some background operations. To support always on availability groups, a server instance must reside in a node on the…

Contents