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-
- Database Mirroring with 2 SQL Server machines with 2 SQL server instance's and one mirrored database
- 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