Back up and restore databases

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.