Chapter 12. Implementing and Managing Database Mirroring

This chapter takes a systematic look at database mirroring, one of the high-availability alternatives offered with SQL Server 2012. Database mirroring offers increased database availability and database protection by providing and maintaining a hot standby database on another instance of SQL Server. A key point to note is that the mirror database is an exact copy of the principal database. With database mirroring, continuous support is given to organizations, bolstering operations by decreasing downtime and reducing data loss.

To ensure that organizations can reap the full benefits of database mirroring, the topics in this chapter are geared toward giving you the knowledge necessary to ...

Get Microsoft® SQL Server 2012 Management and Administration, Second Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.