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