Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

SQL Services

Posted on 2010-09-15
3
345 Views
Last Modified: 2012-05-10
We have a cluster with resources shared. We needed to reconfigure one of the resources so we cleared out the data on the drive, all was fine. Removed the resource and sql server service and agent stopped. Should this have happened? These services are set to manual on one server and automatic on the other in the cluster. What is best parctice for the configuration of these services on the servers in the cluster? This is a two node cluster running windows 2008R2 with SQL 2008 R2.
0
Comment
Question by:imcbmichaelb
3 Comments
 
LVL 30

Accepted Solution

by:
Rich Weissler earned 500 total points
ID: 33691793
"Removed the resource" = You removed a disk volume?

I suspect SQL Server service was configured with a dependency for that volume.
The Agent is dependent almost certainly dependent on the SQL Server service.

If the drive goes away, SQL Server says one of it's dependencies is gone and stops, and when that happens the Agent has to stop too.

I know on my SQL 2005 cluster, I have to have the dependency set on all the volumes I want to use... (which makes sense, I don't want SQL to try to start if the Log or Database volume are unavailable.)  I haven't 'played' with my 2008 R2 cluster enough to determine if that constraint is still required.

My understanding is that the SQL Services and Agent should be manual on both servers, and you allow the clustering service to take care of starting the services.
0
 
LVL 3

Expert Comment

by:novaspoonman
ID: 33692482
Best practice is to let the Cluster service handle SQL Server service and SQL Agent Service. They should both be set to manual startup on each cluster node, so that the cluster service can start them on the active node at boot or at failover.

Anytime you remove a resource from a group or application that is a dependency of something, then that something will be grumpy.

In fact, in order for SQL Server to be able to see Disk X, then Disk X must be a dependency of SQL Server in a clustered scenario.
0
 

Author Closing Comment

by:imcbmichaelb
ID: 33693435
First to answer. Just got to the answers this morning.   Thanx
0

Featured Post

Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Restoring deleted objects in Active Directory has been a standard feature in Active Directory for many years, yet some admins may not know what is available.
This tutorial will walk an individual through locating and launching the BEUtility application to properly change the service account username and\or password in situation where it may be necessary or where the password has been inadvertently change…
This tutorial will walk an individual through setting the global and backup job media overwrite and protection periods in Backup Exec 2012. Log onto the Backup Exec Central Administration Server. Examine the services. If all or most of them are stop…

791 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question