Performing Azure SQL Restore
In case a disaster strikes, Veeam Backup for Microsoft Azure allows you to restore an Azure SQL database from backup. You can restore one or more databases at once to the original location or to a new location.
Within one restore session you can restore only those Azure SQL databases that are located on the same SQL Server.
How Azure SQL Restore Works
To restore Azure SQL database, Veeam Backup for Microsoft Azure performs the following steps:
- Launches a worker instance in an Azure region where a SQL Server hosting 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 the consistency checks of the restored database.
- [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 VM 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 Azure SQL Restore
To restore Azure SQL database, do the following: