Mar 2, 2020
How-To: Bang your Head against AlwaysOn Availability Group Failed Login Messages!
How-To: Bang your Head against #SQLServer AlwaysOn Availability Group #Failed #Login Messages!
Best Practice #1: If you are deploying jobs against databases in AlwaysOn Availability Groups, make sure both jobs exist on all replicas. So, in the event of a failover, the jobs can continue to work.
Best Practice #2: Also, as per best practice, if you are setting up this job, the first step in the job should be to run fn_hadr_is_primary_replica check. Straight forward enough, I think.
Rev…
View On WordPress