What would happen to the jobs which are running,while failover occ

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Siva Prasad [SIVA] - 26 Mar 2005 19:49 GMT

My question is :
What would happen to the jobs which are running,while failover occurs?

I have a Active \ Passive SQL Server 2000 EE SP3a with Hotfix MS03-031 on
Windows 2003 Enterprise Edition.

When I testesd the Fail over from the Primary node (Node1) to Secondary Node
(Node2) there was a backup job running.

The backup job created using using 'database Maintenance plan which backups
all the user database. There are 10 databases to backup.

The thing is that when the database1 being backed up the "FAIL OVER" happend
and SQL Server failed over to Node2.

When I checked on the 'Job History' there was no entry at all for this job.

But the database backup except to the database2 (i,e during the time fail
over happened) all the databases were backed up.

The strange thing is there was no entry on 'Backup job history' at all for
the job ran.
There are entries in NT event viewer log.

Can anyone explain on How SQL Server would handle the Jobs which are running
while the fail over is happening?

Reply to this Message

Mike Epprecht \(SQL MVP\) - 26 Mar 2005 19:54 GMT

Hi

A job that is running will be aborted and not be re-scheduled to run
immediately again. It will run at the next scheduled time.

A Maintenance plan does submit backups to be run in parallel, so you were
just lucky that 9/10 had completed already.

Regards
--------------------------------
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland

IM: mike@epprecht.net

MVP Program: http://www.microsoft.com/mvp

Blog: http://www.msmvps.com/epprecht/

> My question is :
> What would happen to the jobs which are running,while failover occurs?
[quoted text clipped - 22 lines]
> Can anyone explain on How SQL Server would handle the Jobs which are running
> while the fail over is happening?

Reply to this Message

S Siva Prasad [SIVA] - 28 Mar 2005 06:27 GMT

Hi Mike,

Thanks for the reply.

But I differ with the reply you have provided.

Because, the when I tested the Backup job running on Primary Node continue
it's
executing on the Node-2 once SQL Server resources failed over.

The thing is that the database which being backed up as part of the job
only aborted which occurs when the fail over occured. All other databases as
part
of the job were backed up. That does not affected at all.

So, Please clarify what would be the usual SQL Server behaviour on
situations where SQL Server job running when the fail over occurs.

"Mike Epprecht (SQL MVP)" wrote:

> Hi
>
[quoted text clipped - 46 lines]
> running
> > while the fail over is happening?

Reply to this Message

S Siva Prasad [SIVA] - 28 Mar 2005 06:45 GMT

Hi Mike,

Thanks for the reply.

But I differ with the reply provided. Because when I tested a Backjob which
was running during the failover form the Primary node to Node -2 backed up
all the
database . Only the database which was being backup during actual failover
occured was aborted.

However there was no entry on Sysjobhistory. But these events recorded
on Event viewer and on each database in the "Last Backup Date" filed.

Hence my question is "What would be the usual behaviour of the SQL Server
to the Jobs when the SQL Server fail overs?"

"Mike Epprecht (SQL MVP)" wrote:

> Hi
>
[quoted text clipped - 46 lines]
> running
> > while the fail over is happening?

Reply to this Message