Book Image

Professional SQL Server High Availability and Disaster Recovery

By : Gethyn Ellis
5 (1)
Book Image

Professional SQL Server High Availability and Disaster Recovery

5 (1)
By: Gethyn Ellis

Overview of this book

Business continuity is of utmost importance. High availability (HA) and disaster recovery (DR) ensure that your infrastructure experiences no downtime and smoothly functions at all times. Sound knowledge of various HA and DR techniques help you to drastically reduce the downtime of your applications. This course begins by explaining the high availability and disaster recovery technologies available in SQL Server: Replication, AlwaysOn, and Log Shipping. You’ll learn what they are, how to monitor them, and how to troubleshoot any related problems. You’ll learn how to use different HA and DR topologies to create a highly available infrastructure that also includes hybrid topologies. You’ll learn what is Always On, it’s pros and cons, prerequisites, and restrictions. You’ll also learn about log shipping, one of the oldest SQL Server solutions, which is mostly used for DR and SQL Server migration. Through this course, you will be able to explore the technical implementations of high availability and disaster recovery technologies that you can use when you create a highly available infrastructure, including hybrid topologies. By the end of the course, you’ll feel confident and look forward to changing the game with robust and high performing infrastructure.
Table of Contents (7 chapters)
Chapter 2
Transactional Replication
Content Locked
Section 3
Understanding Peer-to-Peer Replication
Peer-to-Peer replication, also referred to as master-master replication, is built upon transactional replication in which changes at the subscriber are also replicated to the publisher. A peer-to-peer topology consists of two or more databases where a change in each node (database) gets replicated at every other node (database) in the topology. Peer-to-peer replication therefore provides a scalable high availability solution In this section you will learn to do the following: - Creating the Publication, Adding Articles, Adding Subscription and Pushing the Subscription Agent to the Publication on Server 1 - Taking the Backup of the Publication Database on Server 1 - Restoring the Database on the Subscriber Server - Creating the Publication, Adding Articles, Adding Subscription and Pushing the Subscription Agent to the Publication on Server 2 - Verifying the Replication