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

Controlling SQL Server Agent on a Windows 2003 cluster

Posted on 2008-10-06
4
346 Views
Last Modified: 2010-04-19
We are running a Windows 2003 failover cluster with SQL Server 2000 Enterprise.  Where should SQL server agent service be stopped so as not to initiate a failover? From Services for the Virtual server? From Enterprise Manager?
0
Comment
Question by:KirkSamuels
  • 2
  • 2
4 Comments
 
LVL 22

Accepted Solution

by:
65td earned 125 total points
ID: 22652774
From cluster administrator select properties of the resource, then the Advanced tab, select the Do not restart check box.
0
 

Author Comment

by:KirkSamuels
ID: 22654461
To be more specific, our DBA needed to stop the SQL SERVER AGENT service. He stopped it through Enterprise Manager. When he did this all resources in the cluster group failed over to the next node. Our DBA did not know why this happened and said he had stopped the service this way before and the cluster had not failed over, but the the SQL Server Agent service stopped.
The check box is set to Restart but has not changed.
0
 
LVL 22

Expert Comment

by:65td
ID: 22658972
One would have to review the cluster log from time that event occurred, but suspect that service was in use and when stopped the cluster could not restart the resource so it restarted the group on the secondary node.
0
 

Author Comment

by:KirkSamuels
ID: 22661804
Does it matter where the SQL Server Agent service is stopped/started/restarted on a cluster?
From where should the SQL Server Agent be controlled on a cluster?
Where should all SQL services be controlled from on a cluster?
0

Featured Post

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

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

Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
While rebooting windows server 2003 server , it's showing "active directory rebuilding indices please wait" at startup. It took a little while for this process to complete and once we logged on not all the services were started so another reboot is …
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

792 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