Database Mirroring

What Does Database Mirroring Mean?

Database mirroring is the process of creating and managing multiple copies of a database for the purpose of database backup, recovery and/or performance optimization.

Advertisements

It is a type of data backup and business continuity process that utilizes mirrored instances to enhance database availability and provide a database failover mechanism.

Techopedia Explains Database Mirroring

Database mirroring is primarily used to create redundant instances of a database system. These redundant copies help in ensuring database service delivery even if the primary database is offline or unavailable.

Typically, database mirroring is achieved by creating and deploying an instance of a database on two servers, where one acts as the primary database and other as the mirrored database. Each transaction performed on the primary server is instantly copied on the mirrored database server. If the primary server fails, database operations can instantly be transferred to the mirrored database.

Advertisements

Related Terms

Margaret Rouse

Margaret Rouse is an award-winning technical writer and teacher known for her ability to explain complex technical subjects to a non-technical, business audience. Over the past twenty years her explanations have appeared on TechTarget websites and she's been cited as an authority in articles by the New York Times, Time Magazine, USA Today, ZDNet, PC Magazine and Discovery Magazine.Margaret's idea of a fun day is helping IT and business professionals learn to speak each other’s highly specialized languages. If you have a suggestion for a new definition or how to improve a technical explanation, please email Margaret or contact her…