Help Center/ Cloud Server Backup Service/ Best Practices/ Protecting SQL Server in Failover Cluster Mode
Updated on 2022-02-22 GMT+08:00

Protecting SQL Server in Failover Cluster Mode

Currently, CSBS provides application-consistent backup only on single VMs. The support for clustered databases will be implemented later.

In Failover Cluster mode, the SQL Server service is enabled only on the active node. Because of this, you only need to associate the active node with the policy when creating a CSBS backup. After an active/standby switchover, you need to modify the policy at once to keep the node being backed up is always the active one. To restore data of the active node, stop all standby nodes first.