Support matrix for SQL Server Backup in Azure VMs
You can use Azure Backup to back up SQL Server databases in Azure VMs hosted on the Microsoft Azure cloud platform. This article summarizes the general support settings and limitations for scenarios and deployments of SQL Server Backup in Azure VMs.
|Supported deployments||SQL Marketplace Azure VMs and non-Marketplace (SQL Server manually installed) VMs are supported.|
|Supported regions||Azure Backup for SQL Server databases is available in all regions, except France South (FRS), UK North (UKN), UK South 2 (UKS2), UG IOWA (UGI), and Germany (Black Forest).|
|Supported operating systems||Windows Server 2019, Windows Server 2016, Windows Server 2012, Windows Server 2008 R2 SP1
Linux isn't currently supported.
|Supported SQL Server versions||SQL Server 2019, SQL Server 2017 as detailed on the Search product lifecycle page, SQL Server 2016 and SPs as detailed on the Search product lifecycle page, SQL Server 2014, SQL Server 2012, SQL Server 2008 R2, SQL Server 2008
Enterprise, Standard, Web, Developer, Express.
Express Local DB versions aren't supported.
|Supported .NET versions||.NET Framework 4.5.2 or later installed on the VM|
|Supported deployments||SQL Marketplace Azure VMs and non-Marketplace (SQL Server that is manually installed) VMs are supported. Support for standalone instances are always on availability groups.|
Feature considerations and limitations
|Number of databases that can be protected in a server (and in a vault)||2000|
|Database size supported (beyond this, performance issues may come up)||6 TB*|
|Number of files supported in a database||1000|
*The database size limit depends on the data transfer rate that we support and the backup time limit configuration. It’s not the hard limit. Learn more on backup throughput performance.
- SQL Server backup can be configured in the Azure portal or PowerShell. CLI isn't supported.
- The solution is supported on both kinds of deployments - Azure Resource Manager VMs and classic VMs.
- All backup types (full/differential/log) and recovery models (simple/full/bulk logged) are supported.
- For read-only databases: full and copy-only full backups are the only supported backup types.
- SQL native compression is supported if explicitly enabled by the user in the backup policy. Azure Backup overrides instance-level defaults with the COMPRESSION / NO_COMPRESSION clause, depending on the value of this control as set by the user.
- TDE - enabled database backup is supported. To restore a TDE-encrypted database to another SQL Server, you need to first restore the certificate to the destination server. Backup compression for TDE-enabled databases for SQL Server 2016 and newer versions is available, but at lower transfer size as explained here.
- Backup and restore operations for mirror databases and database snapshots aren't supported.
- SQL Server Failover Cluster Instance (FCI) isn't supported.
Backup throughput performance
Azure Backup supports a consistent data transfer rate of 200 Mbps for full and differential backups of large SQL databases (of 500 GB). To utilize the optimum performance, ensure that:
- The underlying VM (containing the SQL Server instance, which hosts the database) is configured with the required network throughput. If the maximum throughput of the VM is less than 200 Mbps, Azure Backup can’t transfer data at the optimum speed.
Also, the disk that contains the database files must have enough throughput provisioned. Learn more about disk throughput and performance in Azure VMs.
- Processes, which are running in the VM, are not consuming the VM bandwidth.
- The backup schedules are spread across a subset of databases. Multiple backups running concurrently on a VM shares the network consumption rate between the backups. Learn more about how to control the number of concurrent backups.
Download the detailed Resource Planner to calculate the approximate number of protected databases that are recommended per server based on the VM resources, bandwidth and the backup policy.
Learn how to back up a SQL Server database that's running on an Azure VM.