SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Does SQL services gets restarted during failover
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

ciran_patil@yahoo.com
Starting Member

17 Posts

Posted - 10/28/2008 :  17:46:10  Show Profile  Reply with Quote
Hi All,

I am just wondering about SQL services behaviour during Cluster failover. Does these SQL services gets restarted during failover ?

If SQL services are getting restart then whats the use of having SQL cluster?

Please share your views and experiance.

Thanks

Kiran

Thanks

Kiran Patil

sodeep
Flowing Fount of Yak Knowledge

USA
7174 Posts

Posted - 10/28/2008 :  17:54:54  Show Profile  Reply with Quote
If you are having 2 node active/passive cluster, you failover node will connect to SQL server and own resources during failover .
Go to Top of Page

ciran_patil@yahoo.com
Starting Member

17 Posts

Posted - 10/28/2008 :  17:59:44  Show Profile  Reply with Quote
Right, considering I have 2 node active/passive cluster. Lets say If I have got 5 SQL Jobs running on active node and I failover from active to passive node then will these 5 running jobs be stopped or still running even after failover?

Thanks Kiran

Thanks

Kiran Patil
Go to Top of Page

sodeep
Flowing Fount of Yak Knowledge

USA
7174 Posts

Posted - 10/28/2008 :  18:07:02  Show Profile  Reply with Quote
http://technet.microsoft.com/en-us/magazine/cc137997.aspx
Go to Top of Page

ciran_patil@yahoo.com
Starting Member

17 Posts

Posted - 10/29/2008 :  10:43:14  Show Profile  Reply with Quote
Thanks Sodeep.
I read the link, still could not undesrstand, if the running jobs will stop or keep running when we do failover. Could you please answer this? Thanks

Thanks

Kiran Patil
Go to Top of Page

Haywood
Posting Yak Master

USA
221 Posts

Posted - 10/29/2008 :  13:23:32  Show Profile  Reply with Quote
Running jobs will stop and will need to be restarted manually after the failover.


Failover stops the SQL service (and Agent) to move it to one of the other nodes in the cluster. Once moved to another node, it starts back up (SQL Service & Agent).



Your friendly High-Tech Janitor:

http://grayburn.wordpress.com
Go to Top of Page

ciran_patil@yahoo.com
Starting Member

17 Posts

Posted - 10/29/2008 :  15:35:07  Show Profile  Reply with Quote
Right, Thank you.

Is there any way to avoid this. I mean is there an option to keep these jobs running or restarting them auomatically after failover from the steps they were stopped during failover?

Thanks

Kiran Patil
Go to Top of Page

Haywood
Posting Yak Master

USA
221 Posts

Posted - 10/29/2008 :  16:17:38  Show Profile  Reply with Quote
No.

The SQL Server is shutdown and then restarted....


Your friendly High-Tech Janitor:

http://grayburn.wordpress.com
Go to Top of Page

ciran_patil@yahoo.com
Starting Member

17 Posts

Posted - 10/29/2008 :  17:55:44  Show Profile  Reply with Quote
Thank You

Thanks

Kiran Patil
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.11 seconds. Powered By: Snitz Forums 2000