Skip to Main Content
Professional SQL Server High Availability and Disaster Recovery
book

Professional SQL Server High Availability and Disaster Recovery

by Ahmad Osama
January 2019
Intermediate to advanced content levelIntermediate to advanced
564 pages
9h 2m
English
Packt Publishing
Content preview from Professional SQL Server High Availability and Disaster Recovery

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 ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Professional SQL Server 2012 Internals and Troubleshooting

Professional SQL Server 2012 Internals and Troubleshooting

Christian Bolton, James Rowland-Jones, Glenn Berry, Justin Langford, Gavin Payne, Amit Banerjee

Publisher Resources

ISBN: 9781789802597Supplemental Content