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.


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.


Related Terms

Margaret Rouse
Technology Expert

Margaret 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 IT definitions have been published by Que in an encyclopedia of technology terms and cited in articles by the New York Times, Time Magazine, USA Today, ZDNet, PC Magazine, and Discovery Magazine. She joined Techopedia in 2011. Margaret's idea of a fun day is helping IT and business professionals learn to speak each other’s highly specialized languages.