DbDefence on SQL Cluster

DbDefence can be used on clustered servers.

Installation

DbDefence has to be installed on each node of the cluster. Each node of the cluster requires a license. Installation is the same for Failover and AlwaysOn High Availability clusters.

1. Install DbDefence on the active node.

2. Activate DbDefence license.

3. Failover to second node and install DbDefence on the second node.

4. Activate DbDefence license.

Database encryption with AlwaysOn High Availability

1. To encrypt the database you need to remove it from HA group temporarily:

ALTER AVAILABILITY GROUP [TestGroup] REMOVE DATABASE [TestDB]

2. Encrypt the database on the first node.

3. Connect to the second node and encrypt the database on the second node.

4. Return the database to HA group:

ALTER DATABASE [TestDB] SET HADR AVAILABILITY GROUP = [TestGroup]

Database encryption with Failover cluster

1. Connect to the active node and encrypt the database.