Protect Microsoft SQL Server workloads with NetApp Backup and Recovery
Suggest changes
PDFs
Back up Microsoft SQL Server databases from on-premises ONTAP systems to AWS, Azure, or StorageGRID using NetApp Backup and Recovery. Implement a 3-2-1 backup strategy with snapshots on primary storage, replication to secondary storage, and copies to object storage.
NetApp Backup and Recovery uses NetApp SnapMirror to synchronize backups by creating snapshots and transferring them to the backup locations.
Use the following workflows to protect your data:
To back up workloads, you create policies that manage backup and restore operations. See Create policies for more information.
NetApp Backup and Recovery supports backups of Microsoft SQL Server instances and databases from the following source systems to the listed secondary systems and object stores in public and private clouds. Snapshots remain on the source system.
| Source system | Secondary system (replication) | Destination object store (backup) |
|---|---|---|
Cloud Volumes ONTAP in AWS |
Cloud Volumes ONTAP in AWS |
Amazon S3 |
Cloud Volumes ONTAP in Azure |
Cloud Volumes ONTAP in Azure |
Azure Blob |
On-premises ONTAP system |
Cloud Volumes ONTAP |
Amazon S3 |
Amazon FSx for NetApp ONTAP |
Amazon FSx for NetApp ONTAP |
NA |
You can restore Microsoft SQL Server instances and databases from a backup that resides in primary storage, a secondary system (replicated volume), or object storage (backup file) to the following destination systems. Snapshots 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 |
Cloud Volumes ONTAP in AWS |
Azure Blob |
Cloud Volumes ONTAP in Azure |
Cloud Volumes ONTAP in Azure |
StorageGRID |
Cloud Volumes ONTAP |
On-premises ONTAP system |
|
References to "on-premises ONTAP systems" include FAS and AFF systems. |