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
What are character string data types in ms sql server?
What is collation?
How to assign null values to variables or columns?
What is a schema in ms sql server 2005?
List layers of abstraction microsoft architectured to provide relational db through cloud platform ?
How to change the ownership of a schema in ms sql server?
What are the types of normalization?
How do I view a procedure in sql server?
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
What are the differences between DDL, DML and DCL in SQL?
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?
What is sqlservr.exe - process - sql server (sqlex?press)?
explain the difference between oracle- sql and sql server sql ? if both are same y we r using 2 sw.s?
What is difference between rownum and rowid?
What is cube dimension? : sql server analysis services, ssas