<html>
<head>
<meta http-equiv=Content-Type content="text/html; charset=utf-8">
<meta name=Generator content="Microsoft Word 11 (filtered)">
<style>
<!--
/* Font Definitions */
@font-face
{font-family:"Monotype Corsiva";
panose-1:3 1 1 1 1 2 1 1 1 1;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline;}
span.EmailStyle17
{font-family:Arial;
color:windowtext;}
span.EmailStyle18
{font-family:Arial;
color:navy;}
span.EmailStyle19
{font-family:Arial;
color:navy;}
span.EmailStyle20
{font-family:Arial;
color:navy;}
span.EmailStyle21
{font-family:Arial;
color:navy;}
span.EmailStyle22
{font-family:Arial;
color:navy;}
span.EmailStyle23
{font-family:Arial;
color:navy;}
span.EmailStyle24
{font-family:Arial;
color:navy;}
span.EmailStyle26
{color:black;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.25in 1.0in 1.25in;}
div.Section1
{page:Section1;}
/* List Definitions */
ol
{margin-bottom:0in;}
ul
{margin-bottom:0in;}
-->
</style>
</head>
<body lang=EN-US link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal><font size=3 color=black face="Times New Roman"><span
style='font-size:12.0pt;color:black'>Hello, </span></font></p>
<p class=MsoNormal><font size=3 color=black face="Times New Roman"><span
style='font-size:12.0pt;color:black'> </span></font></p>
<p class=MsoNormal><font size=3 color=black face="Times New Roman"><span
style='font-size:12.0pt;color:black'>Good morning!</span></font></p>
<p class=MsoNormal><font size=3 color=black face="Times New Roman"><span
style='font-size:12.0pt;color:black'> </span></font></p>
<p class=MsoNormal><font size=3 color=black face="Times New Roman"><span
style='font-size:12.0pt;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 size=3 color=black face="Times New Roman"><span
style='font-size:12.0pt;color:black'> </span></font></p>
<p class=MsoNormal><font size=3 color=black face="Times New Roman"><span
style='font-size:12.0pt;color:black'>Thanks in advance</span></font></p>
<p class=MsoNormal><font size=3 color=black face="Times New Roman"><span
style='font-size:12.0pt;color:black'> </span></font></p>
<div>
<p class=MsoNormal><font size=3 color=black face="Times New Roman"><span
style='font-size:12.0pt;color:black'>◘◘◘◘◘◘◘◘◘◘◘◘◘◘◘◘◘◘◘◘◘◘◘◘◘◘◘◘◘◘◘◘◘◘◘◘◘◘◘◘◘◘◘◘◘◘◘◘◘◘◘◘◘◘◘◘◘◘◘◘</span></font></p>
<p class=MsoNormal><b><font size=3 color=black face=Arial><span
style='font-size:12.0pt;font-family:Arial;color:black;font-weight:bold'>Yurong
Tan, Ph.D.</span></font></b><font color=black face=Arial><span
style='font-family:Arial;color:black'>, <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 size=2 color=black face=Arial><span style='font-size:
11.0pt;font-family:Arial;color:black'>PSSG, Field Unit of ADUSH (Policy &
Planning)</span></font><font color=black face=Arial><span style='font-family:
Arial;color:black'>
Phone: 352-374-6080 (x5382)</span></font></p>
<p class=MsoNormal><font size=2 color=black face=Arial><span style='font-size:
11.0pt;font-family:Arial;color:black'>Department of Veterans Affairs </span></font><font
color=black face=Arial><span style='font-family:Arial;color:black'>
Fax: 352-374-6119</span></font></p>
<p class=MsoNormal><font size=2 color=black face=Arial><span style='font-size:
11.0pt;font-family:Arial;color:black'>300 E. University Avenue, Suite 430
</span></font><font color=black face=Arial><span style='font-family:Arial;
color:black'>
Web: www.med.va.gov</span></font></p>
<p class=MsoNormal><font size=2 color=black face=Arial><span style='font-size:
11.0pt;font-family:Arial;color:black'>Gainesville</span></font><font size=2
color=black face=Arial><span style='font-size:11.0pt;font-family:Arial;
color:black'>, Florida 32601 USA</span></font><font size=2 color=black
face=Arial><span style='font-size:11.0pt;font-family:Arial;color:black'>
</span></font></p>
<p class=MsoNormal><font size=1 color=black face="Times New Roman"><span
style='font-size:7.0pt;color:black'>________________________________________________________________</span></font></p>
<p class=MsoNormal><b><i><font size=5 color="#9900ff" face="Monotype Corsiva"><span
style='font-size:16.0pt;font-family:"Monotype Corsiva";color:#9900FF;
font-weight:bold;font-style:italic'>They all gave some and some gave all!</span></font></i></b></p>
<p class=MsoNormal><font size=3 color=black face="Times New Roman"><span
style='font-size:12.0pt;color:black'> </span></font></p>
<p class=MsoNormal><font size=3 color=black face="Times New Roman"><span
style='font-size:12.0pt;color:black'> </span></font></p>
</div>
</div>
</body>
</html>