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

Introduction


Log shipping is one of the oldest disaster recovery solutions available in SQL Server. Log shipping automatically ships the transaction log backups of the specified database from a primary instance to one or more secondary instances. The secondary instances restore the transaction log backups individually, thereby maintaining a copy of the primary database.

In this lesson, we'll learn to configure, manage, and monitor log shipping.

A typical log shipping configuration consists of a primary SQL Server instance and one or more secondary SQL Server instance. The following diagram shows a log shipping configuration with a primary SQL Server instance, P, and two secondary SQL Server instances: S1 and S2:

Figure 6.1: A log shipping configuration

The steps performed to log ship the HR database shown in the diagram are as follows:

  1. A SQL Server agent backup job at the primary instance P performs a transaction log backup of the HR database and copies it to the backup share location.

    The backup...