Replication Flashcards
1
Q
What are the objects being replicated referred to as?
A
Articles
2
Q
What is the group term for the objects being replicated?
A
Publication
3
Q
What is the destination of the replicated data referred to as?
A
Subscriber
4
Q
Name the 4 types of replication available?
A
- Snapshot
- Transnational
- Merge
- Peer to Peer
5
Q
What are the 4 parties involved in a replication system?
A
- Publisher
- Distributor
- Subscriber
- Agents
6
Q
What is the Distributor and what does it do?
A
- Middleman between publisher and subscribers.
- Separate database where configurations are held
7
Q
Name 3 of the agents involved in transactional replication and where they are located?
A
- Log reader agent
- Snapshot agent
- Distribution agent (where subscribers not pulling data}
- Both of which are run by distributor database
8
Q
What is merge replication?
A
Replication where the subscribers can change the data
9
Q
What is peer to peer replication
A
Type of Transactional Replication, in which you have multiple publishers, all pushing data out at each other.
