<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=utf-8">
<META content="MSHTML 6.00.2900.2769" name=GENERATOR>
<STYLE>@font-face {
font-family: Monotype Corsiva;
}
@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
}
SPAN.EmailStyle17 {
COLOR: windowtext; FONT-FAMILY: Arial
}
SPAN.EmailStyle18 {
COLOR: navy; FONT-FAMILY: Arial
}
SPAN.EmailStyle19 {
COLOR: navy; FONT-FAMILY: Arial
}
SPAN.EmailStyle20 {
COLOR: navy; FONT-FAMILY: Arial
}
SPAN.EmailStyle21 {
COLOR: navy; FONT-FAMILY: Arial
}
SPAN.EmailStyle22 {
COLOR: navy; FONT-FAMILY: Arial
}
SPAN.EmailStyle23 {
COLOR: navy; FONT-FAMILY: Arial
}
SPAN.EmailStyle24 {
COLOR: navy; FONT-FAMILY: Arial
}
SPAN.EmailStyle26 {
COLOR: black
}
DIV.Section1 {
page: Section1
}
OL {
MARGIN-BOTTOM: 0in
}
UL {
MARGIN-BOTTOM: 0in
}
</STYLE>
</HEAD>
<BODY lang=EN-US vLink=purple link=blue>
<DIV dir=ltr align=left><SPAN class=020541118-08112005><FONT face=Arial
color=#0000ff size=2>Hi,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=020541118-08112005><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=020541118-08112005><FONT face=Arial
color=#0000ff size=2>You need to backup the log file before you can shrink
it. Let me know if you need help.</FONT></SPAN></DIV>
<DIV><FONT face=Arial color=#0000ff size=2></FONT> </DIV>
<DIV align=left><FONT face=Tahoma size=2>Michelle Palmer, GISP, PMP</FONT></DIV>
<DIV align=left><FONT face=Tahoma size=2>Associate Vice President</FONT></DIV>
<DIV align=left><FONT face=Tahoma size=2>PBS&J</FONT></DIV>
<DIV align=left><FONT face=Tahoma size=2></FONT> </DIV>
<DIV align=left>
<DIV align=left><FONT face=Tahoma size=2>800-284-5182</FONT></DIV>
<DIV align=left><FONT face=Tahoma size=2>407-806-4218 (direct dial)</FONT></DIV>
<DIV align=left><FONT face=Tahoma size=2>407-647-0624 (fax)</FONT></DIV>
<DIV align=left><FONT face=Tahoma size=2>407-367-9050 (cell phone)</FONT></DIV>
<DIV align=left><FONT face=Tahoma size=2>mcpalmer@pbsj.com</FONT></DIV></DIV>
<DIV> </DIV><BR>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B> shrug-l-bounces@lists.dep.state.fl.us
[mailto:shrug-l-bounces@lists.dep.state.fl.us] <B>On Behalf Of </B>Tan,
Yurong<BR><B>Sent:</B> Tuesday, November 08, 2005 11:09 AM<BR><B>To:</B>
shrug-l@lists.dep.state.fl.us<BR><B>Subject:</B> shrug-l: SQL server log file
question ...<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV class=Section1>
<P class=MsoNormal><FONT face="Times New Roman" color=black size=3><SPAN
style="FONT-SIZE: 12pt; COLOR: black">Hello, </SPAN></FONT></P>
<P class=MsoNormal><FONT face="Times New Roman" color=black size=3><SPAN
style="FONT-SIZE: 12pt; COLOR: black"></SPAN></FONT> </P>
<P class=MsoNormal><FONT face="Times New Roman" color=black size=3><SPAN
style="FONT-SIZE: 12pt; COLOR: black">Good morning!</SPAN></FONT></P>
<P class=MsoNormal><FONT face="Times New Roman" color=black size=3><SPAN
style="FONT-SIZE: 12pt; COLOR: black"></SPAN></FONT> </P>
<P class=MsoNormal><FONT face="Times New Roman" color=black size=3><SPAN
style="FONT-SIZE: 12pt; COLOR: black">I have an ArcSDE SQL server (2000) and
the log file has grown excessively large (now it is 39 GB). I have a
feeling that the large log file begins to take toll on the server performance.
It is my understanding that the log files are for transaction purpose and its
contents are temporary. I tried to shrink it, especially when
transaction/connection activities are eliminated, but I couldn’t. Can someone
on this list give some pointers what I am missing here?</SPAN></FONT></P>
<P class=MsoNormal><FONT face="Times New Roman" color=black size=3><SPAN
style="FONT-SIZE: 12pt; COLOR: black"></SPAN></FONT> </P>
<P class=MsoNormal><FONT face="Times New Roman" color=black size=3><SPAN
style="FONT-SIZE: 12pt; COLOR: black">Thanks in advance</SPAN></FONT></P>
<P class=MsoNormal><FONT face="Times New Roman" color=black size=3><SPAN
style="FONT-SIZE: 12pt; COLOR: black"></SPAN></FONT> </P>
<DIV>
<P class=MsoNormal><FONT face="Times New Roman" color=black size=3><SPAN
style="FONT-SIZE: 12pt; COLOR: black">◘◘◘◘◘◘◘◘◘◘◘◘◘◘◘◘◘◘◘◘◘◘◘◘◘◘◘◘◘◘◘◘◘◘◘◘◘◘◘◘◘◘◘◘◘◘◘◘◘◘◘◘◘◘◘◘◘◘◘◘</SPAN></FONT></P>
<P class=MsoNormal><B><FONT face=Arial color=black size=3><SPAN
style="FONT-WEIGHT: bold; FONT-SIZE: 12pt; COLOR: black; FONT-FAMILY: Arial">Yurong
Tan, Ph.D.</SPAN></FONT></B><FONT face=Arial color=black><SPAN
style="COLOR: black; FONT-FAMILY: Arial">, <I><SPAN
style="FONT-STYLE: italic">Program
Analyst/GIS</SPAN></I>
Email: <A
href="mailto:Yurong.tan@med.va.gov">Yurong.tan@med.va.gov</A></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial color=black size=2><SPAN
style="FONT-SIZE: 11pt; COLOR: black; FONT-FAMILY: Arial">PSSG, Field Unit of
ADUSH (Policy & Planning)</SPAN></FONT><FONT face=Arial color=black><SPAN
style="COLOR: black; FONT-FAMILY: Arial">
Phone: 352-374-6080 (x5382)</SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial color=black size=2><SPAN
style="FONT-SIZE: 11pt; COLOR: black; FONT-FAMILY: Arial">Department of
Veterans Affairs </SPAN></FONT><FONT face=Arial color=black><SPAN
style="COLOR: black; FONT-FAMILY: Arial">
Fax: 352-374-6119</SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial color=black size=2><SPAN
style="FONT-SIZE: 11pt; COLOR: black; FONT-FAMILY: Arial">300 E. University
Avenue, Suite 430 </SPAN></FONT><FONT face=Arial color=black><SPAN
style="COLOR: black; FONT-FAMILY: Arial">
Web: www.med.va.gov</SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial color=black size=2><SPAN
style="FONT-SIZE: 11pt; COLOR: black; FONT-FAMILY: Arial">Gainesville</SPAN></FONT><FONT
face=Arial color=black size=2><SPAN
style="FONT-SIZE: 11pt; COLOR: black; FONT-FAMILY: Arial">, Florida
32601 USA</SPAN></FONT><FONT face=Arial color=black size=2><SPAN
style="FONT-SIZE: 11pt; COLOR: black; FONT-FAMILY: Arial">
</SPAN></FONT></P>
<P class=MsoNormal><FONT face="Times New Roman" color=black size=1><SPAN
style="FONT-SIZE: 7pt; COLOR: black">________________________________________________________________</SPAN></FONT></P>
<P class=MsoNormal><B><I><FONT face="Monotype Corsiva" color=#9900ff
size=5><SPAN
style="FONT-WEIGHT: bold; FONT-SIZE: 16pt; COLOR: #9900ff; FONT-STYLE: italic; FONT-FAMILY: 'Monotype Corsiva'">They
all gave some and some gave all!</SPAN></FONT></I></B></P>
<P class=MsoNormal><FONT face="Times New Roman" color=black size=3><SPAN
style="FONT-SIZE: 12pt; COLOR: black"></SPAN></FONT> </P>
<P class=MsoNormal><FONT face="Times New Roman" color=black size=3><SPAN
style="FONT-SIZE: 12pt; COLOR: black"></SPAN></FONT> </P></DIV></DIV></BLOCKQUOTE></BODY></HTML>