Define the terms used in Replication

Define the terms used in Replication.

Publisher is the database that transmits its data to another database.
Subscriber is the database that receives data from another database.
Distributor manages the flow of data during data replication.
Push subscription is the subscription when data is pushed from publisher database to subscribing database.
Pull subscription is subscription when the subscribing database pulls the data from distribution database.
Distribution database is the system database that stores snapshot jobs to be distributed to subscribers.
Replication agents that SQL Server supports
The Snapshot Agent creates snapshot files and stores on the distribution database. It also keeps track of synchronization status in the distribution database....
Working of Replication
At first data and object is synchronized between publisher and subscribers........
What is RAID and what are different types of RAID configurations?
RAID stands for Redundant Array of Independent Disks. RAID defines data storage schemes to divide.......
Post your comment