Skip to main content

Protect Microsoft SQL Server workloads

Contributors netapp-rlithman
PDFs

Protect your Microsoft SQL Server applications data using BlueXP 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 BlueXP backup and recovery. The plug-in is a host-side component of NetApp Software that enables you to protect your Microsoft SQL Server workloads.

BlueXP 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 BlueXP backup and recovery, refer to the Protect Microsoft SQL workloads overview with BlueXP backup and recovery.

Before you begin

The following requirements must be met to protect Microsoft SQL Server workloads with BlueXP backup and recovery.

  • Ensure that your environment meets the BlueXP backup and recovery SQL Server requirements.

  • Complete BlueXP requirements including setting up BlueXP, IAM roles, and a BlueXP Connector.

    If you have organization administrator access to the BlueXP account, the backup and recovery super admin role is automatically assigned when you prepare for protection with BlueXP 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.

  • Set up licensing for BlueXP backup and recovery

  • In workload factory for Databases, make sure that you register instances using Windows credentials. To provide Windows credentials, go to the Instances tab from the Inventory. Identify the instance, select Manage instances, and then select Instance dashboard. From the instance dashboard, select the three-dot menu, and then select Update Microsoft SQL Server password. Update the password using Windows authentication.

Prepare for protection with BlueXP backup and recovery

Complete the preparation process to protect your Microsoft SQL Server resources with BlueXP backup and recovery.

Steps

  1. Log in using one of the console experiences.

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

  3. In Databases, select the Inventory tab.

  4. Filter the Engine type to Microsoft SQL Server.

  5. Select Protect from the menu for the instance to protect.

  6. Select the Connector where you want the workload to be registered and protected.

  7. To prepare for data protection, Workload factory automatically registers your SQL Server resources in BlueXP 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.

  8. After meeting the prerequisites, select Redirect to access BlueXP backup and recovery.

What's next

From BlueXP 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 BlueXP backup and recovery documentation for managing Microsoft SQL Server workloads.