The Veeam Cookbook Series
A simple step by step no frills approach to achieving your goal
Recipe: Performing Azure SQL Restore
Expected deliverables:
The VM recovered at the time of backup state.
Time to complete: 5 minutes
Ingredients:
- an Azure SQL backup
Before you start:
You can restore one or more Azure SQL DBs at once, to the original or to a new location.
Assumptions:
You have an existing Veeam Backup for Microsoft Azure deployment and backups of one or more Azure SQL DBs.
Method:
- Open the Veeam Backup for Microsoft Azure webinterface.
- On the left menu click Protected Data and select the Azure SQL tab.
- Select the SQL Database that you want to recover and click Restore Database on the top.
- In Databases you can Add or Remove SQL DBs to process, and click Restore Point to select a specific restore point.
- In Account click Select Account and specify the Azure account to use for the restore operation, then click Apply.
- In Restore Mode, choose whether you want to restore the SQL DB on the original location or to a new one.
- The SQL Account section will be available only if restore to the original location was selected. Select an Azure SQL account that will be used for authentication. Select the instance and choose the SQL account.
- The Data retrieval section will be available only if restore from an archived restore point was selected. You can choose to retrieve data with Standard priority or High priority, and that will affect restore times and costs. You can also choose the number of days for which you want to keep the data available after retrieval.
- The Settings section will be available only if restore to new location was selected. Click Edit Server Settings to specify the Region, SQL Server, Elastic pool and SQL account.
- In the Reason section, specify a reason for performing the restore operation. Proceed to review the restore information, run the configuration check with Test Connection and confirm by clicking Finish.
Links to Resources: