This is a multi-part message in MIME format.
------_=_NextPart_001_01C554A3.29093A35
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
OK. Thanks. So you have netbackup logging into SQL and backing the DB up
live? Or do you netbackup backup the flat file outside of SQL?
=20
=20
Greg Hindle
Constellation Energy
Data Management & Recovery
Front St. 410-291-5715
greg.hindle AT constellation DOT com
=20
=20
=20
_____ =20
From: Arif Budiman [mailto:ArifB AT xl.co DOT id]=20
Sent: Thursday, May 05, 2005 11:02 PM
To: Hindle, Greg; veritas-bu AT mailman.eng.auburn DOT edu
Subject: RE: [Veritas-bu] SQL agent backups
We did. For critical database that frequently change we set 3 kinds
backup : weekly full backup, daily differential, and hourly transaction
log backup. To perform these kinds of backup you just create a script
for each, from Netbackup for SQL GUI, then put the script file name in a
policy with MS-SQL-server type. To schedule hourly backup just set the
schedule frequency to be 1 hour and make sure the backup windows is
available whenever backup should run (we set 24 hours).
=20
Regards,
Arif Budiman
PT Excelcomindo Pratama
NOC - Data Center
Mobile : +62817737866
Office : +62215761881 ext 58221
It is easy to avoid criticism: Say nothing, do nothing, and be nothing.
If you are going to move mountains, you are going to have to accept a
little flack.
-----Original Message-----
From: veritas-bu-admin AT mailman.eng.auburn DOT edu
[mailto:veritas-bu-admin AT mailman.eng.auburn DOT edu] On Behalf Of Hindle,
Greg
Sent: 06 Mei 2005 2:07
To: veritas-bu AT mailman.eng.auburn DOT edu
Subject: [Veritas-bu] SQL agent backups
=09
=09
Is anyone using the Windows SQL agent to perform backups of the
DB? We are installing a few SQL servers that will have high critical
apps and will need to run hourly snapshots of the data in the DB and I
need to know if the SQL agent can handle hourly backups of the DB. And
how this is performed. How are others doing this? Our backup server is
Solaris 9 running netbackup 5.0 at the moment (we are upgrading soon to
5.1 or 6.0).
Any info would be helpful...
=20
Greg
=20
=09
=09
=09
>>> The information contained in this e-mail transmission is
privileged and/or confidential intended solely for the exclusive use of
the individual addressee. If you are not the intended addressee you are
hereby notified that any retention, disclosure or other use is strictly
prohibited. If you have received this notification in error, please
immediately contact the sender and delete the material.
=09
------_=_NextPart_001_01C554A3.29093A35
Content-Type: text/html;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>Message</TITLE>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Dus-ascii">
<META content=3D"MSHTML 6.00.2900.2627" name=3DGENERATOR></HEAD>
<BODY>
<DIV dir=3Dltr align=3Dleft><SPAN class=3D067592414-09052005><FONT =
face=3DArial=20
color=3D#0000ff size=3D2>OK. Thanks. So you have netbackup logging into =
SQL and=20
backing the DB up live? Or do you netbackup backup the flat file outside =
of=20
SQL?</FONT></SPAN></DIV>
<DIV> </DIV>
<DIV align=3Dleft><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV align=3Dleft><FONT face=3DArial size=3D2>Greg Hindle</FONT></DIV>
<DIV align=3Dleft><FONT face=3DArial size=3D2>Constellation =
Energy</FONT></DIV>
<DIV align=3Dleft><FONT face=3DArial size=3D2>Data Management &=20
Recovery</FONT></DIV>
<DIV align=3Dleft><FONT face=3DArial size=3D2>Front St. =
410-291-5715</FONT></DIV>
<DIV align=3Dleft><FONT face=3DArial size=3D2><A=20
href=3D"mailto:greg.hindle AT constellation DOT
com">[email protected]=
om</A></FONT></DIV>
<DIV align=3Dleft><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV align=3Dleft><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV> </DIV><BR>
<DIV class=3DOutlookMessageHeader lang=3Den-us dir=3Dltr align=3Dleft>
<HR tabIndex=3D-1>
<FONT face=3DTahoma size=3D2><B>From:</B> Arif Budiman =
[mailto:ArifB AT xl.co DOT id]=20
<BR><B>Sent:</B> Thursday, May 05, 2005 11:02 PM<BR><B>To:</B> Hindle, =
Greg;=20
veritas-bu AT mailman.eng.auburn DOT edu<BR><B>Subject:</B> RE: [Veritas-bu] =
SQL agent=20
backups<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV><FONT face=3DArial color=3D#0000ff size=3D2><SPAN =
class=3D356234802-06052005>We=20
did. For critical database that frequently change we set 3 kinds backup =
: weekly=20
full backup, daily differential, and hourly transaction log backup. To =
perform=20
these kinds of backup you just create a script for each, from Netbackup =
for SQL=20
GUI, then put the script file name in a policy with MS-SQL-server =
type. To=20
schedule hourly backup just set the schedule frequency to be 1 =
hour and=20
make sure the backup windows is available whenever backup should run (we =
set 24=20
hours).</SPAN></FONT></DIV>
<DIV><FONT face=3DArial color=3D#0000ff size=3D2></FONT> </DIV><!-- =
Converted from text/plain format -->
<P align=3Dleft><FONT size=3D1><FONT face=3DVerdana>Regards,<BR>Arif =
Budiman<BR><BR>PT=20
Excelcomindo Pratama<BR>NOC - Data Center<BR>Mobile :=20
+62817737866<BR>Office : +62215761881 ext =
58221</FONT><BR><BR><FONT=20
face=3DVerdana color=3D#008000><EM>It is easy to avoid criticism: Say =
nothing, do=20
nothing, and be nothing. </EM></FONT><FONT face=3DVerdana =
color=3D#008000><EM>If you=20
are going to move mountains, you are going to have to accept a little=20
flack.</EM></FONT></FONT><EM></P></EM>
<BLOCKQUOTE style=3D"MARGIN-RIGHT: 0px">
<DIV></DIV>
<DIV class=3DOutlookMessageHeader lang=3Den-us dir=3Dltr =
align=3Dleft><FONT=20
face=3DTahoma size=3D2>-----Original Message-----<BR><B>From:</B>=20
veritas-bu-admin AT mailman.eng.auburn DOT edu=20
[mailto:veritas-bu-admin AT mailman.eng.auburn DOT edu] <B>On Behalf Of =
</B>Hindle,=20
Greg<BR><B>Sent:</B> 06 Mei 2005 2:07<BR><B>To:</B>=20
veritas-bu AT mailman.eng.auburn DOT edu<BR><B>Subject:</B> [Veritas-bu] SQL =
agent=20
backups<BR><BR></FONT></DIV>
<DIV><SPAN class=3D312570119-05052005><FONT face=3DArial size=3D2>Is =
anyone using=20
the Windows SQL agent to perform backups of the DB? We are =
installing a=20
few SQL servers that will have high critical apps and will need =
to run=20
hourly snapshots of the data in the DB and I need to know if the SQL =
agent can=20
handle hourly backups of the DB. And how this is performed. How are =
others=20
doing this? Our backup server is Solaris 9 running netbackup 5.0 at =
the moment=20
(we are upgrading soon to 5.1 or 6.0).</FONT></SPAN></DIV>
<DIV><SPAN class=3D312570119-05052005><FONT face=3DArial size=3D2>Any =
info would be=20
helpful...</FONT></SPAN></DIV>
<DIV align=3Dleft><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV align=3Dleft><FONT face=3DArial size=3D2>Greg</FONT><FONT =
face=3DArial=20
size=3D2></FONT></DIV>
<DIV> </DIV><FONT size=3D2><BR><BR><BR>>>> The =
information=20
contained in this e-mail transmission is privileged and/or =
confidential=20
intended solely for the exclusive use of the individual addressee. If =
you are=20
not the intended addressee you are hereby notified that any retention, =
disclosure or other use is strictly prohibited. If you have received =
this=20
notification in error, please immediately contact the sender and =
delete the=20
material.<BR></BLOCKQUOTE></FONT></BODY></HTML>
------_=_NextPart_001_01C554A3.29093A35--
|
