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

Managing AlwaysOn Availability Groups


In this section, you'll learn about the various management tasks that you will have to perform once an AlwaysOn availability group is up and running. These include the following tasks:

  • Removing a database from an existing availability group

  • Adding a new database to an existing availability group

  • Adding a new replica to an existing availability group

  • Removing a replica from an existing availability group

  • Changing the availability mode of a replica

  • Changing the failover mode of a replica

  • Creating multiple listeners for an availability group

  • Creating multiple availability groups on one SQL Server instance

  • Configuring backup on secondary replicas

  • Changing the compression of an availability group

  • Configuring read-only routing

  • Taking an availability group offline

  • Deleting an availability group and listener

Let's look into the details of these tasks.

Note

All of these tasks will be done using either T-SQL or PowerShell. However, these can also be performed using Object Explorer...