Skip to main content
Manage administrative groups for MS SQL
Updated over 3 months ago

This topic describes the following sections:

Overview of administrative groups

An administrative group is a logical categorization of the servers that share something in common. For example, servers located in one region can belong to one administrative group. Similarly, servers having the same operating system can belong to another administrative group.

An administrative group allows you to organize your servers for better management. To manage the servers under a group, you assign a group admin. It is mandatory that you create an administrative group and attach servers to it.

View administrative groups

  1. Log in to Druva Cloud Platform Console.

  2. Click Global Navigation (three horizontal lines) icon > Enterprise Workloads > Select the required organization from the All Organizations menu, and then click Manage > Administrative Groups.

  3. The Manage Administrative Groups page displays a list of available administrative groups.

  4. You can click the administrative group for which you want to view details.

  5. The Summary tab of the administrative group details page displays the following fields:
    ​

    PBS_AdminGroupSummary.png

Field

Description

Description

The description for the administrative group.

# Resources

The number of servers associated with the administrative group.

Backup Trend

The Backup Trend section displays backup jobs for the last seven days with the following three statuses:

  • Backups successful

  • Backups successful with errors

  • Backups failed

For the detailed explanation of each parameter, see Dashboards.

Backup Data Trend

The Backup Data section illustrates the following data for the last 90 days:

Source + Changes: The amount of backup data generated at the source. This includes the initial full backup and incremental data from all subsequent backups.

Current Source: The size of the data on the source server(s) at the time of the last backup.

The Resources tab of the administrative group details page displays the following fields:

Field

Description

Name

The name of the resource.

Resource Type

The type of resources such as Physical Server, VMware VM, Hyper-V VM, NAS Share, SQL Availability Group, Phoenix Store, and SQL Standalone Instance.

Add an administrative group

  1. Log in to Druva Cloud Platform Console.

  2. Click Global Navigation (three horizontal lines) icon> Enterprise Workloads > Select the required organization from the All Organizations menu, and then click Manage > Administrative Groups.

  3. Click New Group.

    clipboard_e8624d13735384f3dfc91ff3a4b22cfba.png
  4. Enter the name and description of the group and click Save.

  5. The administrative group created now appears on the Manage Administrative Groups page.

Update administrative group details

  1. Log in to Druva Cloud Platform Console.

  2. Click Global Navigation (three horizontal lines) icon > Enterprise Workloads. Select the required organization from the All Organizations menu, and then click Manage > Administrative Groups.

  3. The Manage Administrative Groups page displays a list of available administrative groups.

  4. To update an administrative group you can:

    • Select an administrative group and click Edit.
      OR

    • Click on the administrative group and on the Administrative group details page, click Edit.

  5. The Edit Administrative Group dialog box opens. Edit the name and/or description.

  6. Click Save.

Change administrative group

You can change the administrative group associated with a SQL instance or availability group.

Procedure

  1. Log in to the Management Console.

  2. Select the workload from the Protect menu. Note that if the All Organizations menu is enabled, you have to first select an organization that has the MS-SQL server instances and availability groups, and then select the workload.

  3. On the All SQL Resources page, select one or more resources, click more options, and then click Change Administrative Group.
    ​
    ​

    Change administrative group.png

πŸ“ Note
​ You cannot change the administrative group if your organization has just one administrative group.


  1. In the Change Administrative Group dialog box, select the administrative group from the Change Administrative Group to drop-down list, and click Save.
    ​
    ​

    Change administrative group to.png


    The instance or AG is now associated with the selected administrative group.
    ​


πŸ“ Note
​ For a single-server configuration, the Change Administrative Group to drop-down list does not display the administrator group that is associated with the MS-SQL server.


Add an administrative group while creating a backup set

You can create an administrative group for a SQL server while creating a backup set for the instance or AG. The option to create a new administrative group is available if none of the instances or availability groups on the server are unconfigured and hasn’t been assigned an administrative group yet.

  1. Log in to the Management Console.

  2. Select the workload from the Protect menu. Note that if the All Organizations menu is enabled, you have to first select an organization that has the MS-SQL server instances and availability groups, and then select the workload.

  3. On the All SQL Resources page, select the instance or availability group, and then click Create Backup Set.

  4. In the Create SQL Backup Set dialog box, under Administrative Group, click New Administrative Group.
    ​

    New Administrative Group.png
  5. In the Create New Administrative Group dialog box, enter the following:
    ​

    Create Administrative Group.png
    1. Name:A unique name for the administrative group.

    2. Description: An optional description for the administrative group.

  6. Click Save.

  7. For more information on the other field descriptions in the Create SQL Backup Set wizard, see the Configure MS-SQL instance or AG for backup article.
    ​

Delete an administrative group

You can delete an administrative group at any time. However, If a resource is mapped to the group you cannot delete the group.

  1. Log in to Druva Cloud Platform Console.

  2. Click Global Navigation (three horizontal lines) icon> Enterprise Workloads > Select the required organization from the All Organizations menu, and then click Manage > Administrative Groups.

  3. The Manage Administrative Groups page displays a list of available administrative groups.

  4. To delete an administrative group you can:

    • Select an administrative group and click Delete.
      OR

    • Click on the administrative group and on the Administrative group details page, click Delete.

  5. The Delete Administrative Group dialog opens. Edit the name and/or description.

  6. Click Save.

Did this answer your question?