Welcome to dbForumz.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Stop SQL Server service without failing it over.

  
   Database Forums (Home) -> Clustering RSS
Next:  Trying to set DefaultValue based on ServerFilter ..  
Author Message
mostro

External


Since: Mar 20, 2006
Posts: 2



(Msg. 1) Posted: Mon Mar 20, 2006 3:03 pm
Post subject: Stop SQL Server service without failing it over.
Archived from groups: microsoft>public>sqlserver>clustering (more info?)
I'm setting up SQL Mail with Outlook and need to restart the SQL
services (mssqlserver and sql agent) on the server to complete the
configuration. I would like to do this without causing a failover. Has
anyone sucessfully used the commands below to make this work?

System: Windows 2003, SQL Server 2000 SP3..

cluster [cluster name] RESOURCE [resource name] /option

EX.
cluster mycluster RESOURCE "SQL Server" /offline
cluster mycluster RESOURCE "SQL Server Agent" /offline

then

cluster mycluster RESOURCE "SQL Server" /online
cluster mycluster RESOURCE "SQL Server Agent" /online

Thanks in advance

 >> Stay informed about: Stop SQL Server service without failing it over. 
Back to top
Login to vote
mostro

External


Since: Mar 20, 2006
Posts: 2



(Msg. 2) Posted: Mon Mar 20, 2006 4:57 pm
Post subject: Re: Stop SQL Server service without failing it over. [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
Really? Huh... How does one send smtp based alerts/notifications?

 >> Stay informed about: Stop SQL Server service without failing it over. 
Back to top
Login to vote
Display posts from previous:   
   Database Forums (Home) -> Clustering All times are: Pacific Time (US & Canada) (change)
Page 1 of 1

 
 You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]