Sample Header Ad - 728x90

server trigger for Always On failover

0 votes
2 answers
484 views
I am working on a solution for a quite specific problem with environments (SQL Server using AO, with two replicas) having SSRS in scale-out, each node has MSSQL and SSRS installed, and when there is a Failover for MSSQL, one account is removed from the SSRS SCALE-out, for that reason I need to apply a workaround that I have already available, however now I have to find the exact moment to apply it, I have two options, 1. first is to create a SQL Agent job that runs every x minutes and does apply the fix 2. find a way to capture the failover event and apply the fix. has anyone created a SQL Server trigger to capture Always On failovers?
Asked by Carlos DBA (1 rep)
Sep 15, 2022, 09:35 PM
Last activity: Aug 6, 2025, 08:05 PM