Re: [Veritas-bu] NetBackup 5.1 and SQL Online Agent - Some Advice and Assistance please ?
2009-03-23 03:27:12
Thanks Bill. May just take you up on that to be sure what I
am doing is correct.
Warm Regards
Simon
Simon,
You can build a batch file that will group multiple databases into one
collection jobs.
Feel free to contact me off-list if you require detailed information.
Thanks, Bill
On Fri, Mar 20, 2009 at 9:01 AM, <Rusty.Major AT sungard DOT com>
wrote:
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.
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
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
|
|
|