Summary
Restoring an Azure SQL database and Azure SQL Managed Instance is different from restoring an on-premises SQL Server database. In this chapter, you learned about the following restore options:
- Point-in-time restore
- Restoring a deleted database
- Geo-restoring a database
- Restoring a database from a long-term backup
- Importing a
BACPACfile
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 in Azure SQL Database and SQL Managed Instance, whereas importing a BACPAC file in Azure SQL Database helps you set up a development environment with the same schema and data across development, testing, and integration.
In the next chapter, we will look at the security mechanisms available to secure an Azure SQL database and SQL Managed Instance.
