1. Home
  2. Training Library
  3. Microsoft Azure
  4. Courses
  5. Implementing High Availability and Disaster Recovery for Azure SQL Databases

Implementing High Availability and Disaster Recovery for Azure SQL Databases

Contents

keyboard_tab
HADR Introduction
1
Course Introduction
PREVIEW1m 23s
Always On Availability Groups
Database Backups
HADR Summary
play-arrow
Course Introduction
Overview
DifficultyAdvanced
Duration1h 6m
Students48

Description

High availability disaster recovery (HADR) is an integral part of any organization’s data strategy. It is also an essential string to every DBA's bow. In an online world that operates 24 hours a day, going offline or losing customers' data cannot be tolerated. This course examines the features that Azure provides to help you make sure your SQL databases, whether they are managed in the cloud or on-premise, are not the point of failure in your systems.

High availability disaster recovery encompasses two fundamental concepts. Firstly, how to minimize the amount of time your databases will be offline in the event of unforeseen events like hardware failures, power outages, or any number of natural disasters. Secondly, it looks at how to minimize data loss when any of these events occur. It is one thing to be offline, but it is another thing to lose data that is already in your custody.

In this course, we will cover the full range of Azure options from turnkey to custom and do-it-yourself solutions. If you have any feedback relating to this course, feel free to reach out to us at support@cloudacademy.com.

Learning Objectives

  • Understand the concepts and elements of high availability and disaster recovery
  • Learn about hyperscale databases and how they are used
  • Learn how to combine on-premise with the cloud to replicate and sync your data
  • Understand what always on availability groups are and how they operate
  • Implement geo-replication and failover groups
  • Learn about the wide range of options you have for backing up your databases with Azure

Intended Audience

This course is intended for anyone who wants to implement high availability and disaster recovery procedures in place for their Azure SQL databases.

Prerequisites

This is an intermediate to advanced course and so to get the most out of it, you should be familiar with SQL Server management studio, database operations like backup and restore, and T-SQL, and also have some familiarity with basic active directory concepts like users and permissions.

Transcript

Hi and welcome to this Implementing High Availability and Disaster Recovery for Azure SQL Databases course. In this course we will be looking at the business continuity features also known as high availability and disaster recovery, abbreviated to HADR, that are available to you within multiple SQL server environments. Those environments include Azure SQL databases hosted on a completely managed Azure SQL Server, Azure SQL managed instances, and SQL Server running on a virtual machine or on-premise.

I would describe this as an intermediate to advanced course as it assumes some pre-existing database knowledge and covers topics that are typically only found in complex enterprise environments. Not only will you need to be familiar with SQL Server management studio, database operations like backup and restore, and T-SQL but also have some familiarity with basic active directory concepts like users and permissions.

My name is Hallam Webber and I’ll be your instructor for this course. We welcome all comments and feedback, so please feel free to reach out to us at support@cloudacademy.com with any questions or comments. Let’s get started.

Lectures

Overview - High Availability and Disaster Recovery Concepts - Hyperscale - Combining On-Premises with the Cloud - Always On Availability Groups - Failover in the Cloud - Database Backups - Course Summary

About the Author

Hallam is a software architect with over 20 years experience across a wide range of industries. He began his software career as a  Delphi/Interbase disciple but changed his allegiance to Microsoft with its deep and broad ecosystem. While Hallam has designed and crafted custom software utilizing web, mobile and desktop technologies, good quality reliable data is the key to a successful solution. The challenge of quickly turning data into useful information for digestion by humans and machines has led Hallam to specialize in database design and process automation. Showing customers how leverage new technology to change and improve their business processes is one of the key drivers keeping Hallam coming back to the keyboard.