SQL Server Availability Group

Automatic Failover of Availability Group to the Preferred Node


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 *