While we do a mix of both, I personally
like the "backup to a file on disk then backup that file" method.
If you've got the space to keep a file or three on disk, I find this works
best as I usually don't have problems with having to support the agent
and dealing with the finger pointing between backup admins and database
admins. It's also quicker to recover from the flat file since it's already
on the system and just needs a DBA to recover it.
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.
Jonathan Dyck <jdyck AT bank-banque-canada DOT ca>
Sent by: <veritas-bu-bounces AT mailman.eng.auburn DOT edu>
10/23/2009 01:43 PM
|
To
| <judy_hinchcliffe AT administaff DOT com>,
<wilcox AT ge DOT com>, <don_peterson AT symantec DOT com>, <veritas-bu AT mailman.eng.auburn DOT edu>
|
cc
|
|
Subject
| Re: [Veritas-bu] Sharing a library |
|
That's how we do our SQL backups
as well.
-----Original Message-----
From: veritas-bu-bounces AT mailman.eng.auburn DOT edu [mailto:veritas-bu-bounces AT mailman.eng.auburn DOT edu]
On Behalf Of judy_hinchcliffe AT administaff DOT com
Sent: October 23, 2009 2:26 PM
To: wilcox AT ge DOT com; don_peterson AT symantec DOT com; veritas-bu AT mailman.eng.auburn DOT edu
Subject: Re: [Veritas-bu] Sharing a library
Good question…. As we do it the
same as you.
We also have other high profile
databases and we do (hot?) backups to disk (don’t take the database down)
and then backup that backup file to tape.
From: veritas-bu-bounces AT mailman.eng.auburn DOT edu
[mailto:veritas-bu-bounces AT mailman.eng.auburn DOT edu] On Behalf Of Wilcox,
Donald A (GE, Research)
Sent: Friday, October 23, 2009 1:23 PM
To: Don Peterson; veritas-bu AT mailman.eng.auburn DOT edu
Subject: Re: [Veritas-bu] Sharing a library
All,
I am currently looking
for info on backing up MS SQL boxes and wondered if the agent actually
does any type of snapshotting or are there scripts that have to pause the
database and then the backup begins? We currently have local scripts
in place that put the database in a mainteneance mode and copies data to
a data directory. Then the script starts up the database and our
Netbackup server comes in and does a regular backup of the box, which includes
the data directory. Why would I spend money for an agent when we
get backups with this method?
Donald Wilcox
1 Research Circle (KWC124B)
Niskayuna, New York 12309
Email: wilcox AT ge DOT com
Office: 518 387-6856
From: veritas-bu-bounces AT mailman.eng.auburn DOT edu
[mailto:veritas-bu-bounces AT mailman.eng.auburn DOT edu] On Behalf Of Don
Peterson
Sent: Friday, October 23, 2009 9:54 AM
To: veritas-bu AT mailman.eng.auburn DOT edu
Subject: [Veritas-bu] Sharing a library
Harry,
The way to prevent NBU from inventorying
all media is to use Inventory Filtering. This was covered at the end of
the STK ACS appendix in the NBU 6.0 Media Manager Sys Admin Guide, and
this information was apparently rolled into Volume 1 of the NBU Sys Admin
Guide in NBU 6.5, but I can’t find it. So, depending on whether you are
running Windows or Unix, take a look at the end of that Appendix in the
appropriate 6.0 Media Manager Sys Admin Guide.
Here is a link to the Windows guide:
ftp://exftpp.symantec.com/pub/support/products/NetBackup_Enterprise_Server/279268.pdf
and a link to the UNIX guide:
ftp://exftpp.symantec.com/pub/support/products/NetBackup_Enterprise_Server/279267.pdf
Don Peterson
Principal Product Manager, NetBackup
Information Management Group
Symantec Corporation
www.symantec.com
Email:
don_peterson AT symantec DOT com
====================================================================================
La version française suit le texte anglais.
------------------------------------------------------------------------------------
This email may contain privileged and/or confidential information, and
the Bank of
Canada does not waive any related rights. Any distribution, use, or copying
of this
email or the information it contains by other than the intended recipient
is
unauthorized. If you received this email in error please delete it immediately
from
your system and notify the sender promptly by email that you have done
so.
------------------------------------------------------------------------------------
Le présent courriel peut contenir de l'information privilégiée ou confidentielle.
La Banque du Canada ne renonce pas aux droits qui s'y rapportent. Toute
diffusion,
utilisation ou copie de ce courriel ou des renseignements qu'il contient
par une
personne autre que le ou les destinataires désignés est interdite. Si vous
recevez
ce courriel par erreur, veuillez le supprimer immédiatement et envoyer
sans délai à
l'expéditeur un message électronique pour l'aviser que vous avez éliminé
de votre
ordinateur toute copie du courriel reçu.
_______________________________________________
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
|