Move SQL Instance to Another Node from a Remote Server

• NeilGordon

  SSC Journeyman

  Points: 78

  More actions

  October 3, 2013 at 10:28 pm

  #299461

  I am writing a script using Get-WmiObject to inspect remote clusters and determine if SQL instances are running on their preferred nodes. This is working fine, but now I want the script to move instances to the preferred node when they are on the non-preferred mode.

  I can't find a way of doing this remotely with Get-WmiObject.

  Does anyone know how to do this?