Replication in Microsoft SQL Server is a process to synchronize the data across multiple servers. This is generally done by a replica set, and these sets provide multiple copies of data with redundancy and high availability on different servers.
Not only this, but replication provides a mechanism to recover from failures. It also removes dependencies from single server to protect the loss of data from a single server.
Following are three types of replications in SQL Server :
* Merge Replication : This replication groups the data from various sources to a single centralized database and is used in the server to the client environment.
* Transactional Replication : This replication is a process of distributing data from publisher to subscriber and is used in server to server environment.
* Snapshot Replication : This replication distributes data exactly as it appears at a specific moment and is used for replicating data, which changes infrequently.