Microsoft SQL Server
Microsoft SQL Server Standard and Enterprise editions are supported. Microsoft SQL Server Express is not supported. Review the following matrix and notes to ensure that you are using the supported version of Microsoft SQL Server and its operating system.
| Feature | Server 2022 | Server 2019 | Server 2016 | Server 2012 R2 (SQL 2016) | Server 2012 R2 (SQL 2014) | Server 2012 |
|---|---|---|---|---|---|---|
| Microsoft SQL Server Version | Microsoft SQL Server 2022 | Microsoft SQL Server 2022, 2019 | Microsoft SQL Server 2017, 2016 ¹ | Microsoft SQL Server 2016 with or without Service Pack ² | Microsoft SQL Server 2014 with or without Service Pack ³ | Microsoft SQL Server 2014 with or without Service Pack |
| File-level Backup | ✅ ⁴ | ✅ ⁴ | ✅ ⁴ | ❌ | ✅ ⁴ | ✅ ⁴ |
| Block-level Backup | ✅ ⁵ | ✅ ⁵ | ✅ ⁵ | ✅ ⁵ | ✅ ⁶ | ✅ ⁷ |
| Instant Availability | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ |
| Cluster Support | ✅ ⁸ | ✅ ⁸ | ✅ ⁸ | ✅ ⁸ | ✅ ⁸ | ✅ ⁸ |
¹ Microsoft SQL Server 2016 ReFS is supported on Microsoft Windows Server 2016.
² Qualified up to Microsoft SQL Server 2016 with AlwaysOn Availability Groups on Microsoft Windows Server 2012 R2 with CSV configuration. For issues related to SQL and CSV combination, refer to Additional Considerations for CSV in DPX under Clustered Shared Volumes of the DPX 4.9 Reference Guide.
³ Qualified up to Microsoft SQL Server 2014 SP2 on Windows Server 2012 R2.
⁴ Microsoft SQL Server AlwaysOn Availability Groups are not supported.
⁵ For block-level protection, Microsoft SQL Server AlwaysOn Availability Groups is supported. AlwaysOn Availability Groups are supported.
⁶ Microsoft SQL Server 2016 ReFS is supported on Microsoft Windows Server 2016. AlwaysOn Availability Groups are supported.
⁷ AlwaysOn Availability Groups are supported.
⁸ Catalogic DPX supports both Active/Active and Active/Passive clusters.