Sign in
 
HomeLibraryLearnDownloadsTroubleshootingCommunityForums
SQL Server Developer Center >
> 
> 
How can i restart sqlserver services on active node in sqlserver 2008 R2 cluster?

Answered How can i restart sqlserver services on active node in sqlserver 2008 R2 cluster?

  • Friday, February 01, 2013 8:55 PM
     
     
    Sign In to Vote
    0

    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?

    Thanks,

    Ron.

     

All Replies

  • Friday, February 01, 2013 9:07 PM
    Answerer
     
     Answered
    Sign In to Vote
    0

    Hello Ron,

    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.

    -Sean

    Sean Gallardy | Blog | Twitter

     
  • Sunday, February 03, 2013 9:36 AM
     
     
    Sign In to Vote
    0
    YOu 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
     
     
    Sign In to Vote
    0

    Hi there,

    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.

    Thanks

    kumar

     
  • Monday, February 04, 2013 1:39 AM
     
     
    Sign In to Vote
    0

    Can i stop the sqlservices in cluster administrator or sqlservices in services?.

    Thanks,

    Naidu.

     
  • Monday, February 04, 2013 2:46 AM
    Answerer
     
     
    Sign In to Vote
    0

    Naidu,

    If you're going to stop them I would use cluster administrator.

    -Sean

    Sean Gallardy | Blog | Twitter

     
  • Monday, February 04, 2013 3:23 AM
     
     
    Sign In to Vote
    0

    Hi naidu,

    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.

    thanks

    kumar