Skip to main content

 

Druva Documentation

Manage server groups

Phoenix Editions: File:/tick.png Business File:/cross.png Enterprise File:/tick.png Elite

About Microsoft SQL server groups

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

At the time of creating a server group, you must associate it with storage, and attach backup policies to the server group. Backup policies define the data for backup, and the backup schedule. Assigning a server to a server group eliminates the need for configuring backup policies for individual servers, thus simplifying server management. 

Best practices for creating server groups for SQL servers

In a production environment, we recommend that you create one or more server groups for your SQL servers, depending on the backup needs of the servers. For example, if your SQL server databases do not change frequently, you can create a server group and assign to the group with a backup policy that includes a monthly full backup, a weekly differential backup, and a log backup after every 120 minutes. For SQL servers having high volumes of data activity, you can create a server group, and assign to this group a backup policy that includes weekly full backups, daily differential backups, and log backups every 30 minutes.

We recommend that the server groups that you create include SQL servers that are geographically co-located. We also recommend that you assign server groups to storages that are geographically the closest. This ensures faster backups and restores while reducing the demand on your organization's bandwidth. 

Example server group for SQL servers

As an example, consider two remote offices, A and B, both having 5 SQL servers and file servers each. The SQL servers in remote office location A see frequent, significant changes to their databases. The remote office A is located in Seattle. The SQL servers in remote office location B do not change frequently. The remote office B is located in New York. For SQL servers of the remote location A, you can consider creating a server group, and attaching to it a backup policy that includes a weekly full backup, along with daily differential backups and log backups every 30 minutes. At the time of creating this server group, you can assign to this group a storage that is geographically closest to Seattle. Similarly, for SQL servers at remote location B, you can create a server group, and assign to this server group a backup policy that includes a monthly full backup, along with differential backups every second day of a week, and a log backup after every 120 minutes. 

Note: This is just an example scenario. The exact server group and backup policy configuration for your setup depend on your SQL server data needs and your organization's policies. However, you can request for backup policy recommendations by writing to the Druva Support team (support@druva.com). 

In addition to creating a new server group at the time of configuring a server, you can create, view, update, and remove a server group from the Phoenix menu bar.

Create a server group

If you are a cloud administrator, you can create a server group for your SQL servers. In a production environment, we recommend that you create one or more server group each for servers or virtual machines that are geographically co-located. For more information about servers groups, see About server groups

Note: Before creating a server group, ensure that you create the backup and retention policy that you want to assign to the server group. 

Procedure:

  1. Log on to Phoenix Management Console. 
  2. On the menu bar, click All Organizations, and select the required organization from the drop-down list.
  3. On the menu bar, click Manage > Server Groups
  4. Click Add New Server Group
  5. On the Add Server Group page, under Group Summary, provide the following details.

    Field

    Description

    Server Group Name

    The name for this server group.

    Storage

    The storage that you want to associate with this server group.

    Note: Once selected, you cannot change the storage. 

    Backup Policy Type

    The type of backup policy that you want to assign to this server group.

    Phoenix provides the following options to assign backup policies to the server group.

    • File/MS-SQL
    • VMware

    Click File/MS-SQL to apply File Server and MS-SQL Server backup policies to the server group.

    Backup Policy

    The backup policy that you want to assign to this server group.

    To assign a MS-SQL Server backup policy to the server group,

    • Under Backup Policy, select the MS-SQL Server check box, and select the required policy from the corresponding drop-down list.

    Note: If your server runs a mixed workload of File Server and MS-SQL Server, you can assign File Server and MS-SQL Server backup policies to the server group. To assign a File Server backup policy to the server group, select the File ​​​​Server check box, and select the required policy from the corresponding drop-down list.

    Retention Policy

    The retention policy that you want to assign to this server group.

  6. Click Save.

View server group details

This topic provides instructions to view the server group details page.

Procedure

  1. Log on to Phoenix Management Console. 
  2. On the menu bar, click All Organizations, and select the required organization from the drop-down list.
  3. On the menu bar, click Manage > Server Groups
  4. Click the server group name.
    The Server Groups details page is displayed.

    Field

    Description

    # Servers The total number of servers associated with the Server group.
    # Snapshots The total hot, warm, and cold snapshots for the MS-SQL Server. The thawed snapshots are counted as warm snapshots.

    Backup & Restore

    The Backup & Restore section displays backup and restore jobs for the last 7 days with the following three statuses: 

    • Successful
    • Successful With Errors (Backup only)
    • Failed 

     For more information about each parameter, see Organization Dashboard.

    Bandwidth Usage

    The Bandwidth Usage section displays the average bandwidth consumed over the last one week. 

    Configuration

    The Configuration section displays the following:

    • Storage: The storage used by the Server group.
    • CloudCache: The Cloud Cache associated with the server group.
    • MS-SQL Server Backup Policy: The name of the MS-SQL Server backup policy used.
    • File Server Backup Policy: The name of the File Server backup policy used.
    • Retention Policy: The name of the retention policy used.

    Backup Data

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

    • Source+Change: The amount of backup data generated at 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.

Update server group details

To change the backup policy or the retention policy of a server group, modify this server group. When you change the backup policy of a server group, the backup policy rules no longer apply to the server group. Instead, Phoenix backs up data following the rules defined by the new backup policy.

Note: After you assign a new backup policy, the first backup from your servers is a full backup. However, Phoenix saves a copy of the backup data that was created following the previous backup policy.

Similarly, when you change the retention policy of a server group, the retention rules of the new policy are applicable for all servers belonging to this server group. 

Note: You cannot update the server group to include a different type of servers. For example, if you created a server group for file servers, you cannot update this server group to include SQL servers or virtual machines. 

Procedure

  1. Log on to Phoenix Management Console. 
  2. On the menu bar, click All Organizations, and select the required organization from the drop-down list.
  3. On the menu bar, click Manage > Server Groups
  4. Click the server group that you want to update.
  5. Under the Summary area, click Edit
  6. On the Edit Server Group page, provide the following details:
    • Server Group Name: A name for this server group. 
    • Backup policy: The File Server or MS-SQL Server backup policy that you want to assign to this server group.

      Note: If your server runs mixed workloads of File Server and MS-SQL Server, you can apply File Server and MS-SQL Server backup policies to the server group. 

      The Backup Policy (File Server or MS-SQL Server) field gets disabled, if servers configured in this server group are not compatible with the backup policy type.

    • Retention policy: The retention policy that you want to assign to this group. 
  7. Click Save.

Note: If you try to detach a backup policy from a server group by clearing the File Server or MS-SQL Server check box, the restore points for the backup policy get deleted for all the servers attached to that server group.

Remove a server group

If you are a cloud administrator, you can delete server groups at any time. Before deleting a server group, ensure that you reassigned the servers associated with this server group to another server group. To assign the servers to a new server group, you must reconfigure these servers. 

Procedure

  1. Log on to Phoenix Management Console. 
  2. On the menu bar, click All Organizations, and select the required organization from the drop-down list.
  3. On the menu bar, click Manage > Server Groups.
  4. Click the server group that you want to delete.
  5.  Click Delete.