O'Reilly logo

Microsoft® SQL Server 2012 Unleashed by Alex T. Silverstein, Chris Gallelli, Paul T. Bertucci, Ray Rankins

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

Database Mirroring Operating Modes

With database mirroring, you have the option of deploying in one of three modes: high safety with automatic failover mode (high availability with a witness server), high safety without automatic failover mode (high protection without a witness server), and high-performance mode. Each mode has different failure and protection characteristics and uses the database mirroring configurations slightly differently. As you might expect, the high-performance mode offers the least amount of protection; you must sacrifice levels of protection for performance.

Database mirroring runs with either asynchronous or synchronous operations:

Synchronous operations—With synchronous operations, a committed transaction is committed ...

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