Veritas-bu

Re: [Veritas-bu] Is Netbackup SQL Server Agent requiredtouse Netbackup to b

2010-11-12 11:04:21
Subject: Re: [Veritas-bu] Is Netbackup SQL Server Agent requiredtouse Netbackup to b
From: "Scheef Jr, Ed E." <CXScheef AT tecoenergy DOT com>
To: "WEAVER, Simon (external)" <simon.weaver AT astrium.eads DOT net>, "Martin, Jonathan" <JMARTI05 AT intersil DOT com>, "VERITAS-BU AT mailman.eng.auburn DOT edu" <VERITAS-BU AT mailman.eng.auburn DOT edu>
Date: Fri, 12 Nov 2010 11:04:07 -0500
>From what I'm reading,  I'm thinking the NBU SQL Agent will work fine while 
>interfacing with SAP SQL databases,
and at  the same time will allow us to maintain backup control  (and SAP server 
disk space) by using SAP-scheduled backups
going to NBU Disk Storage Groups, then to tape from there.

 All good info, thanks !!!

-----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 WEAVER, 
Simon (external)
Sent: Friday, November 12, 2010 3:45 AM
To: Martin, Jonathan; VERITAS-BU AT mailman.eng.auburn DOT edu
Subject: Re: [Veritas-bu] Is Netbackup SQL Server Agent requiredtouse Netbackup 
to b

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

NOTICE:  This email is intended only for the individual(s) to whom it is 
addressed and may contain confidential information. If you have received this 
email by mistake, please notify the sender immediately, delete this email from 
your system and do not copy or disclose it to anyone else. Although we take 
precautions to protect against viruses, we advise you to take your own 
precautions to protect against viruses as we accept no liability for any which 
remain.
_______________________________________________
Veritas-bu maillist  -  Veritas-bu AT mailman.eng.auburn DOT edu
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu

<Prev in Thread] Current Thread [Next in Thread>