As a Sybase DBA who deals with a very similar type of backup setup, I'd let
it do the individual backups rather than letting them go to a filesystem
and backing them up bulk.  I find doing logical restores especially much
easier if my databases are talking right to NetBackup (via the agent)
rather than adding in the intermediate filesystem step (where the DB server
can't access the backup data directly).

-- M




                                                                           
             "Bobby Williams"                                              
             <bobbyrjw@comcast                                             
             .net>                                                      To 
             Sent by:                  <veritas-bu AT mailman.eng.auburn DOT 
edu> 
             veritas-bu-bounce                                          cc 
             s AT mailman.eng DOT aub                                           
  
             urn.edu                                               Subject 
                                       [Veritas-bu]  (Conclusion) Are my   
                                       SQL DBA's lying to me?              
             10/13/2007 07:24                                              
             AM                                                            
                                                                           
                                                                           
             Please respond to                                             
             bobbyrjw@comcast.                                             
                    net                                                    
                                                                           
                                                                           




I will take the Audience answer that each dbf of the instance comes as a
separate backup job.

I think that the best answer is convert to a disk based backup and not use
the SQL agent.

Thanks for the input.

(It is nice to be able to ask this group for answers and opinions about
issues that we don't see a lot of)






Bobby Williams
2205 Peterson Drive
Chattanooga, Tennessee  37421
423-296-8200




From: rcarlisle [mailto:rcarlisle AT serverwarecorp DOT com]
Sent: Friday, October 12, 2007 6:08 PM
To: 'Johnson, Eric'; bobbyrjw AT comcast DOT net;
veritas-bu AT mailman.eng.auburn DOT edu
Subject: RE: [Veritas-bu] Are my SQL DBA's lying to me?

That's always the way I have seen it as well.  If you have a server with
tons of small databases, you sometimes get better performance is you just
do a data dump to a file and back up the file systems.



Reneé Carlisle
ServerWare Corporation
  From: veritas-bu-bounces AT mailman.eng.auburn DOT edu
[mailto:veritas-bu-bounces AT mailman.eng.auburn DOT edu] On Behalf Of Johnson,
Eric
Sent: Friday, October 12, 2007 5:40 PM
To: bobbyrjw AT comcast DOT net; veritas-bu AT mailman.eng.auburn DOT edu
Subject: Re: [Veritas-bu] Are my SQL DBA's lying to me?

Hi Bobby,

I believe they are telling you the truth. I’ve set up the MS SQL agent as
well, and every database comes through as it’s own backup job. I’m not
aware of any way to alter this behaviour, but I haven’t really looked into
it.

Eric


From: Bobby Williams [mailto:bobbyrjw AT comcast DOT net]
Sent: Friday, October 12, 2007 1:41 PM
To: veritas-bu AT mailman.eng.auburn DOT edu
Subject: [Veritas-bu] Are my SQL DBA's lying to me?



NetBackup 5.0MP6 using MS SQL agent.


DBA's are saying that each database file in the DB instance has to come to
the master/media server as a separate backup job.


I get hundreds of little bitty backups every time the logs need backed up.


Is this how other folks see the SQL agent implemented?



Bobby Williams
2205 Peterson Drive
Chattanooga, Tennessee  37421
423-296-8200 _______________________________________________
Veritas-bu maillist  -  Veritas-bu AT mailman.eng.auburn DOT edu
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu



IMPORTANT NOTICE:  This e-mail and any attachments may contain confidential or 
sensitive information which is, or may be, legally privileged or otherwise 
protected by law from further disclosure.  It is intended only for the 
addressee.  If you received this in error or from someone who was not 
authorized to send it to you, please do not distribute, copy or use it or any 
attachments.  Please notify the sender immediately by reply e-mail and delete 
this from your system. Thank you for your cooperation.


_______________________________________________
Veritas-bu maillist  -  Veritas-bu AT mailman.eng.auburn DOT edu
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu