Tag: Availability Group

This blog post will show how to dynamically add logic at the beginning of jobs in Availability Groups in order to avoid job execution errors in the replica or replicas. Problem In SQL Availability Groups the SQL jobs have to…

Method – Job Category This blog post will show how to setup SQL Jobs in multiple availability groups. This method will allow you to dynamically detect the role of the SQL Server replica and avoid job execution errors in the…

We recently ran into an interesting issue on a three-node SQL Server Availability Group (AG) cluster. There was a cluster failure that impacted the availability group for a few minutes during which the replicas changed to resolving state. Once the…