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
How to insert data with null values?
What are tables in sql server?
what are the new features introduced in sql server 2000? : Sql server database administration
How do I debug a stored procedure in sql server?
How to generate random numbers with the rand() function in ms sql server?
What is a field in a table?
How to see the event list of an existing trigger using sys.trigger_events?
How to convert numeric values to integers in ms sql server?
What happens if the update subquery returns multiple rows in ms sql server?
Explain the microsoft sql server delete command? : SQL Server Architecture
How do you rebuild an identity column?
Tell me can we use custom code in ssrs?
Why do we partition data?
What is the difference between TRUNCATE and DROP?
Explain why variables called the most powerful component of ssis?