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

Summary


In this lesson, we talked about log shipping, its pros and cons, and how to configure it as a DR solution. We learned that sqllogship.exe, an independent executable, is responsible for carrying out the log shipping tasks, performing transaction log backups, copying the log backup to the shared folder, and restoring the transaction log backup to the secondary server.

Each of the log ship tasks are scheduled using a SQL Server agent jobs. Log shipping is one of the old DR solutions which can also be used when migrating from one SQL Server instance to another.

This brings us to the end of this book. You can visit https://azure.microsoft.com/en-in/solutions/architecture/ to explore the different application architectures and better understand how HA and DR work with different kinds of applications.