June 30, 2009 at 10:30 am
Hello,
We are using Active\Passive clustered sql server 2005. I'm just cheking some scenarios:
1. The full backup is scheduled and its running. While the job is running I have manually moved the group to paasive node? then what should happen
for me, the job has been stopped with below errors in job view history
Message
Executed as user: abc\mssqlsrv. The step was cancelled (stopped) as the result of a stop job request
Message
The job was stopped prior to completion by Shutdown Sequence 0. The Job was invoked by User abc\admin. The last step to run was step 1 (Full_Backup).
Is this normal behaviour? or the job should resume after moving to passive node?
thanks
June 30, 2009 at 10:49 am
Failovers are treated as restarts so all jobs will stop.
You can create a custom script to start your jobs on the passive node after the failover.
Customize this script to fire specific jobs
http://www.mssqltips.com/tip.asp?tip=1663
June 30, 2009 at 2:30 pm
This is one of the reasons why clustering for SQL Server is a useful feature, but not as useful as one would expect, at least one who has worked with Oracle RAC. This anyway is due to windows more than SQL Server itself.
I look forward for a better solution in the future.
-- Gianluca Sartori
June 30, 2009 at 3:28 pm
I also heard from our Oracle DBA's that Oracle RAC is Amazing....
June 30, 2009 at 4:02 pm
Gianluca Sartori (6/30/2009)
This is one of the reasons why clustering for SQL Server is a useful feature, but not as useful as one would expect, at least one who has worked with Oracle RAC. This anyway is due to windows more than SQL Server itself.I look forward for a better solution in the future.
Oracle RAC is no different in this regard. Any processes running on the node that crashed will be terminated just the same and will have to be restarted on the other node.
There is no way for the other node to know what was being processed and the state those processes were in when a node crashes. It is not possible...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
June 30, 2009 at 6:40 pm
i thought Oracle RAC was you ran the same instance across numerous nodes? if a node crashes then you remove, reimage and replace.
with SQL one way to get around the cluster problem of services restarting is VMWare or Hyper-V. When a VM fails over to another node it's still running and the OS won't notice anything. problem is that all your I/O will go through the hypervisor and i've read that it can create a bottleneck
June 30, 2009 at 9:25 pm
rambilla4 (6/30/2009)
I also heard from our Oracle DBA's that Oracle RAC is Amazing....
It's amazing if it's running on Linux or Unix. Oracle RAC on windows = Migraines.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply