Author: "Bobby Williams" <bobbyrjw AT comcast DOT net>
Date: Fri, 12 Oct 2007 14:40:43 -0400
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 backup
Author: "Johnson, Eric" <Eric.Johnson AT mtsallstream DOT com>
Date: Fri, 12 Oct 2007 17:39:37 -0400
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
Author: "rcarlisle" <rcarlisle AT serverwarecorp DOT com>
Date: Fri, 12 Oct 2007 18:08:07 -0400
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
Author: "Curtis Preston" <cpreston AT glasshouse DOT com>
Date: Fri, 12 Oct 2007 19:49:44 -0400
Right, but he said every dataFILE has to be its own backup job. That’s the part that doesn’t seem right. Or is it that when he backs up the tran log, each log is its own file? -- W. Curti
Author: "WEAVER, Simon (external)" <simon.weaver AT astrium.eads DOT net>
Date: Tue, 16 Oct 2007 08:27:18 +0100
Thats what I see. If I have 10 DB's on a Server, the NetBackup does 10 jobs, each for the .mdf file Regards Simon Weaver3rd Line Technical SupportWindows Domain Administrator EADS Astrium Limited, B2