Understand that Rusty, but as mentioned, they dont know NetBackup, and they (as
SQL DBA's) really should know better!
Its not for the want of trying.
So alot of my research, testing and validating has been on my own experience
and in fairness (as mentioned) restores for the SQL DBA's has been successful.
But I have asked many, many times ...... but unless they are doing a Disk based
SQL Job Backup, they dont want to know :(
________________________________
From: rusty.ma...@sungard.com [mailto:rusty.ma...@sungard.com]
Sent: Monday, March 23, 2009 4:24 PM
To: WEAVER, Simon (external)
Cc: veritas-bu@mailman.eng.auburn.edu; veritas-bu-boun...@mailman.eng.auburn.edu
Subject: Re: [Veritas-bu] NetBackup 5.1 and SQL Online Agent - Some
I understood your original question, I was just strongly suggesting, since you
mentioned it, that you need to wrangle in those admins and bring them over to
your side.
If they own the SQL databases, then why are they not involved with the process
of recovering a database?
Sounds like things have worked before and you have it down, but with them out
of the loop, the potential for problems is huge.
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/
<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.wea...@astrium.eads.net>
Sent by: veritas-bu-boun...@mailman.eng.auburn.edu
03/23/2009 10:59 AM
To
<rusty.ma...@sungard.com>
cc
bob...@attglobal.net, veritas-bu@mailman.eng.auburn.edu,
veritas-bu-boun...@mailman.eng.auburn.edu
Subject
Re: [Veritas-bu] NetBackup 5.1 and SQL Online Agent - Some
Rusty
I dont think the integrity of the SQL Backups are in question. We do ALOT of
restores, not just real life but in practice as well.
But the SQL Admin's have no experience of NetBackup, but they are aware of how
the backups work and what is involved.
The process is also entirely documented for backups and restore purposes.
All I wanted was some advice or options on improving the performance which may
be outside the scope of the SQLAdmin book and real world experiences of anyone
doing an online backup :)
But as it turns out, I rescheduled some jobs, and they actually completed alot
quicker. So although I will try this in a test environment, it is something I
am going to look into.
Apprecaite the options
Simon
________________________________
From: rusty.ma...@sungard.com [mailto:rusty.ma...@sungard.com]
Sent: Monday, March 23, 2009 3:38 PM
To: WEAVER, Simon (external)
Cc: bob...@attglobal.net; veritas-bu@mailman.eng.auburn.edu;
veritas-bu-boun...@mailman.eng.auburn.edu
Subject: Re: [Veritas-bu] NetBackup 5.1 and SQL Online Agent - Some
Simon, the first thing you should do is get your SQL group on board with
backups. You're not a SQL guy, and they aren't a backup person, but together
you both need to work together to understand the process. Otherwise, the
validity of the backups are in question.
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/
<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.wea...@astrium.eads.net>
Sent by: veritas-bu-boun...@mailman.eng.auburn.edu
03/23/2009 02:22 AM
To
<bob...@attglobal.net>, <veritas-bu@mailman.eng.auburn.edu>
cc
Subject
Re: [Veritas-bu] NetBackup 5.1 and SQL Online Agent - Some
Bob
Hang on your causing some confusion now...
Just what do you mean by this:
>> You do realize, right, that the full/incr schedule doesn't actually
back anything up--it just tells the client to run the client >> script
specified in the selection list?
I do full SQL Online backups, and we have restored from these too. And
yes, the command is "pushed" to the client, as I can see that from the
event logs. The "Master" is simply the running machine, and as stated,
its like the "Main Client" Job kicks in and then the smaller "Scheduled
jobs" for each DB thereafter :-)
If its a case of tweaking the .bch file, then thats ok. Sadly, the SQL
people DONT know NetBackup and wont touch it, hence why I have been
configuring SQL all the time. Its not been a problem, but recently one
client has got bigger and bigger, and I was only seeking a possible way
forward to improving this.
The SQL Admin answer..... backup to disk offline. But thats not possible
when they have no more storage available.
Will try to go back to the book ...... cheers anyhow......
-----Original Message-----
From: bob944 [mailto:bob...@attglobal.net]
Sent: Sunday, March 22, 2009 4:11 PM
To: veritas-bu@mailman.eng.auburn.edu
Cc: WEAVER, Simon (external)
Subject: RE: [Veritas-bu] NetBackup 5.1 and SQL Online Agent - Some
> 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
You do realize, right, that the full/incr schedule doesn't actually back
anything up--it just tells the client to run the client script specified
in the selection list?
And that the file should be SQL Server backup commands that are executed
on the client (and can be initiated just as easily from the client by
any other means that suit your needs)?
And that the client initiates a user backup request to the master which
validates the client against allowed/applicable user backup
schedules--_that_ is what initiates the D_A_B job(s)?
So the fix you seek is at the client end. Break out a Microsoft SQL
Server book and an editor, the Veritas NetBackup for Microsoft SQL
Server Administraotr's Guide (or use the too-simple-to-screw-up
NetBackup client GUI) and change or add a script that does what you
want: stripes, multi-streaming, blocksize, shared buffers, ...
Assuming you set the client and policy job limits per the
Administrator's Guide, of course.
> Or is this behaviour I am seeing normal.
It's normal if the script uses the default installation values. A
backup or SQLServer admin who knows his stuff can make SQL Server
backups rock if the box is capable of it. As I see others have said,
open the admin guide.
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@mailman.eng.auburn.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@mailman.eng.auburn.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@mailman.eng.auburn.edu
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu
