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.

Database mirroring

Database mirroring - SQL Server Tutorial

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

Start my 1-month free trial

Database mirroring

“

- [Instructor] In this video, we'll discuss database mirroring. A word of caution before we continue. Microsoft has indicated that this feature will be removed in future versions. Their recommendation is to use Always On Availability Groups instead. We'll take a brief look at Always On Availability Groups in a later video. So, what is mirroring? Essentially it's a solution that allows you to increase the availability of a database. It's implemented on per-database basis and only works with databases that are set up with the full recovery model. Some of the benefits of working with database mirroring are that it increases the availability of a database. It also helps to increase data protection. And it improves the availability of a production database during upgrades. Essentially you have the ability to take a production database offline, switching over to the mirrored version of that database, and allow users to continue accessing the data as if nothing had happened. In terms of…

Contents