Summary

Azure SQL Database backups are different to on-premises database backups. The regular backup database command isn't supported in Azure SQL Database. In this lesson, we have learned about the automatic backups that are unique to Azure SQL Database and that aren't available in an on-premises database.

We also learned how to take manual backups of an Azure SQL database using SSMS and PowerShell. A manual backup is just an export of the schema, or the data and schema, stored in DACPAC or BACPAC format, respectively.

In the next lesson, we will look at the restore options available in Azure.