From: "Jim Sheldon" <firstname.lastname@example.org> Subject: RE: [Emerald] SQL Help.. Date: Wed, 30 Oct 2002 09:44:06 -0600 Message-ID: <008c01c2802b$2e058d20$c35f1fd0@Jim>
I also had this problem along with another DB problem that kept me from
trimming the call files through Emerald. IEA suggested I make a new DB
and copy the data from the old one. This fixed my trim problem and
reduced the size of my log file form 6 gig to a few hundred meg. I do
not suggest this as a solution to reducing the log file unless nothing
else works. I will post a 2 quotes from an answer I got when I asked a
The deal is (I think) as follows:
It all depends on the Recovery model of the database (Under properties).
Since Emerald 4 is by default Bulk-Logged, this limits how quickly and
how the transaction logs can be truncated. See the below URL for more
(You will probably need to stitch the above URL back together)
I am not sure what version of emerald you have but I noticed in V4 the
log file does not truncate (or in my case) and I have not been able to
get it to truncate after backups. You can use a shrink file query in sql
query. Back up your database (always good practice) and run these two
First: BACKUP LOG Emerald4 WITH TRUNCATE_ONLY
DBCC SHRINKFILE(Emerald4_log, 25)
25 being the size you wish to shrink it to in MB
keep in mind this is for emerald V4 for just emerald drop the 4
[mailto:email@example.com] On Behalf Of Craig Hulbert Sent: Wednesday, October 30, 2002 9:22 AM To: firstname.lastname@example.org 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...
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
For more information about this list (including removal) go to: