The Databases guided setup guides you through creating a server plan and adding a SQL database server.
Go to the Databases Guided Setup
From the navigation pane, go to Guided setup.
The Welcome page appears.
On the Protect tab, click the Databases tile.
The Databases guided setup appears.
Create a Server Plan That You Can Use for the Azure SQL Managed Instances
The server plan defines how often the software backs up the database and the log files, and where it stores the backups.
If you already have a server plan that you can use, you can skip this step.
Before You Begin
To create a server plan, you must have the Plan Creator Role assigned to your user account.
Procedure
On the Create server backup plan page, click Create a new plan, and then specify the settings for a server plan that you can use for the SQL Server instance.
Settings | Steps |
---|---|
Plan name |
|
Backup destinations |
|
RPO |
|
Folders to back up |
|
Snapshot options |
|
Database options |
|
Override restrictions | Leave the Allow plan to be overridden check box cleared. |
Click Save.
Add a Database Server for Azure SQL Managed Instance
On the Add database servers page, from the Application type list, select Cloud DB.
From the Select vendor list, select Microsoft Azure.
From the Database service list, select SQL server.
Beside Cloud account, click +.
The Add cloud account dialog box appears.
In the Name box, enter a name for the new cloud account.
To connect to the Azure account using managed identities, move the Connect using managed identities for Azure resources toggle key to the right.
For more information about setting up managed identities for Azure, see Setting up Managed Identity Authentication for Azure Resource Manager.
In the Subscription ID, Tenant ID, Application ID, and Application password boxes, enter the details that you need to access data on the Azure cloud.
For instructions about accessing this information from the Azure portal, see SQL Server Azure Cloud Connection Properties.
Note: If you enabled connecting to the Azure account using managed identities, you need only the subscription ID.
From the Access nodes list, select the access nodes to use for the managed instance.
The operating system of the access node can be either Windows or Red Hat Enterprise Linux. You can add multiple access nodes to discover instances and databases. The Commvault software uses only the first proxy server in the list.
To specify the connection information for Azure SQL managed instance, under Connection details, enter the following information:
Go to Azure SQL managed instance, in the Storage Connection String box, enter the string that you use to access data in the Azure storage account.
Beside the SQL server authentication list, click +.
The Add credential dialog box appears.
In the Credential, User account, Password, and Description boxes, enter the credentials of a an 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.
Click Save.
From the Plan list, select the server plan to use for the Azure database server.
From the Instance name list, select the Azure SQL managed instance.
Go to Connection details, and complete the following:
In the Storage connection string box, enter the string that you use to access data in the Azure storage account.
From the SQL server authentication list, select the credentials of an Azure Server admin account.
Click Finish.