Chapter 1
Getting Started with SQL Server High Availability and Disaster Recovery
Section 4
Introduction to SQL Server Replication
Replication is a SQL Server feature that synchronizes data from a database (known as a publisher) to one or more databases (known as subscribers) on the same or different SQL Server instances. A replication has a number of components that work together to synchronize data between databases. Here you will learn about the following: - Replication Components - Replication Agents - Snapshot agent - Log Reader agent - Distribution agent - Merge agent - Types of Replication - Transactional - Merge - Snapshot