What is Peer to peer Replication?

Answer Posted / aruna gopalakrishnan

Peer-to-peer replication (also known as multimaster
replication) is a configuration that has the following
characteristics:

Replication occurs between tables on two or more servers.
Updates on any one server are replicated to all other
associated servers.
Applications on any of the servers can update the same rows
and columns in those tables at the same time.
All servers are equal peers with equal ownership of the
data; no server is the "master" or source owner of the
data.

Is This Answer Correct ?    7 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain the difference between delete,drop and truncate in SQL Server?

592


Give me a SQL Query to find out the second largest company?

694


Explain how many normalization forms?

581


What is create command?

526


What is star, snowflake and star flake schema? : sql server analysis services, ssas

665






which table keeps the locking information? : Sql server administration

525


What is merge?

573


What is the purpose of a table?

524


How data can be copied from one table to another table?

513


What are audit control procedures?

589


How to copy data from one table to another table?

548


what are different types of raid configurations? : Sql server database administration

490


Can we use having clause without group by?

556


What is sub-query in sql server? Explain its properties.

584


How can you manage sql azure security?

85