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 the joins in sql server? : sql server database administration
How many joins in sql server?
What is the name of the Database which IBM mainframe uses?
What command do we use to rename a db, a table and a column?
How to list all login names on the ms sql server?
What is the cartesian product of the table?
What is a transact-sql statement batch in ms sql server?
How to insert and update data into a table with "insert" and "update" statements?
How many levels of sp nesting is possible?
What are the disadvantages of primary key and foreign key in SQL?
Can multiple columns be used in sql group by clause in ms sql server?
What is the distinction amongst delete and truncate?
Who is the owner of a schema in ms sql server?
what is create database syntax? : Sql server database administration
How to apply filtering criteria at group level with the having clause in ms sql server?