MEAPSA

Back up and restore databases

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.

Data Analyst

Data Engineer

Database Administrator

Azure

SQL Server

SQL Database

Module Objectives

In this module, you will:

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

Units

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

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.