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

[Palmer, Michelle]

Hi,
 
You need to backup the log file before you can shrink it.  Let me know if you need help.
 
Michelle Palmer, GISP, PMP
Associate Vice President
PBS&J
 
800-284-5182
407-806-4218 (direct dial)
407-647-0624 (fax)
407-367-9050 (cell phone)
mcpalmer at pbsj.com
 


________________________________

	From: shrug-l-bounces at lists.dep.state.fl.us [mailto:shrug-l-bounces at lists.dep.state.fl.us] On Behalf Of Tan, Yurong
	Sent: Tuesday, November 08, 2005 11:09 AM
	To: shrug-l at lists.dep.state.fl.us
	Subject: shrug-l: SQL server log file question ...
	
	

	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/098cd159/attachment.html