shrug-l: SQL server log file question ...

[Tan, Yurong]

Hello, 

 

Good morning!

 

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?

 

Thanks in advance

 

◘◘◘◘◘◘◘◘◘◘◘◘◘◘◘◘◘◘◘◘◘◘◘◘◘◘◘◘◘◘◘◘◘◘◘◘◘◘◘◘◘◘◘◘◘◘◘◘◘◘◘◘◘◘◘◘◘◘◘◘

Yurong Tan, Ph.D., Program Analyst/GIS                     Email: Yurong.tan at med.va.gov

PSSG, Field Unit of ADUSH (Policy & Planning)                     Phone: 352-374-6080 (x5382)

Department of Veterans Affairs                                                                  Fax: 352-374-6119

300 E. University Avenue, Suite 430                                                    Web: www.med.va.gov

Gainesville, Florida 32601  USA     

________________________________________________________________

They all gave some and some gave all!

 

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.dep.state.fl.us/pipermail/shrug-l/attachments/20051108/87fc0d2c/attachment.htm