Skip to main content

How can we help you?

Druva Documentation

Manage backup set

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

This topic provides an overview of what backup set is. It also provides instructions to add and delete a backup set attached to the instances or availability groups (AG).

Overview

A backup set is a combination of backup content and backup policy. A backup set is defined for an instance or AG. You can attach multiple backup sets to the instances or AGs of the MS-SQL server.  You can add a backup set from the All SQL Resources page under Protect > MS-SQL servers.

This topic describes the following sections:

Add a backup set

You can create multiple backup sets to back up different instances and availability groups, following different schedules.  Before you create a backup set, review the following:

  • You can create only one MS-SQL backup set per instance or AG.
  • If you do not need distinct backup retention for different data on the physical server, do not create separate backup sets.
  • Ensure that you do not create multiple backup sets with overlapping backup content. The overlapping content gets backed up multiple times.
  • You can create any number of backup sets to configure with a physical server. However, the Phoenix agent can simultaneously back up three backup sets.

You can create a backup set for an instance or an AG from the All SQL Resources page under Protect > MS-SQL servers. For more information on creating backup sets, see:

View details of the backup sets

  1. Log in to the Phoenix Management Console.
  2. On the menu bar, click the drop-down next to All Organizations and select the organization which has your MS-SQL server instances and availability groups.
  3. On the menu bar, click Protect > MS-SQL servers.
  4. In the navigation pane on the left, click SQL Backup Sets. The SQL Backup Sets page lists all the backup sets created for all instances and AGs. You can also search for the backup set, instance, AG or DB from the SQL Backup Sets page using the search box. 

    Search SQL backup sets.png
  5. Click the instance or AG whose backup set details you want to view.
  6. The information on the SQL Backup Sets details page is divided into the Summary and Backups tab. The Summary tab lists the Backup Configuration, Backup Content, and trends.

    Backup Set details - Summary.png
    The Backups tab lists all the snapshots associated with the backup set.

    Backup Set details - Backups.png

Edit a backup set

You can modify the backup settings and the backup content and backup policy applied to the MS-SQL backup set. However, you cannot edit the name of the instance or availability group.

  1. Log in to the Phoenix Management Console.
  2. On the menu bar, click the drop-down next to All Organizations and select the organization which has your MS-SQL server instances and availability groups.
  3. On the menu bar, click Protect > MS-SQL servers.
  4. In the navigation pane on the left, click SQL Backup Sets
  5. In the right pane, click the backup set to view backup set details. You can also search for the backup set from the SQL Backup Sets page using the search box. 
  6. On the SQL Backup Sets details page, in the top right corner, click more options, and click Edit.

    Edit a backup set.png
  7. In the Edit Backup Set window, you can edit all fields except the Storage field. Storage once assigned cannot be changed. To know more about the fields available in the Edit Backup Set wizard, see Configure MS-SQL instance or AG for backup.
    Backup settings.png
     

Note:

  1. If you add a database to your SQL Server, and it is not a part of an existing backup set, yet it qualifies for configuration because it matches an include substring, Druva Phoenix includes the database for backup in the oldest backup set that has the inclusion filter.
  2. If one SQL backup set has the Select all databases checkbox selected, while another backup set of the same SQL server has a specific pattern, then newly added databases that have the specified substring in their name will automatically get included in the backup set with the specific pattern, while the remaining databases will get included in the backup set with the Select all databases checkbox selected.  The backup set with a specific substring gets priority during the automatic addition of new databases.
  3. If a database is a part of backup set, Druva Phoenix cannot attach it to another backup set.These databases are greyed out and cannot be selected in a second backup set.
  1. On the Backup Content screen, edit the database selection, rule, and include and exclude patterns and click Next. For more information, see Configure MS-SQL instance or AG for backup.
    Backup content.png
  2. The Configuration Pre-Checks window is displayed with the following validations:
    Pre-configuration checks.png

    To prevent any future failures in your backups due to misconfigured settings, Druva Phoenix broadly performs these validations while editing a backup set:

    Field Descriptions
    Sysadmin privileges for the user account Transaction Log and VDI differential backups require the assigned SQL server user login to have the ‘Sysadmin’ role. This validation ensures that the same is provided.
    Database mirroring check Phoenix supports backup of mirrored databases with some limitations. This validation ensures that mirroring is disabled for all the selected databases. For more information, see System requirements for MS-SQL servers.
    Database recovery model check Databases in Simple recovery model do not support Transaction Log backups. 
    If the backup set is configured for Transaction Log backups, this validation ensures that at least one of the selected databases is in the Full recovery model.

    For more information about validation checks, see Configure MS-SQL instance or AG for backup.

  3. If a check to create a backup set fails, then fix the issue and re-run the checks. If all the checks are successful, then the Summary screen is displayed.
    If a check fails and you still want to proceed, then click Proceed Anyway.

  4. On the summary screen, verify all the details, and click Save.

Note: Ensure that the Include Pattern fields in your backup sets have appropriate substrings so that Druva Phoenix can automatically detect newly added databases and attach them to the backup set.

 

Disable and enable backup of backup set

You can enable or disable backup of backup sets. Backups of disabled backup sets stop temporarily. The disabled backups resume after you enable the backup.

Note: Druva Phoenix retains the data from the MS-SQL servers that you disable. 

You can enable or disable backups of a backup set from:

SQL Backup Sets page

  1. Log in to the Phoenix Management Console.
  2. On the menu bar, click the drop-down next to All Organizations and select the organization which has your MS-SQL server instances and availability groups.
  3. On the menu bar, click Protect > MS-SQL servers.
  4. In the navigation pane on the left, click SQL Backup Sets
  5. In the right pane, select the backup set of the instance or AG , click more options, and then click Enable Backup to enable backups of that backup set. 

    SQL Backup sets - Enable Disable backup.png
    Click Disable Backup to disable backups of an enabled backup set.

 

All SQL Resources page

  1. Log in to the Phoenix Management Console.
  2. On the menu bar, click the drop-down next to All Organizations and select the organization which has your MS-SQL server instances and availability groups.
  3. On the menu bar, click Protect > MS-SQL servers.
  4. In the navigation pane on the left, click All SQL Resources
  5. In the right pane, click the instance or AG whose backups you want to enable or disable.
  6. In the All SQL Resources details page, in the Configured Backup Sets section, select the backup set, click more options, and then click Enable Backup to enable backups of that backup set.

    Enable backup- Resource details.png
    Click Disable Backup to disable backups of an enabled backup set.

Note: The Enable Backup option is available only for the backup sets whose backup is currently disabled. Similarly, the Disable Backup option is available only for backup sets whose backup is currently enabled. You can continue to restore servers whose backups have been disabled.

Delete snapshots

If you are a cloud administrator, you can delete warm snapshots from the MS-SQL backup sets that you no longer require. If you are a group administrator, you can delete warm snapshots for MS-SQL backup sets belonging to the administrative groups that you manage. After you delete a snapshot, Druva Phoenix purges the snapshot data from the warm storage, thus freeing up space.

Procedure

  1. Log in to the Phoenix Management Console.
  2. On the menu bar, click the drop-down next to All Organizations and select the organization which has your MS-SQL server instances and availability groups.
  3. On the menu bar, click Protect > MS-SQL servers.
  4. In the navigation pane on the left, click SQL Backup Sets
  5. In the right pane, click the backup set whose snapshots you want to delete.
  6. In the SQL Backup Sets details page, click the Backups tab.
  7. In the Snapshots section, select the snapshots that you want to delete, and then click Delete.

    Delete snapshot.png

Note: The last snapshot for a backup set cannot be deleted.
 

Delete a backup set

If you are a cloud administrator, organization administrator, group administrator,  or a derived custom, organization, or group administrator, you can delete a backup set created for the instance or AG. When you delete a backup set, Druva Phoenix retains the backup set data for 7 days after its deletion.  After 7 days, Druva Phoenix deletes all the restore points corresponding to that backup set. However, Druva Phoenix retains the jobs, reports, and alerts corresponding to the deleted backup set.

  1. Log in to the Phoenix Management Console.
  2. On the menu bar, click the drop-down next to All Organizations and select the organization which has your MS-SQL server instances and availability groups.
  3. On the menu bar, click Protect > MS-SQL servers.
  4. In the navigation pane on the left, click SQL Backup Sets.
  5. In the right pane, click the backup set that you want to delete.
  6. In the SQL Backup Sets details page, in the top right corner, click more options, and then click Delete.

    Delete backup set.png
    Druva Phoenix deletes the backup set associated with the instance or the AG.