Rusty
Yeah I see that, but was seeking advice outside of this in
case someone on here had a much better way of getting the batch file to help
improve the throughput in terms of the number of jobs.
Back to the drawing board then.....
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.
Rusty
Major, MCSE, BCFP, VCS ▪ Sr. Storage Engineer ▪ SunGard Availability
Services ▪ 757 N. Eldridge Suite 200, Houston TX 77079 ▪ 281-584-4693
Keeping People and Information Connected® ▪
http://availability.sungard.com/ P Think before you print
CONFIDENTIALITY: This e-mail
(including any attachments) may contain confidential, proprietary and privileged
information, and unauthorized disclosure or use is prohibited. If you
received this e-mail in error, please notify the sender and delete this e-mail
from your system.
"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>
|
cc
|
|
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
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
|