Database Mirroring

In this post, I will explain Database Mirroring.

Database Mirroring is the creation and maintenance of redundant copies of a database. The purpose is to ensure continuous data availability and minimize or avoid downtime that might otherwise result from data corruption or loss, or from a situation when the operation of a network is partially compromised. Database Mirroring can be implemented on a per-database basis and works only with databases that use the full recovery model.

Database Mirroring can be implemented in different configurations-

1. Database Mirroring with 2 SQL Server machines with 2 SQL server instance's and one mirrored database
2. Database Mirroring with 1 SQL   Server machine with 2 SQL Server instances and one mirrored database. In this configuration, if the SQL Server machine goes down then both instances will be unavailable

Benefits of Database Mirroring

Database Mirroring is a simple strategy that offers the following benefits:

• Increases availability of a database
• Increases data protection
• Improves the availability of the production database during upgrades