Resource group storage on cluster shared volumes (CSV) and SMB 3.0 shares Unitrends protects a variety of cluster configurations, such as: In a SQL cluster, one or more SQL Server failover cluster instances are installed into a Windows Server Failover Cluster (WSFC). Unitrends supports protection of databases that reside on SMB 3.0 shares. SQL Server 2012 and higher can host SQL instances with disk storage located on SMB 3.0 shares. Nodes in the Windows Server Failover Cluster must be running Windows 2012 or later. Unitrends supports protection of databases that reside on clustered shared volumes. For example, Unitrends backups capture the data on the local SQL server only (and do not include any data in the paired Azure database). Unitrends supports protection of Stretch databases with some limitations. Unitrends supports protection of SQL Always Encrypted databases.Ī Stretch database consists of a database that resides on the local SQL server and a paired database that resides in Microsoft Azure.

The Always Encrypted feature encrypts SQL data at rest and in motion. Unitrends best practices for backup and recovery vary by SQL database type and recovery model.

Unitrends protects SQL system databases and user databases. The following table describes the SQL features that Unitrends protects.

Sql back up master