Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Move SQL Instance to Another Node from a Remote Server Expand / Collapse
Author
Message
Posted Thursday, October 3, 2013 10:28 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Monday, October 21, 2013 4:51 PM
Points: 68, Visits: 161
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?



Post #1501416
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse