This is a multi-part message in MIME format.
------_=_NextPart_001_01C551E7.FCE64D12
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
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
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
>>> 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.
------_=_NextPart_001_01C551E7.FCE64D12
Content-Type: text/html;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Dus-ascii">
<TITLE>Message</TITLE>
<META content=3D"MSHTML 6.00.2800.1106" name=3DGENERATOR></HEAD>
<BODY>
<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_01C551E7.FCE64D12--
|
