You could also try backing up just log if you have room on the server then try to shrink it from within enterprise manager. If that does not work I have some scripts that will shrink logs. David Teague Support Analyst TMTsoftware 919-493-4700 -----Original Message----- From: thin-bounce@xxxxxxxxxxxxx [mailto:thin-bounce@xxxxxxxxxxxxx] On Behalf Of Toby Sent: Tuesday, May 17, 2005 8:59 AM To: thin@xxxxxxxxxxxxx Subject: [THIN] Re: SQL DatastoreTransaction.log I would shrink the log file. List, am I right in saying this logfile is the same as anyother database log file? Something like this; dbcc shrinkfile (logfilename, logfilesize) backup log logfilename WITH TRUNCATE_ONLY HTH On 5/17/05, Pataki, Thomas <tpataki@xxxxxxxxxxxxxxx> wrote: > Hallo Community, > > our MF XPe FR3 Farm with w2k SP4 has a MS SQL 2000 Datastore. I noticed > that the transaction.log for the farm database is currently over 1,5GB. > How do I safely erase the log or is it better to shorten it? The Problem > is, that were running out of space on the sql-box harddrive. > > Any suggestions? > > Thomas Pataki > ******************************************************** > This Weeks Sponsor: ThinPrint GmbH > Now available: The new version .print Engine 6.2 with SSL encryption > and certificate management. > http://www.thinprint.com > ********************************************************** > Useful Thin Client Computing Links are available at: > http://thin.net/links.cfm > ThinWiki community - Excellent SBC Search Capabilities! > http://www.thinwiki.com > *********************************************************** > For Archives, to Unsubscribe, Subscribe or > set Digest or Vacation mode use the below link: > http://thin.net/citrixlist.cfm > ******************************************************** This Weeks Sponsor: ThinPrint GmbH Now available: The new version .print Engine 6.2 with SSL encryption and certificate management. http://www.thinprint.com ********************************************************** Useful Thin Client Computing Links are available at: http://thin.net/links.cfm ThinWiki community - Excellent SBC Search Capabilities! http://www.thinwiki.com *********************************************************** For Archives, to Unsubscribe, Subscribe or set Digest or Vacation mode use the below link: http://thin.net/citrixlist.cfm ******************************************************** This Weeks Sponsor: ThinPrint GmbH Now available: The new version .print Engine 6.2 with SSL encryption and certificate management. http://www.thinprint.com ********************************************************** Useful Thin Client Computing Links are available at: http://thin.net/links.cfm ThinWiki community - Excellent SBC Search Capabilities! http://www.thinwiki.com *********************************************************** For Archives, to Unsubscribe, Subscribe or set Digest or Vacation mode use the below link: http://thin.net/citrixlist.cfm