Skip to main content
Version: DPX 4.9

Microsoft SQL Server

Microsoft SQL Server Standard and Enterprise editions are supported. Microsoft SQL Server Express is not supported. Review the following table and notes to ensure that you are using the supported version of Microsoft SQL Server and its operating system:

Table 29a. Available features for Microsoft SQL Server for Microsoft Windows Server 2019​

Microsoft SQL ServerMicrosoft SQL Server 2019
File-level backup❌
Block-level backup✅For block-level protection, Microsoft SQL Server AlwaysOn Availability Groups is supported.
AlwaysOn Availability Groups are supported.
Instant availability✅
Cluster support✅Catalogic DPX supports both Active/Active and Active/Passive clusters.

Table 29b. Available features for Microsoft SQL Server for Microsoft Windows Server 2016​

(Microsoft SQL Server 2016 ReFS is supported on Microsoft Windows Server 2016.)

Microsoft SQL ServerMicrosoft SQL Server 2017, 2016
File-level backup❌
Block-level backup✅For block-level protection, Microsoft SQL Server AlwaysOn Availability Groups is supported.
AlwaysOn Availability Groups are supported.
Instant availability✅
Cluster support✅Catalogic DPX supports both Active/Active and Active/Passive clusters.

Tables 29c–e. Available features for Microsoft SQL Server for Microsoft Windows Server 2012 R2​

Table 29c. Features available for Microsoft SQL Server 2016​

Microsoft SQL ServerMicrosoft SQL Server 2016 with or without Service PackQualified 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 Reference Guide.
File-level backup❌
Block-level backup✅For block-level protection, Microsoft SQL Server AlwaysOn Availability Groups is supported.
AlwaysOn Availability Groups are supported.
Instant availability✅
Cluster support✅Catalogic DPX supports both Active/Active and Active/Passive clusters.

Table 29d. Features available for Microsoft SQL Server 2014​

Microsoft SQL ServerMicrosoft SQL Server 2014 with or without Service PackQualified up to Microsoft SQL Server 2014 SP2 on Windows Server 2012 R2.
File-level backup✅Microsoft SQL Server AlwaysOn Availability Groups are not supported.
Block-level backup✅Microsoft SQL Server 2016 ReFS is supported on Microsoft Windows Server 2016.
AlwaysOn Availability Groups are supported.
Instant availability✅
Cluster support✅Catalogic DPX supports both Active/Active and Active/Passive clusters.

Table 29e. Features available for Microsoft SQL Server 2012​

Microsoft SQL ServerMicrosoft SQL Server 2012 Service Pack 1 or laterQualified up to Microsoft SQL Server 2012 SP2 on Windows Server 2012 R2.
Qualified up to Microsoft SQL Server 2012 SP3 on Microsoft Windows Server 2012 R2.
File-level backup✅Microsoft SQL Server AlwaysOn Availability Groups are not supported.
Block-level backup✅AlwaysOn Availability Groups are supported.
Instant availability✅
Cluster support✅Catalogic DPX supports both Active/Active and Active/Passive clusters.

Tables 29f–g. Available features for Microsoft SQL Server for Microsoft Windows Server 2012​

Table 29f. Features available for Microsoft SQL Server 2014​

Microsoft SQL ServerMicrosoft SQL Server 2014 with or without Service Pack
File-level backup✅Microsoft SQL Server AlwaysOn Availability Groups are not supported.
Block-level backup✅AlwaysOn Availability Groups are supported.
Instant availability✅
Cluster support✅Catalogic DPX supports both Active/Active and Active/Passive clusters.

Table 29g. Features available for Microsoft SQL Server 2012​

Microsoft SQL ServerMicrosoft SQL Server 2012 Service Pack 1 or later
File-level backup✅Microsoft SQL Server AlwaysOn Availability Groups are not supported.
Block-level backup✅AlwaysOn Availability Groups are supported.
Instant availability✅
Cluster support✅Catalogic DPX supports both Active/Active and Active/Passive clusters.