> Commvault Cloud > Database > Azure > Azure SQL Database > Getting Started

Configure Azure SQL Server Database Backups Using a Backup Gateway

You can use a guided setup to configure Azure database backups using a backup gateway.

Important

The Commvault Cloud software supports Azure for public clouds only. Sovereign clouds, such as in Germany or China, are not supported. For more information, go to Azure Regions Decision Guide on the Microsoft documentation website.

Before You Begin

You must have credentials to log on to the Azure portal.

Procedure

  1. From the Command Center navigation pane, go to Service Catalog.

    The Service Catalog page appears.

  2. On the Database tile, click Configure.

    The Select a Database Application page appears.

  3. Click Microsoft Azure.

    The Database Trial page appears.

  4. Click Continue.

    The Select a Database Service page appears.

  5. Select Azure SQL Server and Managed SQL, and then click Next.

    The Select Backup Method page appears.

  6. Select Backup via gateway, and then click Next.

    The Region page appears.

  7. Select the region where the Azure database is located, and then click Next.

    The Backup Gateway selection page appears.

  8. To specify a backup gateway, do one of the following:

    • From the list of backup gateways available for the region you selected, select one or more backup gateways.

    • Add a new backup gateway, click the refresh icon to refresh the backup gateway list, and then select the backup gateway.

  9. Click Next.

    The Configure storage page appears.

  10. To specify the storage location, do one of the following:

    • From the Storage location list, select a cloud storage location for the primary copy.

    • Add a new storage location, click the refresh icon to refresh the location list, and then select the new location.

  11. If you want to make a secondary copy, move the Secondary copy toggle to the right, and then from the secondary copy list, select the location for the secondary copy.

  12. Click Next.

    The page to select a backup plan appears.

  13. To specify the Plan, do one of the following:

    • From the list of backup plans, select a backup plan.

    • Add a new backup plan, click the refresh icon to refresh the backup plan list, and then select the backup plan.

  14. Click Next.

    The Cloud Account page appears.

  15. To specify the cloud account, do one of the following:

    • From the Cloud account list, select a cloud account.

    • Add a new cloud account, click the refresh icon to refresh the cloud account list, and then select the cloud account.

  16. Click Next.

    The Instance Details page appears.

  17. Enter SQL server instance details:

    1. From the Instance name list, select the instance.

    2. For entering SQL server authentication details, do one of the following:

      • From the SQL server authentication list, select the credential for the SQL server account.
        The user account is the server administrator for the Azure SQL DB instances that you are adding.

      • Click + to create a new credential. For information about adding a credential, see Creating a Credential Entity.

      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 a local administrator with sysadmin server role on 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 multi-factor authentication is not supported.

    3. By default, the export path is the job results directory on the configured access node. To specify a different directory, move the Use default path for export toggle key to the left, and in the Staging path used for export box, enter a staging path that is available on all the configured access nodes.

  18. Click Next.

    The Backup Content page appears.

  19. If there is an EDIT button, you can click it to browse the backup content and select the content to back up for the region you selected.

    For Microsoft SQL, all content is selected and you cannot change the backup content.

  20. Click Next.

    The system creates the instance and displays a summary page that shows the instance configuration.

  21. You can click CONFIGURE ANOTHER REGION or click FINISH to display the characteristics of the instance.

For information about the benefits of using the staging path export method, see Using the Staging Path Export Method for a Secure Transfer of Data.

Loading...