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 Instances/AGs 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 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 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.
  6. On the Servers details page, the SQL Backup Set section displays the details of the backup sets attached to the server.
    SQL_View_backup_Set_Info.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 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 Protect > MS-SQL Servers. 
  4. Click the SQL Backup Sets tab.
  5. In the Instance/AG Name column, click the instance or the AG associated with the backup set that you want to modify.
  6. Under the SQL Backup Set section, click More > Edit.
    The Edit Backup Set page opens.
    SQL_EditBackupSet1.PNG
  7. On the Storage & Backup Content tab, modify your custom content to back up databases on your MS-SQL server.  For more information about the custom content, see Backup content. In case of SQL backup set for the availability group, you cannot edit the Storage and Time Zone fields defined in the backup set.
  8. Click Next.
  9. On the Backup Policy tab, from the Backup Policy drop-down list, select the required backup policy that you want to attach to the server. For more information about how to create a new backup policy, see Attach new backup policy.
    SQL_Edit_Backup_Set_BackupPolicy.PNG
  10. Click Finish.
    If you update the retention period in the backup policy, it will apply to the restore points created after this update.

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 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 Protect > MS-SQL Servers
  4. Click the SQL Backup Sets tab.
  5. In the Instance/AG Name column, click the instance or AG name associated with the backup set from which you want to disable or enable the backup.
  6. Disable or enable the backup set:
  • To disable the backup of the backup set on the servers details page, 
    • Under the Backup Sets section, click More Disable Backup.
      SQL_DisableBackup.PNG
  • To enable the backup of the backup set on the servers details page,
    • Under the Backup Sets section, click More Enable Backup.
      SQL_Enable_Backup.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. 

You cannot delete cold snapshots. However, the cold snapshots get deleted as per the retention period defined in the backup policy.

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

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 Protect > MS-SQL Servers
  4. On the MS-SQL tab, click the SQL Backup Sets tab,
  5. In the Instance/AG Name column, select the instance or AG associated with the backup set from which you want to delete a snapshot.
  6. Click  Restore.
  7. In the left pane, expand the hot or warm node under Snapshots.
  8. 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, 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 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 Protect > MS-SQL Servers
  4. On the MS-SQL tab, click the SQL Backup Sets tab,
  5. In the Instance/AG Name column, click the instance or AG name associated with the backup set that you want to delete.
  6. On the Server details page, under the SQL Backup Set section, click More > Delete.

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