O'Reilly logo

Microsoft® SQL Server™ 2005 Administrator's Companion by Victor Isakov, Stacia Misner, Burzin Patel, Marcilina Garcia, Edward Whalen

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

Database mirroring is a new high availability technology that was introduced in SQL Server 2005. Primarily, it is used as part of an overall high availability solution, but it can also be used as a database reporting solution. It can be used in a variety of ways: stand alone or in conjunction with log shipping, clustering, or database snapshots. Mirroring provides a hybrid solution: a copy of database like with log shipping, rapid failover capabilities like with clustering, and elimination of the issues associated with shared disk solutions.

Mirroring in a minimal configuration consists of two database servers: the principal and the mirror. The principal database is the primary database that is online and accessible to users. ...

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