SQL Server Availability Group

Automatic Failover of Availability Group to the Preferred Node

Objective:

This procedure created for the above subject (heading). If the procedure is executed against master database on the instance using any scheduler like SQL Server Agent jobs and others, then this procedure execution will automatically failover the AG (Availability Group) to the preferred node which is set through configuration table as explained in the procedure

 

Leave a Reply

Your email address will not be published. Required fields are marked *