Tech Insights
Database Mirroring

Database Mirroring

Last updated , generated by Sumble
Explore more →

What is Database Mirroring?

Database mirroring is a SQL Server feature that provides high availability and disaster recovery for databases. It involves maintaining a copy of a production database (the principal database) on a separate server instance (the mirror database). Transactions are applied to both databases, ensuring that the mirror database is nearly identical to the principal. In the event of a failure of the principal server, the mirror database can be brought online quickly, minimizing downtime. It is commonly used for business continuity and data protection.

What other technologies are related to Database Mirroring?

Database Mirroring Competitor Technologies

Log shipping provides disaster recovery by copying transaction log backups from a primary server to a secondary server, similar to mirroring but with manual failover.
mentioned alongside Database Mirroring in 27% (379) of relevant job posts
Replication can provide high availability and data distribution but employs a different strategy than mirroring. In the case of replication, data changes are asynchronously copied to one or more subscriber databases.
mentioned alongside Database Mirroring in 8% (278) of relevant job posts
Always On Availability Groups provide high availability and disaster recovery at the database level, replacing database mirroring.
mentioned alongside Database Mirroring in 12% (135) of relevant job posts
Availability Groups provide high availability and disaster recovery at the database level, replacing database mirroring.
mentioned alongside Database Mirroring in 16% (51) of relevant job posts
Always On Availability Groups provide high availability and disaster recovery at the database level, replacing database mirroring.
mentioned alongside Database Mirroring in 13% (59) of relevant job posts

Database Mirroring Complementary Technologies

Activity Monitor provides real-time performance data that can be useful in monitoring database mirroring.
mentioned alongside Database Mirroring in 43% (52) of relevant job posts
DMVs provide monitoring information about database mirroring sessions.
mentioned alongside Database Mirroring in 22% (76) of relevant job posts
SQL Profiler can be used to monitor the performance of database mirroring.
mentioned alongside Database Mirroring in 6% (117) of relevant job posts

Which job functions mention Database Mirroring?

Job function
Jobs mentioning Database Mirroring
Orgs mentioning Database Mirroring

Which organizations are mentioning Database Mirroring?

Organization
Industry
Matching Teams
Matching People
Database Mirroring
Microsoft
Scientific and Technical Services

This tech insight summary was produced by Sumble. We provide rich account intelligence data.

On our web app, we make a lot of our data available for browsing at no cost.

We have two paid products, Sumble Signals and Sumble Enrich, that integrate with your internal sales systems.