Creating resource groups and attaching policies for SQL Server

A resource group is a container to which you add resources that you want to back up and protect together. A resource group enables you to back up all of the data that is associated with a given application simultaneously. A resource group is required for any data protection job. You must also attach one or more policies to the resource group to define the type of data protection job that you want to perform.

About this task

You can protect resources individually without creating a new resource group. You can take backups on the protected resource.

Steps

  1. In the left navigation pane, click Resources, and then select the appropriate plug-in from the list.
  2. In the Resources page, select Database from the View list.
    Note: If you have recently added a resource to SnapCenter, click Refresh Resources to view the newly added resource.
  3. Click New Resource Group.
  4. On the Name page, perform the following actions:
    For this field… Do this…
    Name Enter the resource group name.
    Tags Enter one or more labels that will help you later search for the resource group.

    For example, if you add HR as a tag to multiple resource groups, you can later find all resource groups associated with the HR tag.

    Use custom name format for Snapshot copy Optional: Enter a custom Snapshot copy name and format.

    For example, customtext_resourcegroup_policy_hostname or resourcegroup_hostname. By default, a timestamp is appended to the Snapshot copy name.

  5. In the Resources page, perform the following steps:
    1. Select the host name, resource type, and the SQL Server instance from drop-down lists to filter the list of resources.
      Note: If you have recently added resources, they will appear on the list of Available Resources only after you refresh your resource list.
    2. To move resources from the Available Resources section to the Selected Resources section, perform one of the following steps:
    • Select Autoselect all resources on same storage volume to move all of the resources on the same volume to the Selected Resources section.
    • Select the resources from the Available Resources section and then click the right arrow to move them to the Selected Resources section.
  6. In the Policies page, perform the following steps:
    1. Select one or more policies from the drop-down list.
      Note: You can also create a policy by clicking .
      In the Configure schedules for selected policies section, the selected policies are listed.
    2. In the Configure schedules for selected policies section, click in the Configure Schedules column for the policy for which you want to configure the schedule.
    3. In the Add schedules for policy policyname policy_name dialog box, configure the schedule by specifying the start date, expiration date, and frequency, and then click OK.
      You must do this for each frequency listed in the policy. The configured schedules are listed in the Applied Schedules column in the Configure schedules for selected policies section.
    4. Select the Microsoft SQL Server scheduler.

      You must also select a scheduler instance to associate with the scheduling policy.

      If you do not select Microsoft SQL Server scheduler, the default is Microsoft Windows scheduler.
  7. In the Verification page, perform the following steps:
    1. Select the verification server from the Verification server drop-down list.
      You can select multiple verification servers (local host or remote host).
      Note: The verification server version should match the version and edition of the SQL server that is hosting the primary database.
    2. Click Load locators to load the SnapMirror and SnapVault volumes to perform verification on secondary storage.
    3. Select the policy for which you want to configure your verification schedule, and then click .
    4. In the Add Verification Schedulespolicy_name dialog box, perform the following actions:
      If you want to... Do this...
      Run verification after backup Select Run verification after backup.
      Schedule a verification Select Run scheduled verification.
    5. Click OK.
      The configured schedules are listed in the Applied Schedules column. You can review and then edit by clicking icon to edit configured schedules or delete by clicking delete icon.
  8. In the Notification page, from the Email preference drop-down list, select the scenarios in which you want to send the emails.
    You must also specify the sender and receiver email addresses, and the subject of the email. If you want to attach the report of the operation performed on the resource group, select Attach Job Report.
    Note: For email notification, you must have specified the SMTP server details either using the GUI or PowerShell command Set-SmSmtpServer.
  9. Review the summary, and then click Finish.