October 9, 2015 at 10:43 am
Hi,
We have a cluster environment. I didn't see any stop, start or restart options either for Sql Server db engine or for sql agent.
I need to restart the Sql Server Agent. What is the best way to restart the agent?
Do I need to go to services and restart from there or from SSCM
October 9, 2015 at 10:49 am
Use cluster administrator. Take the resource offline, and back online.
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
October 9, 2015 at 1:16 pm
We have another environment which is also cluster environment.
But I can see SQL agent restart, stop. I use the restarted the agent from SSMS instead of cluster manger. Is it causes any issues?
October 9, 2015 at 1:36 pm
It shouldn't.
When a cluster is setup, cluster services take over the management of anything that's been clustered. So you would want to use that to do any type of admin work on the cluster resources.
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
October 12, 2015 at 9:42 am
Hi,
We are using Windows 2012 & Sql Server 2014.
I can see only failovercluster manager but not able to find the Cluster administrator.
Is both are same?
October 12, 2015 at 9:51 am
Yes. My memory is failing. 😀
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
October 12, 2015 at 12:56 pm
ramana3327 (10/12/2015)
Hi,We are using Windows 2012 & Sql Server 2014.
I can see only failovercluster manager but not able to find the Cluster administrator.
Is both are same?
Failover cluster manager replaces cluster administrator.
You can also use powershell to stop and start the cluster resources 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 12, 2015 at 2:13 pm
Yes,
I can see take offline option under cluster core resources.
So restarting means taking that offline and bring that back online
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply