From: "Jeffrey M Donley" <jeffd@lmf.net> Subject: RE: [Emerald] SQL Help.. Date: Wed, 30 Oct 2002 10:49:26 -0500 Message-ID: <GAEHIKBCFLDAOHNDPKGCKEEECPAA.jeffd@lmf.net>
Craig,
Run these in your sql analyzer
BACKUP LOG <database name> WITH TRUNCATE_ONLY
DBCC SHRINKFILE(data base name_log, 25)
This will truncate the unused portion of your log file, Then shrink the log
to 25 MB
-----Original Message-----
From: emerald-request@iea-software.com
[mailto:emerald-request@iea-software.com]On Behalf Of Craig Hulbert
Sent: Wednesday, October 30, 2002 10:22 AM
To: emerald@iea-software.com
Subject: [Emerald] SQL Help..
I posted this before and got no answer.. I can't be the only
person that has concern over the SQL Server emerald.ldf file
size.. its at 5GB now and I would like to prune it... any cluse..
besided the MS Method that doesn't work...
MDF 56MB
LDF 5GB
Help..
________________________________________________________________
Sent via the WebMail system at daytondigital.net
------------
This is a user supported list. If you require assistance from IEA Software's
Support Engineers, please check out our Support resources at
http://www.iea-software.com/support.
For more information about this list (including removal) go to:
http://www.iea-software.com/support/maillists/liststart