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. ...
Get Microsoft® SQL Server™ 2005 Administrator's Companion 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.
