What is Peer to peer Replication?



What is Peer to peer Replication?..

Answer / 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

More SQL Server Interview Questions

Explain in brief how sql server enhances scalability of the database system?

0 Answers  


What is blocking?

0 Answers  


Why de-normalization required?

0 Answers  


How to recreate an existing index in ms sql server?

0 Answers  


How to provide login information for a new odbc dsn?

0 Answers  






How to download microsoft sql server 2005 express edition?

0 Answers  


How to write a query with an inner join in ms sql server?

0 Answers  


What is a collation in ms sql server?

0 Answers  


What is indexing in sql server with example?

0 Answers  


How will you optimize a stored procedure optimization?

0 Answers  


sql database suspect We have a sql database that is showing as suspect. How can we recover?

0 Answers  


Write a SQL query to make a column as unique?

0 Answers   Cap Gemini,


Categories