Skip to main content
BlueXP backup and recovery
Azure
  • Amazon Web Services
  • Google Cloud
  • Microsoft Azure
  • All cloud providers

Protect Microsoft SQL workloads overview with BlueXP backup and recovery

Contributors amgrissino
PDFs

Protect your Microsoft SQL Server applications data from on-premises ONTAP systems to Amazon Web Services, Microsoft Azure, or StorageGRID using BlueXP backup and recovery. Backups are automatically generated and stored in an object store in your public or private cloud account based on the policies you create. You can implement a 3-2-1 strategy, where you have 3 copies of your source data on 2 different storage systems along with 1 copy in the cloud.

The benefits of the 3-2-1 approach include:

  • Multiple data copies provide multi-layer protection against both internal (insider) and external cybersecurity threats.

  • Multiple media types ensure failover viability in the case of physical or logical failure of one media type.

  • The onsite copy facilitates quick restores, with the offsite copies available just in case the onsite copy is compromised.

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.

You can accomplish the following protection goals:

To back up workloads, typically you create policies that govern the backup and restore operations. See Create policies for more information.

Supported backup destinations

BlueXP backup and recovery enables you to back up Microsoft SQL Server instances and databases from the following source working environments to the following secondary working environments and object storage in public and private cloud providers. Snapshot copies reside on the source working environment.

Source Working Environment Secondary Working Environment (Replication) Destination Object Store (Backup)

Cloud Volumes ONTAP in AWS

Cloud Volumes ONTAP in AWS
On-premises ONTAP system

Amazon S3
ONTAP S3

Cloud Volumes ONTAP in Azure

Cloud Volumes ONTAP in Azure
On-premises ONTAP system

Azure Blob
ONTAP S3

On-premises ONTAP system

Cloud Volumes ONTAP
On-premises ONTAP system

Amazon S3
Azure Blob
NetApp StorageGRID
ONTAP S3

Amazon FSx for NetApp ONTAP

Amazon FSx for NetApp ONTAP

NA
Supported restore destinations

You can restore Microsoft SQL Server instances and databases from a backup that resides in primary storage or a secondary working environment (a replicated volume) or in object storage (a backup file) to the following working environments. Snapshot copies reside on the source working environment and can be restored only to that same system.

From Backup File Location To Destination Working Environment

Object Store (Backup)

Secondary System (Replication)

Amazon S3

Cloud Volumes ONTAP in AWS
On-premises ONTAP system

Cloud Volumes in AWS
On-premises ONTAP system
ONTAP S3

Azure Blob

Cloud Volumes ONTAP in Azure
On-premises ONTAP system

Cloud Volumes ONTAP in Azure
On-premises ONTAP system
ONTAP S3

StorageGRID

Cloud Volumes ONTAP
On-premises ONTAP system

On-premises ONTAP system
ONTAP S3

Amazon FSx for NetApp ONTAP

Amazon FSx for NetApp ONTAP

NA
Note References to "on-premises ONTAP systems" include FAS and AFF systems.