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

Creating Hyper-V VMs


Hyper-V is a virtualization technology built into Windows 8.x and above. Hyper-V allows you to create virtual machines on a Windows 8.x or above host machine. It is useful to demonstrate concepts such as AlwaysOn that require more than one machine for the setup.

In a real-world scenario, the availability group replicas are either physical boxes or on-premises or cloud VMs sized to run Online Transactional Processing (OLTP) workloads as per business requirements.

Note

A host machine is the one that will host or contain the virtual machines created as part of this lesson's exercises. Almost all of the PowerShell scripts specified here are to be run on the host machine unless otherwise specified. The host machine should be a physical machine and not a virtual machine. If you plan to use a virtual machine as the host machine, then install Windows Server 2016 and enable nested virtualization to carry out the demos. The PowerShell console should be run in the administrator role...