Creating SQL Backups Manually
Veeam Backup for Microsoft Azure allows you to manually create backups of Azure SQL databases.
Veeam Backup for Microsoft Azure does not include backups of Azure SQL databases created manually in the backup chain and does not apply the configured retention policy settings to these backups. This means that the backups are kept in the backup repository unless you remove them manually, as described in section Managing SQL Data.
To manually create a backup of an Azure SQL database, do the following:
- Navigate to Resources > Azure SQL.
- Select the check box next to the necessary Azure SQL database and click Take Backup Now.
For an Azure SQL database to be displayed in the list of available resources, it must reside in any region included in a backup policy as described in section Creating Backup Policies (step 3c).
- Complete the Take Manual Backup wizard:
- At the Account step of the wizard, select an Azure Active Directory whose permissions Veeam Backup for Microsoft Azure will use to create a backup.
For an Azure Active Directory to be displayed in the list of available directories, it must be created in the Microsoft Azure portal as described in Microsoft Docs.
- At the Options step of the wizard, do the following:
- In the Backup target section, click Choose backup repository.
In the Specify the backup repository window, select a backup repository where the created backup will be stored. For a backup repository to be displayed in the Repository list, it must be added to Veeam Backup for Microsoft Azure as described in section Adding Backup Repositories.
You can select only a backup repository with the Hot or Cool access tier.
- In the Specify database processing settings section, choose whether you want to use a staging server to perform backup. For more information, see Configure Processing Options.
- At the Summary step of the wizard, review configuration information, choose whether you want to proceed to the Session Log tab to track the progress of backup creation, and click Finish.