top button

What is the difference between database mirroring and replication?

+2 votes
posted Jan 5, 2017 by Abhishek Maheshwari

Share this question
Facebook Share Button Twitter Share Button Google+ Share Button LinkedIn Share Button Multiple Social Share Button

1 Answer

0 votes

This both are two high availability techniques. Data base mirroring is a technique by which we can secure our database server.
for example:-SQL Server database mirroring is a disaster recovery and high availability technique that involves two SQL Server instances on the same or different machines. One SQL Server instance acts as a primary instance called the principal, while the other is a mirrored instance called the mirror.

Database replication:-In replication, data and database objects are copied and distributed from one database to another.

answer Apr 27, 2017 by Rahul Sharma