> Software > Databases > Azure > Azure SQL Database Managed Instance

Configuring an Azure SQL Managed Instance

Configure a cloud instance for an Azure SQL managed instance to enable backup and restore operations.

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

Choose Azure Managed SQL

  1. On the Databases tile, click Configure.

  2. Select Database running in the cloud (PaaS).

  3. Select Microsoft Azure, and then click Next.

  4. Select Azure Managed SQL.

  5. Click Next.

Choose configuration method

  1. Select one of the following options:

  2. Click Next.

    Create the Azure app using express or custom configuration and follow the next steps to continue with the instance configuration.

Choose access node configuration and authentication mechanism

  1. Select one of the following options:

    • Use hosted infrastructure: Select this option to use the hosted infrastructure provided by Commvault for backups.

    • Use your access nodes for backups: Select this option if you want to use your own configured access nodes to perform backups.

  2. Select how you want to authenticate the Azure app.

    • Application: Select one of the following:

      • Use an existing application

        1. From the Credential list, select an existing credential or add a new one.

        2. To assign roles, do the following:

          1. Move the Assign required roles to the selected application toggle key to the right.

          2. Click Open Azure Cloud Shell.

          3. In Subscription ID, enter your Azure subscription ID.

          4. At the Azure Cloud Shell command prompt, paste and run the commands to assign required roles to the selected application.

      • Deploy a new application

        1. In the Application name box, enter a name for the Azure application.

          The commands are updated with the value that you enter.

        2. In the Subscription ID box, enter your Azure subscription ID.

          The commands are updated with the value that you enter.

        3. Under Deploy the application in the selected subscription and get the application details, copy the commands, and then paste them into a text editor.

        4. In the text editor, do the following:

          1. To use a custom role, for --role "Contributor", replace Contributor with the name of your custom role.

            The Storage Blob Data Contributor role is required. Do not remove this role from the commands unless you are certain that your custom role includes Storage Blob Data Contributor.

            For more information about custom roles, see Role and Permission Requirements for Protecting Azure Resources.

          2. Copy the commands.

        5. Click Open Azure Cloud Shell.

          Azure Cloud Shell appears.

        6. At the Azure Cloud Shell command prompt, paste the commands.

          The commands run to create the Azure application, and then the Tenant ID, Application ID, and Application secret for the application are displayed.

        7. In the Commvault configuration wizard, add a new credential.

    • Managed identity: Applies only to Use your access nodes for backups.

      1. In the Subscription ID box, enter the subscription ID for the Azure account.

  3. Click Next.

Choose access node or access node region

  • If you selected hosted infrastructure, from the Region list, select a region.

    Infrastructure from the same region is used as the access node to connect to Azure resources for backup.

  • If you opted to use your own access nodes, from the Access nodes list, select the access node to connect to the Azure resources.

    For information on how to configure an access node, see Adding an Access Node.

Plan creation

  1. Select an existing backup plan or create a new backup plan to associate with the instance.

    If a region for hosted infrastructure is selected, only backup plans associated with that region are displayed.

    Steps to create a backup plan

    1. Click the add button add/plus button - gray - no border.

      The Create backup plan dialog box appears.

    2. For Plan name, enter a descriptive name for the backup plan.

    3. To configure backups, select Configure backups.

    4. For Storage, select or add the storage pool where you want to store backups.

    5. Under Frequency, specify the frequency of the backup.

    6. Under Retention period, specify the duration for which the backup must be retained.

    7. To specify the additional retention, such as weekly full backups, select Add extended retention and then add rules.

    8. To add an additional storage copy, select Add second copy.

    9. From the Storage list, select or add the storage to use for the backups.

    10. Under Backups to copy, select the backup type.

    11. Under Retention period, enter the amount of time to retain the backups.

      To specify additional retention period, such as weekly full backups, select Add extended retention and then add rules.

    12. To add a third optional storage copy for maximum redundancy, select Add third copy, and then configure the storage, backup type, and retention settings.

    13. Click Save.

Choose cloud account

  1. From the Cloud account list, select an existing Azure account or add a new account.

    Steps to add new cloud account

    1. Beside the Cloud account list, click +.

      The Add cloud account dialog box appears.

    2. In the Name box, type the name for the account.

    3. Enter the subscription information:

      • For the traditional authentication method of deployment, enter the following information:

        • Subscription ID: Enter the subscription ID for the Azure account.

        • Credential: If you have already configured the credentials entity, select them from the list. To define a new credential, click + beside the list. For more information, see Adding credential.

      • For the managed identity authentication method of deployment, configure the following settings:

        • Connect using managed identities for Azure resources: Move the toggle key to the right.

        • Subscription ID: Enter the subscription ID for the Azure account.

    4. Click Save.

Choose backup content

  1. From the Backup Content page appears, you can either configure rule criteria for automatically discovering instances to back up, or you can manually select an instance to back up.

  2. Click Next.

Submit

  1. Review your selections, and then click Submit to complete the configuration.
×

Loading...