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 […]
Hi, I'm James Anderson. When I'm not blogging about SQL Server, I do this.