Greg and Jerry:

I have not been following this thread too closely so forgive me for any
ingnorance...

I agree with Jerry. However, it depends on how the SQL backup is done.
We had an implementation of BMC's SQL Backtrack with NBU 3.x and it was
rough waters. If you doing this via LAN-based backups I would caution
you away from this. The failure rate was unacceptable for us. We asked
our dbas to do their Oracle backups to a specific file system (disk -
more expensive indeed!) and pick it up there with a separate policy.

I have been out of the SQL backup schema for a bit so if I am out in
left field I am eager to get educated.

Good luck,

Bill

--------------------------------------------------------
     Bill Jorgensen
     CSG Systems, Inc.
     (w) 303.200.3282
     (p) 303.947.9733
--------------------------------------------------------
     UNIX... Spoken with hushed and
     reverent tones.
--------------------------------------------------------

-----Original Message-----
From: veritas-bu-admin AT mailman.eng.auburn DOT edu
[mailto:veritas-bu-admin AT mailman.eng.auburn DOT edu] On Behalf Of Jerry
Sent: Wednesday, May 11, 2005 2:39 PM
To: Hindle, Greg; veritas-bu AT mailman.eng.auburn DOT edu
Subject: Re: [Veritas-bu] SQL agent any pros and cons?

Here's my "paper" (quick version):

Pros:
* Saves disk space.  Backups up right to tape.
* Faster. One step, write to tape.
* Calls the same APIs the SQL backup does when it goes
to file.

Cons:
* Cost Money
* Funky interface/setup
   * jobs show up twice for every one job.  There is a
job that kicks off another job that communicates back
to the server (dbbackex I believe is the binary).

--- "Hindle, Greg" <Greg.Hindle AT constellation DOT com>
wrote:
> My boss wants me to write up a paper with the pro's
> and cons of using
> the Netbackup SQL agent. Has anyone out there done
> this? Any help or
> suggestions would be very helpful. We currently have
> SQL dump to a flat
> file and we then back this up to tape but he wants
> to know if this is
> better or should we be using the SQL backup agent
> instead....
>  
>  
> Greg
>  
> 
> 
> 
> >>> The information contained in this e-mail
> transmission is privileged and/or confidential
> intended solely for the exclusive use of the
> individual addressee. If you are not the intended
> addressee you are hereby notified that any
> retention, disclosure or other use is strictly
> prohibited. If you have received this notification
> in error, please immediately contact the sender and
> delete the material.
> 
> 


        
                
__________________________________ 
Do you Yahoo!? 
Yahoo! Mail - You care about security. So do we. 
http://promotions.yahoo.com/new_mail
_______________________________________________
Veritas-bu maillist  -  Veritas-bu AT mailman.eng.auburn DOT edu
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu