Back up and restore databases

Module
7 Units

Intermediate

Data Analyst

Data Engineer

Database Administrator

Azure

Azure SQL Database

SQL Server

Plan and implement policy for recovering data if user errors occur or the technology fails. Explore various options for how and where to back up and restore databases.

Learning objectives

In this module, you will:

Explore backup and restore options for IaaS
Implement backup and restore for PaaS

Prerequisites

Experience creating and configuring resources using the Azure portal.
Basic understanding of SQL Server file storage.
Familiarity with SQL Server database files for data and log.
Familiarity with purpose and management of SQL Server transaction log.

Introduction min
Back up and restore SQL Server running on Azure virtual machines min
Back up a SQL Server virtual machine min
Back up and restore a database using Azure SQL Database min
Exercise: Backup to URL min
Knowledge check min
Summary min