Performing SQL Restore

In this article

    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.

    Important

    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:

    1. [Applies to archived backups] Retrieves data from the archived restore point.
    2. Launches a worker instance in the Azure region where the SQL Server that will host the restored database resides.
    3. Creates an empty database on the target SQL Server using the Azure REST API.
    4. Restores backed-up data to a BACPAC file on the worker instance.
    5. Imports data from the BACPAC file to the created database.
    6. Performs consistency checks for the restored database.
    7. Deallocates the worker instance.
    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 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:

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