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

What are character string data types in ms sql server?

646


What is collation?

723


How to assign null values to variables or columns?

557


What is a schema in ms sql server 2005?

575


List layers of abstraction microsoft architectured to provide relational db through cloud platform ?

163






How to change the ownership of a schema in ms sql server?

569


What are the types of normalization?

560


How do I view a procedure in sql server?

549


let's assume you have data that resides on sql server 6.5. You have to move it sql server 7.0. How are you going to do it? : Sql server database administration

513


What are the differences between DDL, DML and DCL in SQL?

764


You have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem?

579


What is sqlservr.exe - process - sql server (sqlex?press)?

610


explain the difference between oracle- sql and sql server sql ? if both are same y we r using 2 sw.s?

1995


What is difference between rownum and rowid?

517


What is cube dimension? : sql server analysis services, ssas

544