Skip to main content
NetApp Backup and Recovery
All cloud providers
  • Amazon Web Services
  • Google Cloud
  • Microsoft Azure
  • All cloud providers

Protect Microsoft SQL workloads using NetApp Backup and Recovery overview

Contributors netapp-mwallis
PDFs

Back up your Microsoft SQL Server application data from on-premises ONTAP systems to AWS, Azure, or StorageGRID using NetApp Backup and Recovery. The system automatically creates and stores backups in your cloud account, following your policies. Use a 3-2-1 strategy: keep three copies of your data on two storage systems and one copy in the cloud.

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

  • Multiple data copies protect against internal and external cybersecurity threats.

  • Using different types of media helps you recover if one type fails.

  • You can quickly restore from the onsite copy, and use the offsite copies if the onsite copy is compromised.

NetApp Backup and Recovery uses NetApp SnapMirror to synchronize backups by creating snapshot copies and and transferring them tothe backup locations.

You can do the following to protect your data:

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

Supported backup destinations

NetApp Backup and Recovery enables you to back up Microsoft SQL Server instances and databases from the following source systems to the following secondary systems and object storage in public and private cloud providers. Snapshot copies reside on the source system.

Source system Secondary system (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 system (a replicated volume) or in object storage (a backup file) to the following systems. Snapshot copies reside on the source system and can be restored only to that same system.

From Backup File Location To Destination system

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.