Lesson 2

Transactional Replication

Learning Objectives

By the end of this lesson, you will be able to:

  • Configure and troubleshoot transactional replication
  • Configure Azure SQL Database as a subscriber
  • Configure and troubleshoot peer-to-peer transactional replication

This lesson will teach us how to configure transactional replication and P2P transactional replication. We will also see how to troubleshoot, monitor, and optimize the same.

Introduction

In the previous lesson, we were introduced to replication and its types. We also took a deep dive into how to configure snapshot replication. In this lesson, we will continue our tour of replication and look at transactional replication and peer-to-peer transactional replication.

This lesson ...

Get Professional SQL Server High Availability and Disaster Recovery now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.