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

Installing the SQL Server Developer Edition


SQL Server 2016 or SQL Server 2017 Developer editions can be used for configuring AlwaysOn. In our case, we will download and install the SQL Server 2016 Developer edition.

Exercise 32: Downloading and Installing the SQL Server 2016 Developer Edition

To download and install the SQL Server 2016 Developer edition, follow these steps on your host machine:

  1. Create a Visual Studio Dev Essentials account if you don't have it already at https://visualstudio.microsoft.com/dev-essentials/.

  2. Join the Dev Essentials program and log in to dev essentials using the link once you have created your account:

  3. Select Downloads from the top menu:

    Figure 4.31: The Downloads option

  4. On the Downloads page, under Servers, select SQL Server 2016 with Service Pack 1:

    Figure 4.32: The Servers section

  5. On the Downloads page, select the Download button besides SQL Server 2016 Developer with Service Pack 1 to download the Developer edition ISO file:

    Figure 4.33: The Download button

  6. When the...