Back up Microsoft SQL Server workloads with NetApp Backup and Recovery
Suggest changes
PDFs
Back up Microsoft SQL Server application data from on-premises ONTAP systems to Amazon Web Services, Microsoft Azure, or StorageGRID. The system automatically creates backups and stores them in an object store in your cloud account for data protection.
-
To back up workloads on a schedule, create policies that manage backup and restore operations. See Create policies for instructions.
-
Configure the log directory for discovered hosts before starting a backup.
-
Back up workloads now (create an on-demand backup now).
View workload protection status
Before you start a backup, view the protection status of your workloads.
Required NetApp Console role
Storage viewer, Backup and Recovery super admin, Backup and Recovery backup admin, Backup and Recovery restore admin, Backup and Recovery clone admin, or Backup and Recovery viewer role. Learn about Backup and recovery roles and privileges. Learn about NetApp Console access roles for all services.
-
From the NetApp Backup and Recovery menu, select Inventory.
-
Select a workload to view the protection details.
-
Select the Actions icon
> View details. -
Review details on the Hosts, Protection groups, Availability groups, Instances, and Databases tabs.
Configure the log directory for discovered hosts
Set the activity log path for discovered hosts to track operation status before backing up workloads.
Required NetApp Console role
Storage viewer, Backup and Recovery super admin, Backup and Recovery backup admin, or Backup and Recovery restore admin role. Learn about NetApp Console access roles for all services.
-
From the NetApp Backup and Recovery menu, select Inventory.
-
Select a workload to view the protection details.
-
Select the Actions icon
> View details. -
Select a host.
-
Select the Actions icon
> Configure log directory. -
Enter the host path or browse through a list of hosts or nodes to find where you want to store the host log.
-
Select those on which you want to store the logs.
The fields that appear differ depending on the selected deployment model, for example, failover cluster instance or standalone. -
Select Save.
Create a protection group
Create a protection group to manage backup and restore operations for multiple workloads. A protection group is a logical grouping of workloads.
Required NetApp Console role
Storage viewer, Backup and Recovery super admin, or Backup and Recovery backup admin role. Learn about NetApp Console access roles for all services.
-
From the NetApp Backup and Recovery menu, select Inventory.
-
Select a workload to view the protection details.
-
Select the Actions icon
> View details. -
Select the Protection groups tab.
-
Select Create protection group.
-
Provide a name for the protection group.
-
Select the instances or databases that you want to include in the protection group.
-
Select Next.
-
Select the Backup policy that you want to apply to the protection group.
If you want to create a policy, select Create new policy and follow the prompts to create a policy. See Create policies for more information.
-
Select Next.
-
Review the configuration.
-
Select Create to create the protection group.
Back up workloads now with an on-demand backup
Run an on-demand backup before making changes to your system to ensure your data is protected.
Required NetApp Console role
Storage viewer, Backup and Recovery super admin, or Backup and Recovery backup admin role. Learn about NetApp Console access roles for all services.
-
From the menu, select Inventory.
-
Select a workload to view the protection details.
-
Select the Actions icon
> View details. -
Select the Protection Group, Instances or Databases tab.
-
Select the instance or database you want to back up.
-
Select the Actions icon
> Back up now. -
Select the policy that you want to apply to the backup.
-
Select the schedule tier.
-
Select Back up now.
Suspend the backup schedule
Suspend the schedule to temporarily stop backups during maintenance or troubleshooting.
Required NetApp Console role
Storage viewer, Backup and Recovery super admin, or Backup and Recovery backup admin role. Learn about NetApp Console access roles for all services.
-
From the NetApp Backup and Recovery menu, select Inventory.
-
Select a workload to view the protection details.
-
Select the Actions icon
> View details. -
Select the Protection Group, Instances or Databases tab.
-
Select the protection group, instance, or database you want to suspend.
-
Select the Actions icon
> Suspend.
Delete a protection group
Deleting a protection group removes it and all associated backup schedules. You might want to delete a protection group if it is no longer needed.
Required NetApp Console role
Storage viewer, Backup and Recovery super admin, or Backup and Recovery backup admin role. Learn about NetApp Console access roles for all services.
-
From the NetApp Backup and Recovery menu, select Inventory.
-
Select a workload to view the protection details.
-
Select the Actions icon
> View details. -
Select the Protection groups tab.
-
Select the Actions icon
> Delete protection group.
Remove protection from a workload
You can remove protection from a workload if you no longer want to back it up or if you want to stop managing it in NetApp Backup and Recovery.
Required NetApp Console role
Storage viewer, Backup and Recovery super admin, or Backup and Recovery backup admin role. Learn about NetApp Console access roles for all services.
-
From the NetApp Backup and Recovery menu, select Inventory.
-
Select a workload to view the protection details.
-
Select the Actions icon
> View details. -
Select the Protection Group, Instances or Databases tab.
-
Select the protection group, instance, or database.
-
Select the Actions icon
> Remove protection. -
In the Remove protection dialog box, select whether you want to keep backups and metadata or delete them.
-
Select Remove to confirm the action.