Skip to main content
SnapCenter Software 4.7
A newer release of this product is available.

Create resource groups and attach policies for SQL Server

Contributors netapp-soumikd
PDFs

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.

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. In the Name page, perform the following actions:

    For this field…​ Do this…​

    Name

    Enter the resource group name.

    Note The resource group name should not exceed 250 characters.

    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 add policy from resourcegroup.

      In the Configure schedules for selected policies section, the selected policies are listed.

    2. In the Configure schedules for selected policies section, click add policy from resourcegroup in the Configure Schedules column for the policy for which you want to configure the schedule.

    3. In the Add schedules for policy 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.

    Third party backup schedules are not supported when they overlap with SnapCenter backup schedules. You should not modify the schedules and rename the backup job created in Windows scheduler or SQL Server agent.

  7. In the Verification page, perform the following steps:

    1. Select the verification server from the Verification server drop-down list.

      The list includes all the SQL Servers added in SnapCenter. 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 add policy from resourcegroup.

    4. In the Add Verification Schedules policy_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.

Find more information

Create backup policies for SQL Server databases