Deploy highly available solutions by using Azure SQL

Beginner
Intermediate
Solution Architect
Database Administrator
Data Engineer
Azure
Azure SQL Database
Azure SQL Managed Instance

Whatever SLA, RTO, and RPO your business requires, Azure SQL has the options and built-in capabilities to meet that availability. In this module, you'll learn how to translate your knowledge of backup and restore, failover cluster instances, and Always On availability groups to the options for business continuity in Azure SQL. You'll also peek under the hood at the architectures and how they affect availability.

Learning objectives

In this module, you'll learn how to:

  • Create a backup and restore strategy for your organization.
  • Evaluate the architectures associated with each service tier.
  • Compare options for getting higher availability.
  • Describe how availability and consistency apply to Azure SQL.
  • Configure and monitor availability.

Prerequisites

  • Experience working with, maintaining, and developing with SQL Server
  • Experience with Azure, such as deploying and managing resources