[THIN] Re: SQL DatastoreTransaction.log
- From: Toby <toby.percival@xxxxxxxxx>
- To: thin@xxxxxxxxxxxxx
- Date: Tue, 17 May 2005 13:59:18 +0100
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
Other related posts:
