Go Back   TechArena Community > Technical Support > Computer Help > Windows Server > Windows Server Help
Become a Member!
Forgot your username/password?
Tags Active Topics RSS Search Mark Forums Read

Sponsored Links



Is there a Cluster command line I can run which will stop my "SQL Agent Service"?

Windows Server Help


Reply
 
Thread Tools Search this Thread
  #1  
Old 29-03-2008
Spin
 
Posts: n/a
Is there a Cluster command line I can run which will stop my "SQL Agent Service"?

Gurus,

Running SQL Server 2005 SP2 on a Windows Server 2003 Cluster. Is there a
Cluster command line I can run which will stop my "SQL Agent Service"?

--
Spin



Reply With Quote
  #2  
Old 30-03-2008
John Bell
 
Posts: n/a
Re: Is there a Cluster command line I can run which will stop my "SQL Agent Service"?

Hi

How about NET STOP?

John

"Spin" <Spin@invalid.com> wrote in message
news:656t5iF2eq3dbU1@mid.individual.net...
> Gurus,
>
> Running SQL Server 2005 SP2 on a Windows Server 2003 Cluster. Is there a
> Cluster command line I can run which will stop my "SQL Agent Service"?
>
> --
> Spin
>



Reply With Quote
  #3  
Old 30-03-2008
Spin
 
Posts: n/a
Re: Is there a Cluster command line I can run which will stop my "SQL Agent Service"?

"John Bell" <jbellnewsposts@hotmail.com> wrote in message
news:e2yjJedkIHA.5368@TK2MSFTNGP04.phx.gbl...
> Hi
>
> How about NET STOP?


No can do John. NET STOP stops the service outside of the Cluster
environment. What will happen is the Windows Cluster service will detect
the service down then automatically restart it! What I need is a Cluster
service command line tool which gracefully stops the service per "knowledge"
if you will, of the Cluster service.

Reply With Quote
  #4  
Old 30-03-2008
Linchi Shea
 
Posts: n/a
RE: Is there a Cluster command line I can run which will stop my "SQL

For the default instance:

cluster.exe /cluster:<cluster name> resource "SQL Server Agent" /offline

For a named instance (assuming that the instance name is SQL2):

cluster.exe /cluster:<cluster name> resource "SQL Server Agent (SQL2)"
/offline

Linchi

"Spin" wrote:

> Gurus,
>
> Running SQL Server 2005 SP2 on a Windows Server 2003 Cluster. Is there a
> Cluster command line I can run which will stop my "SQL Agent Service"?
>
> --
> Spin
>
>
>

Reply With Quote
  #5  
Old 30-03-2008
Spin
 
Posts: n/a
Re: Is there a Cluster command line I can run which will stop my "SQL

Thanks! I'll shout back on Monday if this works...

"Linchi Shea" <LinchiShea@discussions.microsoft.com> wrote in message
news:C9EF5727-A88B-4261-B445-266B2C45990C@microsoft.com...
> For the default instance:
>
> cluster.exe /cluster:<cluster name> resource "SQL Server Agent" /offline
>
> For a named instance (assuming that the instance name is SQL2):
>
> cluster.exe /cluster:<cluster name> resource "SQL Server Agent (SQL2)"
> /offline
>
> Linchi
>
> "Spin" wrote:
>
>> Gurus,
>>
>> Running SQL Server 2005 SP2 on a Windows Server 2003 Cluster. Is there a
>> Cluster command line I can run which will stop my "SQL Agent Service"?
>>
>> --
>> Spin
>>
>>
>>


Reply With Quote
  #6  
Old 31-03-2008
Spin
 
Posts: n/a
Re: Is there a Cluster command line I can run which will stop my "SQL

"Linchi Shea" <LinchiShea@discussions.microsoft.com> wrote in message
news:C9EF5727-A88B-4261-B445-266B2C45990C@microsoft.com...
> For the default instance:
>
> cluster.exe /cluster:<cluster name> resource "SQL Server Agent" /offline
>
> For a named instance (assuming that the instance name is SQL2):
>
> cluster.exe /cluster:<cluster name> resource "SQL Server Agent (SQL2)"
> /offline
>
> Linchi


Worked!!!!! You are a Gentleman and a Scholar!

--
Spin


Reply With Quote
Reply

  TechArena Community > Technical Support > Computer Help > Windows Server > Windows Server Help
Tags: , , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "Is there a Cluster command line I can run which will stop my "SQL Agent Service"?"
Thread Thread Starter Forum Replies Last Post
NET START STOP Service Command Line Dr. Network Vista Help 4 30-03-2012 06:20 PM
Is " CLUE" Command Line User Environment important aspect of linux Loyalpalm Operating Systems 5 11-11-2010 11:10 AM
Splinter Cell Conviction "Missing command line parameter - prodid" GK knowledge Video Games 8 16-06-2010 05:53 PM
move cluster resource using the command line cluster.exe faf1967 Windows Server Help 7 06-04-2010 01:58 AM
SMTP command "xexch50" with "504 Need to authenticate first ". The full command sent was "XEXCH50 1020 2 ". ecscomp Small Business Server 2 07-12-2006 05:56 PM


All times are GMT +5.5. The time now is 02:20 PM.