If Possible, how can I connect Redgate DLM Dashboard to a SQL Always On Cluster?

RBHRBH Posts: 1 New member
We have a 3 node SQL always on Cluster environment. Do I have to install Redgate on each node or is it possible to connect the cluster rather than each individual node?

Answers

  • mkalmkal Posts: 2 New member
    I would like to know if this is possible as well.
  • MrRimmerMrRimmer Posts: 4 New member
    edited May 11, 2020 12:15PM
    I installed on the primary replica of a HA group, changed the recovery model to Full, did a full backup then added Redgate to the availability databases.
  • MrRimmerMrRimmer Posts: 4 New member
    Thought I should update here. Backed off from adding Redgate to the HA cluster as it causes havoc when the primary node is moved.
    Now we have a standalone instance of Redgate on each node in the cluster, and point DLM dashboard to the cluster name (so it always sees the primary).
Sign In or Register to comment.