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