Skip to main content
SnapCenter Software 6.0

Back up SQL Server databases running on Azure NetApp Files

Contributors netapp-soumikd netapp-nsriram
PDFs

If a resource is not yet part of any resource group, you can back up the resource from the Resources page.

Before you begin

You should create a load balancer, if the Azure Windows Failover Cluster does not have a cluster IP assigned or if it is not reachable from SnapCenter. The load balancer's IP should be configured and reachable from the SnapCenter Server.

Steps

  1. In the left navigation pane, select Resources, and then select the appropriate plug-in from the list.

  2. In the Resource page, select Database, Instance, or Availability Group from the View drop-down list.

  3. In the Resource page, select Use custom name format for Snapshot copy, and then enter a custom name format that you want to use for the Snapshot name.

  4. In the Policies page, perform the following steps:

    1. Select one or more policies from the drop-down list.

    2. Select add policy from resourcegroup in the Configure Schedules column for the policy for which you want to configure a schedule.

    3. In the Add schedules for policy policy_name dialog box, configure the schedule, and then select OK.

      policy_name is the name of the policy that you selected.

    4. Select Use Microsoft SQL Server scheduler, and then select the scheduler instance from the Scheduler Instance drop-down list that is associated with the scheduling policy.

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

    1. Select the verification server.

    2. Select the policy for which you want to configure your verification schedule, and then click add policy from resourcegroup.

    3. Either select Run verification after backup or Run scheduled verification.

    4. Click OK.

  6. In the Notification page, from the Email preference drop-down list, select the scenarios in which you want to send the emails.

  7. Review the summary, and then click Finish.

  8. Select Back up Now.

  9. In the Backup page, perform the following steps:

    1. If multiple policies are associated with the resource, from the Policy drop-down list, select the policy that you want to use for backup.

    2. Select Verify after backup.

    3. Select Backup.

  10. Monitor the operation progress by clicking Monitor > Jobs.