Solved

SQL Services

Posted on 2010-09-15
3
340 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 29

Accepted Solution

by:
Rich Weissler earned 500 total points
Comment Utility
"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
Comment Utility
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
Comment Utility
First to answer. Just got to the answers this morning.   Thanx
0

Featured Post

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Join & Write a Comment

Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
Possible fixes for Windows 7 and Windows Server 2008 updating problem. Solutions mentioned are from Microsoft themselves. I started a case with them from our Microsoft Silver Partner option to open a case and get direct support from Microsoft. If s…
This tutorial will walk an individual through the steps necessary to enable the VMware\Hyper-V licensed feature of Backup Exec 2012. In addition, how to add a VMware server and configure a backup job. The first step is to acquire the necessary licen…
This tutorial will show how to configure a new Backup Exec 2012 server and move an existing database to that server with the use of the BEUtility. Install Backup Exec 2012 on the new server and apply all of the latest hotfixes and service packs. The…

762 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

Need Help in Real-Time?

Connect with top rated Experts

6 Experts available now in Live!

Get 1:1 Help Now