Step 4. Configure Processing Options

At the Processing Options step of the wizard, choose whether you want to use a staging server to perform backup. To learn how Veeam Backup for Microsoft Azure uses staging servers to protect Azure SQL databases, see SQL Backup.

Protecting Databases Without Staging Server

To back up the selected databases without a staging server, do the following:

1. Select the Process databases using the production server option.
2. Click Configure Credentials.
3. In the Choose a SQL account window:

1. For each SQL Server added to the policy, specify an Azure SQL account whose permissions Veeam Backup for Microsoft Azure will use to authenticate against the server. To do that, select the server and click Edit. Then, in the Edit Account window, select the necessary account and click Save.

For an account to be displayed in the Account list, it must be added to Veeam Backup for Microsoft Azure as described in section Adding SMTP and Database Accounts. If you have not added the necessary Azure SQL account to Veeam Backup for Microsoft Azure beforehand, you can do it without closing the Add Azure SQL Policy wizard. To do that, click Add and complete the Add Account wizard.

2. Click Apply.

Protecting Databases Using Staging Server

To back up the selected databases using a staging server, do the following:

1. Select the Use staging servers option.
2. Click Choose server.
3. In the Choose staging server window:

1. From the Staging server drop-down list, select a SQL Server that will be used to copy the databases. If you plan to back up a database located on an Azure SQL Managed Instance, you must specify the source SQL Server as a staging server.

For a server to be displayed in the Staging server list, it must be added to the Microsoft Azure environment as described in Microsoft Docs.

2. From the SQL account drop-down list, select an Azure SQL account whose permissions Veeam Backup for Microsoft Azure will use to authenticate against the staging server.

For an account to be displayed in the Account list, it must be added to Veeam Backup for Microsoft Azure as described in section Adding SMTP and Database Accounts. If you have not added the necessary Azure SQL account to Veeam Backup for Microsoft Azure beforehand, you can do it without closing the Add Azure SQL Policy wizard. To do that, click Add and complete the Add Account wizard.

3. Click Apply.