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 |
How can you find out which stored procedures are recompiling?
What xml support does the sql server extend?
How to copy data from one table to another table?
How to convert character strings into numeric values?
What do you mean by SQL injection attack?
Write down the syntax and an example for create, rename and delete index?
what is mean by constraints in sql?
What are the basic functions for master, msdb, model, tempdb and resource databases?
What is merge join?
What are the advantages of paper records?
Which are the third-party tools used in sql server and why would you use them?
What are database states in ms sql server?