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

There is table like Events...in that name ,startdate ,enddate,location are the column names write a stored Procedure for this table to get events by Months "GetEventsByMonths"

2 Answers  


Can sql server 2016 run on windows 7?

0 Answers  


How can we delete Duplicate row in table?

0 Answers   Wipro,


What is a trigger? Why we need it?

0 Answers   Accenture,


what is web server?

3 Answers   Satyam,






How to get a list of table columns using the "sp_columns" stored procedure in ms sql server?

0 Answers  


What is a select query statement in ms sql server?

0 Answers  


How to truncate the log in sql server 2012? : sql server database administration

0 Answers  


What are SQL Jobs, please mention the use of it and how to create them.

1 Answers   247Customer,


What is data integrity? Explain constraints?

1 Answers   Thinksoft,


what's sql server? : Sql server database administration

0 Answers  


How do we get current date in SQL Server 2000, Oracle, MS Access?

13 Answers  


Categories