Cool Tips‎ > ‎

Clustering

 

Title

Description

Applicability

 

Get Active Cluster Node

 

Two slightly different methods, depending on SQL version.

 

2000, 2005, 2008, 2008R2, 2012

 

 

Get Basic Cluster Information

 

Active node plus a list of all nodes and shared drives available.

 

2000, 2005, 2008, 2008R2, 2012

 

Cluster Failover Testing     

 

A list of tests to perform to ensure that failover will actually work when needed.

 

2000, 2005, 2008, 2008R2, 2012

 

Cluster Troubleshooting   

 

Some common problems and where to start.

 

2000, 2005, 2008, 2008R2, 2012

 

Get Availability Group Details

Get availability group details - names, nodes, IPs etc


2012, 2014, 2016, 2017 

 

Get Availability Group Secondaries

Get a list of databases on a server that are operating as Availability Group Secondaries

 

2012, 2014, 2016, 2017 

 

Managing SQL Agent Jobs in an Availability Group

Managing SQL Agent jobs on an Availability Group failover

 

2012, 2014, 2016, 2017 

 

 

 

Comments