February 13, 2014 at 9:02 pm
how to bring the sql services in to offline in a cluseter , naviagte procedure to tak to offline/onlnie ?
February 14, 2014 at 8:54 am
To bring a SQL Server service offline in a clustered environment, you would just have to go to Failover Cluster Manager, find the application group you want to shut down, right click on the SQL Server resource, and select "bring offline". The resource will stay offline, even if the rest of the group fails over to another node.
February 14, 2014 at 9:08 am
ramyours2003 (2/13/2014)
how to bring the sql services in to offline in a cluseter , naviagte procedure to tak to offline/onlnie ?
via a command prompt on the Windows 2008 cluster node run the following
cluster res "SQL Server (instancename)" /off
To restart the service use
cluster res "SQL Server Agent (instancename)" /on
From outside the cluster (i.e. when logged onto a node in a different cluster) use the following
cluster /cluster:clustername res "SQL Server (instancename)" /off
To restart the service use
cluster /cluster:clustername res "SQL Server Agent (instancename)" /on
Double check the instancename and substitute it into the command line queries above
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 14, 2014 at 9:15 am
Perry. Out of curiosity, does the command line utility work across versions of Windows? Right now (and for a few more fiscal months), I have Windows 7 on my laptop, but I have a Windows 2012 cluster running. My problem is the Failover Cluster GUI on Windows 7 does not like the Failover Cluster on Windows 2012, so I end up having to log into a Windows 2012 machine even to check what is running on a particular machine. If the command line can accept different versions of the cluster, it would save me a few logins.
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply