Performing Azure SQL Restore

In this article

    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.

    Important

    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:

    1. Launches a worker instance in an Azure region where a backup repository resides.
    2. Creates an empty database on the target SQL server using the Azure REST API.
    3. Restores backed-up data to a BACPAC file on the worker instance.
    4. Imports data from the BACPAC file to the crated database.
    5. Performs the consistency checks of the restored database.
    1. [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.

     

    Before You Begin

    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:

    1. Launch SQL Database restore wizard.
    2. Select a restore point.
    3. Select an Azure account.
    4. Choose the restore mode.
    5. Select an Azure SQL account.
    6. Specify the data retrieval settings for archived backups.
    7. Specify the restore settings.
    8. Specify a restore reason.
    9. Review summary information.