Book Image

Professional SQL Server High Availability and Disaster Recovery

By : Ahmad Osama
Book Image

Professional SQL Server High Availability and Disaster Recovery

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.
Table of Contents (9 chapters)
Professional SQL Server High Availability and Disaster Recovery
Preface

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:

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

  3. The next step is to validate the cluster...