Chapter 4
Restoring an Azure SQL Database
Learning Objectives
By the end of this lesson, you will be able to:
- Use point-in-time restore to recover from unexpected data modifications.
- Restore a deleted database using the Azure portal.
- Learn about using geo-restore on a database.
- Restore an Azure SQL database by importing BACPAC.
This lesson explores different restore options such as Point-In-time restore, restore deleted database, geo-restore a database. You'll also learn to automate the restore task using PowerShell.
Introduction
Azure SQL Database has the following restore options:
- Point-in-time Restore
- Restore a deleted database
- Geo-Restore a database
- Restore a database from Azure Vault
- Import a BACPAC
Figure 4.1: Types of restore ...
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.
