Cheers David
Had a feeling this was the "default" behaviour, as I did set them up
using the Guide (SQL Admins dont care for NetBackup ya see).

Will have another look, but just wondered if there was any optional tips
or help outside the scope of the manual.

I did reschedule the backups to take part during a quieter moment and
that has saved some time, which is good.

But will re-look again in the manual and do some testing.

Simon 

-----Original Message-----
From: David McMullin [mailto:David.McMullin AT CBC-Companies DOT com] 
Sent: Friday, March 20, 2009 6:49 PM
To: WEAVER, Simon (external)
Cc: veritas-bu AT mailman.eng.auburn DOT edu
Subject: NetBackup 5.1 and SQL Online Agent - Some Advice and Assistance
please?

The behavior you describe is what you will see with the SQL and oracle
agents - A parent jobs starts and spawns child jobs. The number of these
child jobs and how many run at once - you can run them serially or
parallel - is controlled by variables in the script NetBackup calls.
I agree with Rusty - check the manual. We have the DBA administer these
scripts. All we do is call them.

One thing we HAVE found in 6.5.X is there is a bug in the windows client
that allows the parent to lock up sometimes.
We see this when running incremental backups - if you add a new database
it will lock up the parent job since there is no full backup to compare
to ...

BUG REPORT: MS SQL Backup Parent job has an Active Status but hangs
until it times out or is canceled. The dbbackex.exe process on the MS
SQL Client does not exit. 
Document ID: 315659
http://support.veritas.com/docs/315659


Summary of previous emails:

From: Rusty.Major AT sungard DOT com
Subject: Re: [Veritas-bu] NetBackup 5.1 and SQL Online Agent - Some
Advice and Assistance please ?
To: "WEAVER, Simon \(external\)" <simon.weaver AT astrium.eads DOT net>

I think you'll find the answer to your question in the SQL admin guide.

>>From my recollection, you can tune how many streams you want to run at
a time, and which DB's will be backed up by the job in your script file.

I think someone else may have a more specific answer, but I think you'll
find the guide has your answer.

"WEAVER, Simon \(external\)" <simon.weaver AT astrium.eads DOT net> 
Sent by: veritas-bu-bounces AT mailman.eng.auburn DOT edu
03/20/2009 05:13 AM

To<VERITAS-BU AT mailman.eng.auburn DOT edu>
Subject[Veritas-bu] NetBackup 5.1 and SQL Online Agent - Some Advice and
Assistance please ?

Good Morning 
I wonder if I can get some advice from some NBU SQL Experts here. 
Situation: Win2k3 SP2 Master and Mutliple SAN Media Servers. 
I have many VM Machines that are doing backups via the lan at this
stage. 
VMCB will be looked into later this year. 
Problem I am seeing: In particular, 2 clients have 500 SQL DB's on them
and the behaviour of NetBackup seems to be: 
1) A Schedule kicks off for SQL 
2) Another job kicks in for the Default Application Backup and it backs
up each single DB 
Is there a way I can group ALL the DB's or maybe 5, 10 or so in one hit?

Or is this behaviour I am seeing normal. It takes approx 5 hours for the
backups of SQL to complete, and throughput is around 22 - 28mb/second. 
Some of the DB's are very small (several hundred MB and a couple are of
several hundreg GB - Not good for LAN based I know, hence why I am
looking 
into a Consolidated Backup solution later).
Any advice is greatly appreciated. 
Regards 
Simon 

This email (including any attachments) may contain confidential
and/or privileged information or information otherwise protected
from disclosure. If you are not the intended recipient, please
notify the sender immediately, do not copy this message or any
attachments and do not use it for any purpose or disclose its
content to any person, but delete this message and any attachments
from your system. Astrium disclaims any and all liability if this
email transmission was virus corrupted, altered or falsified.
-o-
Astrium Limited, Registered in England and Wales No. 2449259
Registered Office:
Gunnels Wood Road, Stevenage, Hertfordshire, SG1 2AS, England


This email (including any attachments) may contain confidential
and/or privileged information or information otherwise protected
from disclosure. If you are not the intended recipient, please
notify the sender immediately, do not copy this message or any
attachments and do not use it for any purpose or disclose its
content to any person, but delete this message and any attachments
from your system. Astrium disclaims any and all liability if this
email transmission was virus corrupted, altered or falsified.
-o-
Astrium Limited, Registered in England and Wales No. 2449259
Registered Office:
Gunnels Wood Road, Stevenage, Hertfordshire, SG1 2AS, England
_______________________________________________
Veritas-bu maillist  -  Veritas-bu AT mailman.eng.auburn DOT edu
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu