Skip to main content

Protect Microsoft SQL Server workloads

Contributors netapp-rlithman
PDFs

Protect your Microsoft SQL Server applications data using NetApp Backup and Recovery from the Workload Factory console. With this integration, you can achieve the following protection goals: back up workloads with local snapshots on local primary Amazon FSx for NetApp ONTAP (FSx for ONTAP) storage, and replicate workloads to secondary FSx for ONTAP storage.

About this task

Workload Factory automates discovering resources, validating prerequisites, and configuring and installing the Plug-in for Microsoft SQL Server to prepare for protecting your workloads with NetApp Backup and Recovery. The plug-in is a host-side component of NetApp Software that enables you to protect your Microsoft SQL Server workloads.

NetApp Backup and Recovery leverages NetApp SnapMirror data replication technology to ensure that all the backups are fully synchronized by creating snapshot copies and transferring them to the backup locations.

For details about protection with Backup and Recovery, refer to the Protect Microsoft SQL workloads overview with Backup and Recovery.

Before you begin

The following requirements must be met to protect Microsoft SQL Server workloads with Backup and Recovery.

If you have organization administrator access to the NetApp account, the backup and recovery super admin role is automatically assigned when you prepare for protection with NetApp Backup and Recovery.

  • Set the host resolution on the Connector

    To discover databases, you must set host resolution on the Connector. On the hosted device, add the mapping of the IP address to the hostname in the /etc/hosts file.

Prepare for protection with NetApp Backup and Recovery

Complete the preparation process to protect your Microsoft SQL Server resources with NetApp Backup and Recovery.

Steps

  1. Log in using one of the console experiences.

  2. In the Databases tile, select Go to Databases inventory.

  3. From the Databases menu, select Inventory.

  4. In the Inventory, select Microsoft SQL Server as the engine type.

  5. Locate the instance that you want to protect, and then select Protect from the menu.

  6. If prompted, provide Windows credentials with administrative access.

    To use NetApp Backup and Recovery for protection, SQL Server instances must be registered in Workload Factory with Windows credentials.

  7. If several Console agents are active and available, select the Console agent where you want the workload to be registered and protected.

  8. To prepare for data protection, Workload Factory automatically registers your SQL Server resources in Backup and Recovery, configures and installs the Plug-in for Microsoft SQL Server, and discovers resources to meet the prerequisites for protecting your SQL Server instance. Select Start to begin the process.

  9. After meeting the prerequisites, select Redirect to access Backup and Recovery.

What's next

From Backup and Recovery, create a policy to protect your Microsoft SQL Server instance and databases.

Learn how to create a policy to protect your Microsoft SQL Server instance and databases.

For related information, refer to the Backup and Recovery documentation for managing Microsoft SQL Server workloads.