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


_______________________________________________
Veritas-bu maillist  -  Veritas-bu AT mailman.eng.auburn DOT edu
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu