Summary
Restoring an Azure SQL database is different from restoring an on-premises SQL Server database. In this lesson, you learned about the following restore options:
- PITR
- Restoring a deleted database
- Geo-restoring a database
- Restoring a database from Azure Vault
- Importing a BACPAC file
Each of these options can be leveraged in different scenarios. For example, a PITR will help you recover from a corrupt database or accidental deletion, whereas importing a BACPAC file helps you set up a development environment with the same schema and data across development, testing, and integration.
In the next lesson, we will look at the security mechanisms available to secure an Azure SQL database.
