AlwaysOn Availability Groups | Professional SQL Server High Availability and Disaster Recovery

Sign In Start Free Trial

Book Overview & Buying
Table Of Contents

Professional SQL Server High Availability and Disaster Recovery

By : Ahmad Osama

1 (1)

Professional SQL Server High Availability and Disaster Recovery

1 (1)

By: Ahmad Osama

Overview of this book

Professional SQL Server High Availability and Disaster Recovery explains 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 will be introduced to the availability groups of AlwaysOn and learn how to configure them to extend your database mirroring. Through this book, 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. Note that this course does not cover SQL Server Failover Cluster Installation with shared storage. By the end of the book, you’ll be equipped with all that you need to know to develop robust and high performance infrastructure.

Professional SQL Server High Availability and Disaster Recovery

Professional SQL Server High Availability and Disaster Recovery

Preface

Preface

Free Chapter

Getting Started with SQL Server HA and DR

Getting Started with SQL Server HA and DR

Introduction

What is High Availability and Disaster Recovery?

HA and DR Terminologies

SQL Server HA and DR Solutions

Introduction to SQL Server Replication

Types of Replication

Configuring Snapshot Replication Using SQL Server Management Studio

Optimizing Snapshot Replication

Summary

Transactional Replication

Transactional Replication

Introduction

Understanding Transactional Replication

Configuring Transactional Replication

Azure SQL Database as a Subscriber in Transaction Replication

Understanding Peer-To-Peer Transactional Replication

Configuring Peer-To-Peer Transactional Replication

Modifying an Existing Publication

Summary

Monitoring Transactional Replication

Monitoring Transactional Replication

Introduction

The Replication Monitor

Real-World Transactional Replication Problems and Solutions

Conflicts in Peer-to-Peer Transactional Replication

Summary

AlwaysOn Availability Groups

AlwaysOn Availability Groups

Introduction

AlwaysOn Availability Group Concepts and Terminology

AlwaysOn Availability Groups

Creating Hyper-V VMs

Active Directory Domain Controller

Installing the SQL Server Developer Edition

Windows Server Failover Cluster

Configuring AlwaysOn Availability Groups

AlwaysOn Availability Groups on Microsoft Azure

Summary

Managing AlwaysOn Availability Groups

Managing AlwaysOn Availability Groups

Introduction

AlwaysOn AG Failover

Managing AlwaysOn Availability Groups

Monitoring AlwaysOn Availability Groups

Troubleshooting AlwaysOn Availability Groups

Summary

Configuring and Managing Log Shipping

Configuring and Managing Log Shipping

Introduction

Configuring Log Shipping

Managing and Monitoring Log Shipping

Troubleshooting Common Log Shipping Issues

Comparing AlwaysOn, Replication, and Log Shipping

Summary

Appendix

Appendix

Lesson 1: Getting Started with SQL Server HA and DR

Lesson 2: Transactional Replication

Lesson 3: Monitoring Transactional Replication

Lesson 5: Managing AlwaysOn Availability Groups

Lesson 6: Configuring and Managing Log Shipping

Windows Server Failover Cluster

The next step is to configure Windows Server Failover Cluster.

Exercise 34: Configuring Windows Server Failover Cluster

To configure Windows Server Failover Cluster on the replicas, follow these steps:

The first step is to install the failover clustering Windows feature on all replicas, DPLPR, DPLHA, and DPLDR.
Navigate to the C:\Code\Lesson04\Common directory and copy the Install-FailoverCluster.ps1 PowerShell script to the C:\Scripts directory in DPLPR VM. When connected to DPLPR, execute the following command to enable the failover clustering feature on all the replicas:
```
C:\Scripts\Install-FailoverCluster.ps1
```
To verify the installation on a particular VM, execute the following PowerShell command:
```
Get-WindowsFeature *clus* -ComputerName DPLHA
```
You should get the output shown in the following screenshot:
Figure 4.43: Verifying the installation
Modify the -ComputerName parameter in this command and verify for the DPLPR and DPLDR VMs.
The next step is to validate the cluster...

CONTINUE READING

83

Tech Concepts

36

Programming languages

73

Tech Tools

Unlimited access to the largest independent learning library in tech of over 8,000 expert-authored tech books and videos.

Innovative learning tools, including AI book assistants, code context explainers, and text-to-speech.

50+ new titles added per month and exclusive early access to books as they are being written.

Professional SQL Server High Availability and Disaster Recovery

Search

Your notes and bookmarks