Configure Azure Managed SQL Instance Backups Using Commvault Cloud Infrastructure

You can use a guided setup to configure Azure Managed SQL instance backups using the Commvault Cloud infrastructure (also called direct to cloud). With direct to cloud backups, you don't need to configure your own backup gateways.

Important

Direct to cloud backups for Azure databases are supported only for certain regions. If you don't see your region when configuring backups for your Azure PaaS database, please contact your Commvault customer support manager (CSM).
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

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

The Service Catalog page appears.
On the Database tile, click Configure.

The Select the Database Application page appears.
Click Microsoft Azure.

The Select a Database Service page appears.
Select Azure SQL Server and Managed SQL, and then click NEXT.

The Select Backup Method page appears.
Select Backup Direct to Cloud, and then click NEXT.

The Region page appears.
Select the region where the Azure database is located, and then click NEXT.

The Configure Cloud Storage page appears.
For Storage location, select an existing cloud storage location or create a new storage location.

If you create a new storage location, click the refresh button to select the location.
To store a secondary copy, move the Secondary copy toggle key to the right, and then select the location for the secondary copy.
Click NEXT.

The Select a Plan page appears.
Select an existing backup plan or create a new backup plan.

If you create a new backup plan, click the refresh button to select the backup plan.
Click NEXT.

The Cloud Account page appears.
Select an existing cloud account or create a new cloud account,

If you create a new cloud account, click the refresh button to select the cloud account.
Click NEXT.

The Backup Content page appears. On this page you can either configure rule criteria for automatically discovering instances to back up, or you can manually select an instance to back up.
To configure the rule criteria for automatically discovering instances to back up, move the Rule based discovery toggle key to the right.
- To create a rule group to auto-discover and select instances to back up, click Add > Rule group.
  
  The Add rule group dialog box appears.
  1. To specify the type of Match rule, select all or any. The rules for the match are as follows:
    
    all: All rules that you configure for the rule group must be satisfied for a database instance to be discovered.
    
    any: Any rule that you define that is satisfied will result in the matching database being discovered.
  2. From the list of rule types, select the type of rule to create, and then specify the rule:
    - Instance name: Select instances based on their names. For example, to select instances that have a name that includes "east", enter Instance name | Contains | east.
    - Resource group: Select resource groups based on their names. For example, to select resource groups that have a name that includes "prod", enter Resource group | Contains | prod.
    - Tag name: Select instances based on the names of tags that are assigned to them. Enter the tag name in the region\tag_name format. For example, to select instances in the eastern US Region that are for a department, enter Tag name | Equals | us-east-1\department.
    - Tag value: Select instances based on the values of tags that are assigned to them. Enter the tag value in the region\tag_name\tag_value format. For example, to select instances in the eastern US Region for the human resources department, enter Tag value | Equals | us-east-1\department\HR.
  3. Click SAVE.
- To manually create a list of cloud database instances to back up, click Add > Cloud DB instances.
  
  The Add Cloud DB instances dialog box appears.
  1. From the list of instances, select the instances to put in the group.
  2. Click SAVE.
To see the instances that you selected for the group, click the Preview button.
To manually select an instance to back up, move the Rule based discovery toggle key to the left, and then from the Instance name list, select the Azure SQL instance.
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.
If you selected Rule based discovery for discovering instances, in the Specify the storage connection string to be used with managed instances box, enter the connection string.
Click NEXT.

The system creates the instance and displays a summary page that shows the instance configuration.
Click Configure Another Region, or click Finish to go to the instance page.