Friday, February 01, 2013 8:55 PM
How can i restart sqlserver services on active node sqlserver 2008 R2 cluster?
Should the services on active node should be in Manul or automatic?.How is in Passive node,is it be stopped?
Friday, February 01, 2013 9:07 PMAnswerer
1. How can i restart sqlserver services on active node sqlserver 2008 R2 cluster?
Whichever is most comfortable for you - net stop/start, use SQL Server Configuration Manager, etc.
2. Should the services on active node should be in Manul or automatic?
It has to be in manual. If this were not the case it would fail to start if it wasn't the active node as none of the resources would be available for it to start.
3. How is in Passive node,is it be stopped?
Yes, because it is not currently running.
Sunday, February 03, 2013 9:36 AMYOu should not use net/stop start where you can avoid it on a cluster. You should use Failover Cluster Manager/command line WSFC tools (PS or cluster.exe) or SSCM/EM.
Allan Hirt Blog: http://www.sqlha.com/blog Coming in 2013: Mission Critical SQL Server 2012 - the followup to Pro SQL Server 2008 Failover Clustering
Sunday, February 03, 2013 11:12 PM
In your FCI environment from your active node (say: node1) open sqlserver manager and stop the instance. When you stop it, it will automatically fail over to passive node (say node2). No your passive node is your active node.
Then open your cluster manager and choose the node1 and right click and choose option to switch over to the node1.
This will automatically starts your node1 instance and give ownership of the disks to the node1 as well.
Monday, February 04, 2013 1:39 AM
Can i stop the sqlservices in cluster administrator or sqlservices in services?.
Monday, February 04, 2013 2:46 AMAnswerer
Monday, February 04, 2013 3:23 AM
Yes. you can do that. But start and stop SQL services from services is old school technology. From sql2005 onwards Microsoft integrated all sql related services to gather and placed in sql server configuration manager.
This made SQL server administration easy to manage from one place.
As sean mentioned above you can do this from cluster manager as well, if you have more experience with the cluster.