Configuring an Azure SQL Instance

You must add the SQL instance that you want to protect to a SQL server.

Before You Begin

The password for the Azure SQL Server administrator must not contain special characters, such as double quotes (") and back slashes (\).

Procedure

1. From the navigation pane, go to Protect > Databases.

   The Overview page appears.

2. Click Add instance, and then select Cloud db service.

   The Vendor page appears.

3. Select Microsoft Azure, and then click Next.

   The Select a Database Service page appears.

4. Select Azure SQL and Managed SQL, and then click Next.

   The Plan page appears.

5. If you already have a server plan, select it. Otherwise, create a new plan.

6. Click Next. The Add cloud account page appears.

7. If you already have an existing cloud account, from the Cloud account list, select the account. Otherwise, add a new cloud account.

8. Click Next. The Instance Details page appears.

9. From the Instance name list, select the Azure SQL instance.

10. From the SQL server authentication list, select the credentials for Azure Server admin account.

    By default, this account is the instance server admin account that has access to the instance and database to perform all operations, including backup, restore, and browse operations.

    Note

    • To use an Active Directory (AD) account for the backup, install the Microsoft Active Directory Authentication Library for Microsoft SQL Server on the access node and configure an Active Directory admin for that instance on the Azure portal. The AD account must be the Azure AD administrator or a member of the AD group assigned to the Azure SQL instance. To provide the AD account credentials, edit the SQL cloud configuration setting in the Configuration tab for the SQL instance and provide the AD account credentials in the SQL server authentication box.

    • Active Directory authentication does not work for Azure SQL databases that are protected using a Linux access node.

    Steps to add a credential

    1. Click +. The Add credential dialog box appears.

    2. In the Credential name box, enter a name for the credential.

    3. In User account, enter the user name of the Azure Server admin account.

    4. In the Password box, enter the password for theAzure Server admin account.

    5. In the Description box, enter a brief description.

    6. Click Save.

11. To use job results directory configured on the access node for export, move the Use default path for export toggle key to the right.

12. If you want to stage the export on the access node, in the Staging path used for export box, enter the staging path available on the access node.

    Note

    A staging path with Microsoft SQL Server Data-Tier Application Framework (DacFx) allows you to export an Azure SQL database to a BACPAC file larger than 200 GB.

13. Click Next.

    The Backup Content page appears.

14. All the Azure SQL instances will be backed up automatically. Click Next. The Summary page appears.

15. Click Finish.