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
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.
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
|