Administration of Transactional Replication
There are 3 types of Replication Types in SQL Server:
1. Snapshot Replication
2. Transactional Replication
3. Merge Replication
Replication of data can be configured between same server or can be different servers connected by Network. SQL Server replication uses a publisher, distributor and subscriber for replication to work
Publisher is the database that sends its data to another database which can be located in same or another server.
Subscriber is the database that receives data from another database which can be located in same or another server.
Distributor is the server that manages the flow of data through the replication system. This server contains … Read the rest