Support for SQL Server Failover Clusters

Veeam Plug-in supports backup and restore of Microsoft SQL Server databases that operate as part of a failover cluster. Both Windows Server Failover Clusters with shared disks and Windows Server Failover Clusters with Cluster Shared Volumes (CSV) are supported.

To back up databases that operate as part of a failover cluster, do the following:

1. Install and configure Veeam Plug-in for Microsoft SQL Server on each node of the cluster. For more information, see Installing Veeam Plug-in for Microsoft SQL Server and Configuring Veeam Plug-in for Microsoft SQL Server.
2. Configure backup settings in Veeam Plug-in on the active cluster node. For more information, see Configuring Backup Settings.

On the passive node, the Microsoft SQL Server instance that operates as part of the cluster is not displayed in the Veeam Plug-in UI.

3. Save backup settings as an SQL Agent job in Microsoft SQL Server Management Studio. For more information, see Saving Backup Settings as SQL Agent Job.

Veeam Plug-in for Microsoft SQL Server will start the backup job on the active cluster node.

To restore a database that operates as part of a failover cluster, you must start the restore process on the active cluster node. On the passive node, the backed-up Microsoft SQL Server instance is not displayed in the Veeam Plug-in UI.