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 :(
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/ 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 10:59 AM
|
To
| <Rusty.Major AT sungard DOT com>
|
cc
| bob944 AT attglobal DOT net,
veritas-bu AT mailman.eng.auburn DOT edu,
veritas-bu-bounces AT mailman.eng.auburn DOT 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.Major AT sungard DOT com
[mailto:Rusty.Major AT sungard DOT com] Sent: Monday, March 23, 2009 3:38
PM To: WEAVER, Simon (external) Cc: bob944 AT attglobal DOT net;
veritas-bu AT mailman.eng.auburn DOT edu;
veritas-bu-bounces AT mailman.eng.auburn DOT 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/ 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
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
|