We use the GUI Agent. We have SQL DBA's but I prefer online backups.
Tough, reliable, proven.

And to get the SQL DBA to fully understand how the process works, they
need to be involved and make them aware.

Saves dumping to disk as alot of our DB's are large. 

-----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 Martin,
Jonathan
Sent: Wednesday, November 10, 2010 4:24 PM
To: VERITAS-BU AT mailman.eng.auburn DOT edu
Subject: Re: [Veritas-bu] Is Netbackup SQL Server Agent requiredtouse
Netbackup to b

We use the MS-SQL Client here. We don't really have dedicated SQL DBAs,
we have windows admins with sql training and Oracle DBAs who would
rather manage Oracle. The text files offer simple configuration, and
restores are a breeze with the GUI. I guess for the limited amount of
MS-SQL we do here it fits the bill. As everyone else says, if we had a
dedicated SQL DBA I'm sure he/she would rather do their own thing.

-Jonathan

-----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: Wednesday, November 10, 2010 11:16 AM
To: VERITAS-BU AT MAILMAN.ENG.AUBURN DOT EDU
Subject: Re: [Veritas-bu] Is Netbackup SQL Server Agent required touse
Netbackup to b

We don't use it either.

SQL admins setup the backups to go to disk - all are to occur at the
same time on all the servers Then I have a policy to backup the SQL
servers that kicks off at 2 am.
This gets the server Plus the backups to disk that occurred earlier in
the night.

Now the SQL admins get to be in charge of backups AND restores (meaning
I don't have to be involved) unless they need a copy older then what
they have on disk.
As they keep more the one copy on disk.  I think I have only done a
restore once for them.




-----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
tsimerson
Sent: Wednesday, November 10, 2010 6:24 AM
To: VERITAS-BU AT MAILMAN.ENG.AUBURN DOT EDU
Subject: [Veritas-bu] Is Netbackup SQL Server Agent required to use
Netbackup to b

Kind of depends on your DBA's  [Wink] At a previous position, all of the
DBA's (Oracle, SQL and Informix) hated the idea of anything
communicating with their database that they had no control over (that
and they were cheap).

We worked with the SQL DBA to make use of user directed backups.  He
basically wrote a script to dump the data out of the SQL database and
then call bpbackup with the appropriate arguments to get the data from
local disk to tape.  Yes, there are lots of admin headaches with this
but it worked well enough for our purposes.  He would only complain
about twice a month about tape drive contention and such.

Let me know if you would like more details on how to setup the policy
and what command line arguments we used.

Tom Simerson
Sr. Systems Engineer
Sigma Solutions, Inc.

+----------------------------------------------------------------------
|This was sent by tom AT tjsimerson DOT org via Backup Central.
|Forward SPAM to abuse AT backupcentral DOT com.
+----------------------------------------------------------------------


_______________________________________________
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
_______________________________________________
Veritas-bu maillist  -  Veritas-bu AT mailman.eng.auburn DOT edu
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu

This email (including any attachments) may contain confidential
and/or privileged information or information otherwise protected
from disclosure. If you are not the intended recipient, please
notify the sender immediately, do not copy this message or any
attachments and do not use it for any purpose or disclose its
content to any person, but delete this message and any attachments
from your system. Astrium disclaims any and all liability if this
email transmission was virus corrupted, altered or falsified.
-o-
Astrium Limited, Registered in England and Wales No. 2449259
Registered Office:
Gunnels Wood Road, Stevenage, Hertfordshire, SG1 2AS, England
_______________________________________________
Veritas-bu maillist  -  Veritas-bu AT mailman.eng.auburn DOT edu
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu