Performing SQL Restore
In case a disaster strikes, you can restore an entire Azure SQL database from an image-level backup. Veeam Backup for Microsoft Azure allows you to restore one or more databases at a time, to the original location or to a new location.
Within one restore session, you can restore only those Azure SQL databases that belong to the same SQL Server.
How SQL Restore Works
To restore an Azure SQL database from an image-level backup, Veeam Backup for Microsoft Azure performs the following steps:
- [Applies to archived backups] Retrieves data from the archived restore point.
- Launches a worker instance in the Azure region where the SQL Server that will host the restored database resides.
- Creates an empty database on the target SQL Server using the Azure REST API.
- Restores backed-up data to a BACPAC file on the worker instance.
- Imports data from the BACPAC file to the created database.
- Performs consistency checks for the restored database.
- Deallocates the worker instance.
- [This step applies only if you perform restore to the original location and if the source database is still present in the location] Renames the restored database and then removes the source database from the SQL Server.
To restore an Azure SQL database from a backup that is stored in an archive repository, you must retrieve the archived data first. You can either retrieve the archived data manually before you begin the restore operation, or launch the data retrieval process right from the restore wizard. To learn how to retrieve data manually, see Retrieving Data From Archive.
How to Perform SQL Restore
To restore Azure SQL database, do the following: