Check Microsoft SQL Availailbity Group database failover status

With the following script databases in an Microsoft Availability Group cluster can be checked if they are failover ready. Run this script at all the SQL nodes that are past of the Availability Group. When the statys is displayed ‘1’ the database is ready for an failover.

 

Delen via: Facebooktwittergoogle_pluspinterestlinkedinmail