Replication

Question 1

What are the objects being replicated referred to as?

Answer 1

Articles

Question 2

What is the group term for the objects being replicated?

Answer 2

Publication

Question 3

What is the destination of the replicated data referred to as?

Answer 3

Subscriber

Question 4

Name the 4 types of replication available?

Answer 4

• Snapshot
• Transnational
• Merge
• Peer to Peer

Question 5

What are the 4 parties involved in a replication system?

Answer 5

• Publisher
• Distributor
• Subscriber
• Agents

Question 6

What is the Distributor and what does it do?

Answer 6

• Middleman between publisher and subscribers.

- Separate database where configurations are held

Question 7

Name 3 of the agents involved in transactional replication and where they are located?

Answer 7

• Log reader agent
• Snapshot agent
• Distribution agent (where subscribers not pulling data}
• Both of which are run by distributor database

Question 8

What is merge replication?

Answer 8

Replication where the subscribers can change the data

Question 9

What is peer to peer replication

Answer 9

Type of Transactional Replication, in which you have multiple publishers, all pushing data out at each other.