Re: [Veritas-bu] NetBackup 5.1 and SQL Online Agent - Some Advice and Assistance please ?
2009-03-20 15:10:13
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
_______________________________________________
Veritas-bu maillist - Veritas-bu AT mailman.eng.auburn DOT edu
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu
|
|
|