MS SQL Server Replication Question:

Download Job Interview Questions and Answers PDF

What is Replication and Database Mirroring?

SQL Server Replication Interview Question
SQL Server Replication Interview Question

Answer:

Database Mirroring allows two copies of a database on different computers. Clients can get access to only one database called as”principal” database. Any changes applied to principal database, are applied on the copy also called as the mirror. This is achieved by applying the transaction log for every insert, update, or deletion made on the primary database. This increases the availability of a database incase of a failure.

Download SQL Server Replication Interview Questions And Answers PDF

Previous QuestionNext Question
Explain the advantages of merge replication?What are the disadvantages of merge replication?