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
_______________________________________________
Veritas-bu maillist - Veritas-bu AT mailman.eng.auburn DOT edu
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu
|