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

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Always On

Always On - SQL Server Tutorial

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

Start my 1-month free trial

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 WSFC failover cluster hosting the availability group. So this is a…

Contents