This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_001_01C217B2.B5B23D90
Content-Type: text/plain;
charset="iso-8859-1"
Brad,
I assume you are talking about the Transaction log in MS SQL. If not, then
I am mistaken. In NB 3.4 you could only schedule (or at least that's all
I could figure out) backups every 60 minutes. I am on 4.5 now but I haven't
checked the scheduling options that closely. Here is the script I use to
backup the Transaction log. It truncates the log as well.
OPERATION BACKUP
OBJECTTYPE TRXLOG
DATABASE "QAS"
MAXTRANSFERSIZE 4
BLOCKSIZE 6
ALTCLIENT VQASDB
DBMS MSSQL
TRACELEVEL MAX
DSN "SAPQAS2_SQL"
ENDOPER TRUE
Good luck!
Rick Morris
IGT - SAP Basis Administrator
775-448-7293
-----Original Message-----
From: Donaldson, Mark [mailto:Mark.Donaldson AT experianems DOT com]
Sent: Tuesday, June 18, 2002 14:00 PM
To: 'Hillebrand, Bradly W.'; veritas-bu AT mailman.eng.auburn DOT edu
Subject: RE: [Veritas-bu] MS SQL Scripts
I have my oracle archived logs just picked up by an hourly incremental
backup. Would this work for you?
-M
-----Original Message-----
From: Hillebrand, Bradly W. [mailto:bhillebrand AT fhlbi DOT com]
Sent: Tuesday, June 18, 2002 2:08 PM
To: veritas-bu AT mailman.eng.auburn DOT edu
Subject: [Veritas-bu] MS SQL Scripts
Does anyone have any Win2k scripts that will work for MS SQL server? What I
am wanting to do is grab the archive logs that get dumped every 20 minutes.
Thanks,
Brad Hillebrand
FHLBI
------_=_NextPart_001_01C217B2.B5B23D90
Content-Type: text/html;
charset="iso-8859-1"
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2716.2200" name=GENERATOR>
<STYLE>@page Section1 {size: 8.5in 11.0in; margin: 1.0in 1.25in 1.0in 1.25in; }
P.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman"
}
LI.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman"
}
DIV.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman"
}
A:link {
COLOR: blue; TEXT-DECORATION: underline
}
SPAN.MsoHyperlink {
COLOR: blue; TEXT-DECORATION: underline
}
A:visited {
COLOR: purple; TEXT-DECORATION: underline
}
SPAN.MsoHyperlinkFollowed {
COLOR: purple; TEXT-DECORATION: underline
}
P.MsoAutoSig {
FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman"
}
LI.MsoAutoSig {
FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman"
}
DIV.MsoAutoSig {
FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman"
}
SPAN.EmailStyle17 {
COLOR: windowtext; FONT-FAMILY: Arial
}
DIV.Section1 {
page: Section1
}
</STYLE>
</HEAD>
<BODY lang=EN-US vLink=purple link=blue>
<DIV><SPAN class=542285416-19062002><FONT face=Arial color=#0000ff
size=2>Brad,</FONT></SPAN></DIV>
<DIV><SPAN class=542285416-19062002><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><FONT face=Arial><FONT color=#0000ff><FONT size=2><SPAN
class=542285416-19062002>I assume you are talking about the Transaction log in
MS SQL. If not, then I am mistaken. In NB 3.4 you could
only schedule (or at least that's all I could figure out) backups every 60
minutes. I am on 4.5 now but I haven't checked the scheduling options that
closely. Here is the script I use to backup the Transaction
log.</SPAN> <SPAN class=542285416-19062002> It truncates the log as
well.</SPAN></FONT></FONT></FONT></DIV>
<DIV><SPAN class=542285416-19062002><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=542285416-19062002><FONT face=Arial color=#0000ff
size=2>OPERATION BACKUP<BR>OBJECTTYPE TRXLOG<BR>DATABASE
"QAS"<BR>MAXTRANSFERSIZE 4<BR>BLOCKSIZE 6<BR>ALTCLIENT VQASDB<BR>DBMS
MSSQL<BR>TRACELEVEL MAX<BR>DSN "SAPQAS2_SQL"<BR>ENDOPER TRUE</FONT></SPAN></DIV>
<DIV><SPAN class=542285416-19062002><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=542285416-19062002><FONT face=Arial color=#0000ff size=2>Good
luck!</FONT></SPAN></DIV>
<DIV><SPAN class=542285416-19062002><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=542285416-19062002></SPAN><B><FONT face="MS Sans Serif">Rick
Morris</FONT></B> <BR><B><FONT face="MS Sans Serif" color=#008080 size=2>IGT -
SAP Basis Administrator</FONT></B> <BR><B><FONT face="MS Sans Serif"
color=#008080 size=2>775-448-7293</FONT></B> </DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B> Donaldson, Mark
[mailto:Mark.Donaldson AT experianems DOT com]<BR><B>Sent:</B> Tuesday, June
18, 2002
14:00 PM<BR><B>To:</B> 'Hillebrand, Bradly W.';
veritas-bu AT mailman.eng.auburn DOT edu<BR><B>Subject:</B> RE: [Veritas-bu]
MS SQL
Scripts<BR><BR></FONT></DIV>
<DIV><SPAN class=491225920-18062002><FONT face=Arial color=#0000ff size=2>I
have my oracle archived logs just picked up by an hourly incremental
backup. Would this work for you?</FONT></SPAN></DIV>
<DIV><SPAN class=491225920-18062002><FONT face=Arial color=#0000ff
size=2>-M</FONT></SPAN></DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B> Hillebrand, Bradly W.
[mailto:bhillebrand AT fhlbi DOT com]<BR><B>Sent:</B> Tuesday, June 18,
2002 2:08
PM<BR><B>To:</B> veritas-bu AT mailman.eng.auburn DOT
edu<BR><B>Subject:</B>
[Veritas-bu] MS SQL Scripts<BR><BR></FONT></DIV>
<DIV class=Section1>
<P class=MsoNormal><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">Does anyone have any Win2k
scripts that will work for MS SQL server? What I am wanting to do is
grab the archive logs that get dumped every 20 minutes.</SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"></SPAN></FONT> </P>
<P class=MsoAutoSig><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">Thanks,</SPAN></FONT></P>
<P class=MsoAutoSig><FONT face="Times New Roman" color=blue size=3><SPAN
style="FONT-SIZE: 12pt; COLOR: blue"></SPAN></FONT> </P>
<P class=MsoAutoSig><FONT face="Times New Roman" color=blue size=3><SPAN
style="FONT-SIZE: 12pt; COLOR: blue">Brad Hillebrand</SPAN></FONT></P>
<P class=MsoAutoSig><FONT face="Times New Roman" color=blue size=3><SPAN
style="FONT-SIZE: 12pt; COLOR: blue">FHLBI</SPAN></FONT></P>
<P class=MsoNormal><FONT face="Times New Roman" size=3><SPAN
style="FONT-SIZE:
12pt"></SPAN></FONT> </P></DIV></BLOCKQUOTE></BLOCKQUOTE></BODY></HTML>
------_=_NextPart_001_01C217B2.B5B23D90--
|
