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

Active Directory Domain Controller


ADDC is implemented in almost every organization that has a Windows workstation. In day-to-day work, ADDC is used to authenticate users into their laptops, Outlook, and other applications. For example, let's say John works in an organization named ABC Consulting. He'd usually log in to his work laptop using his AD account ABC\John. Usually, AD-DC is configured and managed by system administrators; however, a system administrator does have experience with ADDC.

ADDC is required as a prerequisite for configuring AlwaysOn availability groups on Windows Server 2012 R2.

Exercise 31: Configuring Active Directory Domain Controller

To configure ADDC on the DPLDC VM, follow these steps:

  1. Connect to the DPLDC VM that is the domain controller. ADDS is to be installed on this VM.

  2. Once connected, navigate to the C:\Code\Lesson04\Common folder (on your host/local machine) and copy the PowerShell script CreateDomain.ps1 to the C:\Scripts folder in the DPLDC VM.

  3. In the DPLDC...