|
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
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/
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/23/2009 02:22 AM
|
|
To
| <bob944 AT attglobal DOT net>,
<veritas-bu AT mailman.eng.auburn DOT 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:bob944 AT attglobal DOT net]
Sent: Sunday, March 22, 2009 4:11 PM
To:
veritas-bu AT mailman.eng.auburn DOT 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 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
|
