Chapter 3

Backing Up an Azure SQL Database

Learning Objectives

By the end of this lesson, you will be able to:

  • Perform manual and automatic backups
  • Export an Azure SQL Database using the Azure portal
  • Export an Azure SQL Database using PowerShell

This lesson explores different backup and restore options such as automated backups, transactional consistent backups and manual backups.

Introduction

Database backups are one of the most important things a database administrator has to perform. A good database backup strategy can help recover from system outages, unwanted deletes or updates, database corruption issues, and other related issues.

This lesson teaches you how to back up an Azure SQL Database. You'll learn about automated and manual ...

Get Professional Azure SQL Database Administration - Second Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.