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.

Related Content you might be interested in

Current Title:

Small book image
Professional SQL Server High Availability and Disaster Recovery
Ahmad Osama
Jan, 2019 | 564 pages
Small book image
Professional Azure SQL Database Administration
Ahmad Osama
Jul, 2018 | 398 pages
Small book image
SQL Server 2019 Administrator's Guide
Vladimir Muzny | Marek Chmel
Sep, 2020 | 522 pages
Small book image
SQL Server 2017 Administrator's Guide
Vladimir Muzny | Marek Chmel
Dec, 2017 | 434 pages
Table of Contents (9 chapters)
Professional SQL Server High Availability and Disaster Recovery
Professional SQL Server High Availability and Disaster Recovery
Preface
Preface
Free Chapter
1
Getting Started with SQL Server HA and DR
Getting Started with SQL Server HA and DR
Introduction
What is High Availability and Disaster Recovery?
HA and DR Terminologies
SQL Server HA and DR Solutions
Introduction to SQL Server Replication
Types of Replication
Configuring Snapshot Replication Using SQL Server Management Studio
Optimizing Snapshot Replication
Summary
2
Transactional Replication
Transactional Replication
Introduction
Understanding Transactional Replication
Configuring Transactional Replication
Azure SQL Database as a Subscriber in Transaction Replication
Understanding Peer-To-Peer Transactional Replication
Configuring Peer-To-Peer Transactional Replication
Modifying an Existing Publication
Summary
3
Monitoring Transactional Replication
Monitoring Transactional Replication
Introduction
The Replication Monitor
Real-World Transactional Replication Problems and Solutions
Conflicts in Peer-to-Peer Transactional Replication
Summary
4
AlwaysOn Availability Groups
AlwaysOn Availability Groups
Introduction
AlwaysOn Availability Group Concepts and Terminology
AlwaysOn Availability Groups
Creating Hyper-V VMs
Active Directory Domain Controller
Installing the SQL Server Developer Edition
Windows Server Failover Cluster
Configuring AlwaysOn Availability Groups
AlwaysOn Availability Groups on Microsoft Azure
Summary
5
Managing AlwaysOn Availability Groups
Managing AlwaysOn Availability Groups
Introduction
AlwaysOn AG Failover
Managing AlwaysOn Availability Groups
Monitoring AlwaysOn Availability Groups
Troubleshooting AlwaysOn Availability Groups
Summary
6
Configuring and Managing Log Shipping
Configuring and Managing Log Shipping
Introduction
Configuring Log Shipping
Managing and Monitoring Log Shipping
Troubleshooting Common Log Shipping Issues
Comparing AlwaysOn, Replication, and Log Shipping
Summary
Appendix
Appendix
Lesson 1: Getting Started with SQL Server HA and DR
Lesson 2: Transactional Replication
Lesson 3: Monitoring Transactional Replication
Lesson 5: Managing AlwaysOn Availability Groups
Lesson 6: Configuring and Managing Log Shipping

The Replication Monitor

The replication monitor is a GUI that's used to monitor replication agent status and replication performance. It's not specific to transactional replication and can be used to monitor any of the available replication types.

In addition to monitoring capabilities, it allows you to start/stop replication agents, configure alerts, and check agent profiles.

Note

You should set up transactional replication if this was removed in the previous lesson.

This lesson first talks about standard replication issues and then P2P replication issues. Most of the issues that are discussed are common, other than the conflicts specific to P2P replication.

When reconfiguring transaction replication, drop P2P replication, and drop AdventureWorks at the two instances. Restore the AdventureWorks2016 database as AdventureWorks on the SQL Server 2016 instance. Create a blank AdventureWorks database on the SQL Server 2014 instance. Follow the steps in Lesson 2, Transactional Replication, to configure...

Previous Section
End of Section 3
Next Section