You can use a guided setup to configure Azure SQL Managed Instance 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
-
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 via gateway, and then click NEXT.
The Region page appears.
-
Select the region where the Azure database is located, and then click NEXT.
The Select the Backup Gateway selection page appears.
-
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.
-
-
Click NEXT.
The Configure Cloud Storage page appears.
-
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.
-
-
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.
-
Click NEXT.
The page to select a backup plan appears.
-
To specify the backup 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.
-
-
Click NEXT.
The Cloud Account page appears.
-
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.
-
-
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.
-
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.
-
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.
-
-
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.
-
From the list of instances, select the instances to put in the group.
-
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.
-
-
In the Specify storage connection string box, enter the string to access data within the Azure storage account.
Tip
To get the connection string for your storage account, in the Azure portal, go to the storage account, and then go to Security + networking > Access keys.
-
Click NEXT.
The system creates the instance and displays a summary page that shows the instance configuration.
-
You can click CONFIGURE ANOTHER REGION or click FINISH to display the characteristics of the instance.