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

Real-World Transactional Replication Problems and Solutions


This section discusses some of the common real-world transactional replication problems that may occur in a transactional replication configuration. There are no specific patterns for these problems. Almost all of these problems can be solved without having to reconfigure the replication.

Transactional replication doesn't require that much management once configured. However, you'd have to look at issues that may occur from time to time. In this section, we'll look at some of those issues.

We can group these issues under the following categories:

  • Configuration issues

  • Data issues

  • Performance issues

Note

This categorization is done for understanding, and is not the standard categorization from Microsoft. This lesson doesn't cover all issues. It covers common issues and explains the solutions to them in a way so that you can fix other issues.

Configuration Issues

As the name suggests, these are issues that may occur if transactional replication...