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
Last activity: Aug 6, 2025, 08:05 PM