Skip to main content
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 workload, backup content, and backup policy. A backup set is defined for an instance or AG and associated with a backup set type, such as File or MS-SQL. You can attach multiple backup sets to the instances or AGs of the MS-SQL server. 

You can add backup sets from the All SQL Resources tab on the MS-SQL Servers page and the Servers detail page.

This topic describes the following sections:

Add a backup set

You can create multiple backup sets to back up different instances and databases of that are a part of the AlwaysOn 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 a 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 the 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, Phoenix agent can simultaneously back up three backup sets.

You can create a backup set for an instance or an AG from the Instance/AGs tab of the MS-SQL Servers page:

View details of the backup sets

  1. Log in 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 Protect > MS-SQL Servers
  4. On the MS-SQL page, click the SQL Backup Sets tab.
    The SQL Backup Sets tab lists the backup sets created for instances and AGs. 
  5. Click the instance or an AG for which you want to view details of the attached backup sets.

    To quickly search and select a resource, you can use the search box on the SQL backup sets tab to filter the listed resources. Type the backup set name, instance/AG name or the database name in the search tab to narrow down on the resource that you want to select.
    bn_sql_search_backupset.png

  6. On the Servers details page, the SQL Backup Set section displays the details of the backup sets attached to the server.
    backupset_naming_sql_details.png

Edit a backup set

You can modify 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 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 Protect > MS-SQL Servers. 
  4. Click the SQL Backup Sets tab.
  5. In the All SQL Resources column, click the instance or the AG associated with the backup set that you want to modify.

    To quickly search and select a resource, you can use the search box on the SQL backup sets tab to filter the listed resources. Type the backup set name, instance/AG name or the database name in the search tab to narrow down on the resource that you want to select.
    bn_sql_search_backupset.png

  6. Under the SQL Backup Set section, click More > Edit.
    The Edit Backup Set page opens.

    backupset_name_sql_edit.png
  7. On the Backup Content tab, edit the backup set name if required, add or remove databases from the backup set. You can either select or deselect databases or use the exclusion and inclusion filters.

    To use the inclusion filter, enter a database name or pattern to include the database in the backup set. For example, enter Emp to include all databases with the term Emp in their names. If there are three databases on the instance with names as HREmployeesFinanceEmployees, and EngineeringEmployees, adding the pattern Emp includes all the three databases in the backup set. If you add a database to your SQL Server, and it is not a part of another backup set yet it qualifies for configuration using the substring, Phoenix includes the database for backup in the oldest backup set that has the inclusion filter. The text inputs in this field are case sensitive. If you enter Emp, Phoenix includes databases that have the substring in their names and if the substring matches the case of the text that you enter. For example, Phoenix includes the FinanceEmployees database, but Phoenix skips including the database exemployees in the backup set. You can enter more than one substrings.

    To use the exclusion filter, enter a database name or pattern to exclude the database from the backup set. For example, there are two databases on the instance with names as FormerSystems and FormerSoftware. Adding the substring Former in this list excludes both the databases from the backup set.  The text inputs in this field are case sensitive. If you enter Former, Phoenix includes databases that have the substring in their names and the if the substring matches the case of the text that you enter. For example, Phoenix excludes the FormerSystems database, but Phoenix skips excluding the database formerproducts from the backup set. You can enter more than one substrings.

    The exclusion filter takes precedence over the inclusion filter. For example, there is a database on the instance called FormerEmployees. The FormerEmployees database should be included based on the inclusion filter, however, it should be excluded based on the exclusion filter. In such a case, Phoenix excludes the database from the backup set. 

    If a database is a part of backup set, Phoenix cannot attach it to another backup set.
  8. On the Storage & Backup Policy tab, select a new backup policy for the backup set. For more information about backup policies, see Manage backup policies. You cannot edit the storage specified for the backup set. In case of SQL backup set for the availability group, you cannot modify the storage and time zone fields defined in the backup set. 
  9. Click Next.
  10. On the Summary tab, verify all the details and click Finish. If you update the retention period in the backup policy, it will apply to the restore points created after this update.

Note: If you add a database to the SQL Server, ensure that you use the include field in the backup sets with appropriate substrings added so that Phoenix can detect the newly added database and attach it to a backup set automatically.

Disable and enable backup of backup set

You can disable or enable the backup of backup sets. After disabling, the backups from the MS-SQL backup sets stop temporarily. The disabled backups resume after you enable the backup from this MS-SQL backup set. 

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

Procedure

  1. Log in 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 Protect > MS-SQL Servers
  4. In the All SQL Resources tab, click the instance or AG name associated with the backup set from which you want to disable or enable the backup.

    To quickly search and select a resource, you can use the search box on the SQL backup sets tab to filter the listed resources. Type the backup set name,  instance/AG name or the database name in the search tab to narrow down on the resource that you want to select.
    bn_sql_search_backupset.png

  5. To disable the backup of the backup set on the servers details page, 
    • Under the Backup Sets section, click More Disable Backup.
      backupset_name_disable_backup.png
  • To enable the backup of the backup set on the servers details page,
    • Under the Backup Sets section, click More Enable Backup.
      backupset_name_enablee.png
Note: The Enable Backup button is available only for the servers that are currently disabled. 
You can continue to restore servers that you have 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, Phoenix purges the snapshot data from the warm storage, thus freeing up space. 

Note: You cannot delete the most-recent snapshot of the MS-SQL backup set.

Procedure

  1. Log in 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 Protect > MS-SQL Servers
  4. On the MS-SQL page under the All SQL Resources tab, select the instance or AG associated with the backup set from which you want to delete a snapshot.

    To quickly search and select a resource, you can use the search box on the SQL backup sets tab to filter the listed resources. Type the backup set name, instance/AG name or the database name in the search tab to narrow down on the resource that you want to select.
    bn_sql_search_backupset.png

  5. On the server page, click  Restore.
  6. In the left pane, expand the warm node under Snapshots.
  7. Select the snapshots that you want to delete, and click Delete Snapshot.
    SQL_delete_snapshot.PNG

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, Phoenix deletes all the restore points corresponding to that backup set. However, Phoenix retains the jobs, reports, and alerts corresponding to the deleted backup set.

  1. Log in 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 Protect > MS-SQL Servers
  4. On the MS-SQL page under the All SQL Resources tab, click the instance or AG name associated with the backup set that you want to delete.

    To quickly search and select a resource, you can use the search box on the SQL backup sets tab to filter the listed resources. Input the instance/AG name or the database name in the search tab to narrow down on the resource that you want to select.
    bn_sql_search_backupset.png

  5. On the Server details page, under the SQL Backup Set section, click More > Delete on the backup set.

Phoenix deletes the backup set associated with the instance or the AG.