O'Reilly logo

Training Kit Exam 70-462: Administering Microsoft® SQL Sever® 2012 Databases by Peter Ward Orin Thomas and boB Taylor

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 7. Mirroring and Replication

Exam objectives in this chapter:

  • Implement database mirroring.

  • Implement replication.

Database mirroring is a solution for increasing the availability of databases, enabling a mirror database to function as a substitute if the primary database becomes unavailable. The amount of data lost and how automatically the switch occurs between the primary and the mirror depends on the configuration of the mirroring session. Replication is a method of transmitting database data and objects between database servers. Microsoft SQL Server 2012 supports four primary methods of replication, and the ability to determine the situations in which each replication method is appropriate comprises part of the 70-462 exam.

Lessons in ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required