Summary

In this lesson, we have learned how to configure transactional replication and peer-to-peer transactional replication.

We learned how the different agents, that is, snapshot agent, log reader agent, and distributor agent, work together to replicate the data from the publisher database to the subscriber database.

We then saw how to modify the properties of an existing publication and subscription and how to add and remove articles to/from an existing publication.

In the next lesson, we'll learn how to monitor and troubleshoot transactional replication.