Availability Group Aware SQL Agent Jobs

When an Availability Group fails over, the databases in the Availability Group start processing writes on a different replica. System databases can’t be part of an Availability Group because each replica has its own master, model and msdb database.  SQL Agent jobs are stored in the msdb database so we have to deploy our agent jobs to each node in the […]

Sign Up

James Anderson SQL Server DBA

Hi, I'm James Anderson. When I'm not blogging about SQL Server, I do this.

The SQL People

DBA Stackexchange Profile