Imagine that you work for a retail organization that has recently moved its enterprise resource planning (ERP) database to Azure SQL Database. This database holds critical operational data that you must protect from data loss or corruption. You need to set up backup and retention policies to ensure the organization can recover from disasters. You must be familiar with the steps and options to recover, in case the need arises.

In this module, you'll see how to configure backup and long-term data retention policies. You'll also learn about database restore procedures.

Learning objectives

At the end of this module, you'll be able to:

  • Configure backup and retention of a single Azure SQL database.
  • Restore a single Azure SQL database.


  • Basic knowledge of the Azure SQL Database service
  • Basic knowledge of Azure PowerShell