RE: [Emerald] SQL Help..

New Message Reply Date view Thread view Subject view Author view
Jim Sheldon (
Wed, 30 Oct 2002 09:44:06 -0600

From: "Jim Sheldon" <>
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 similar question.


" 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 info: c/8_ar_da2_7vaf.asp

(You will probably need to stitch the above URL back together)


"Jim, 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 commands:



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


-----Original Message----- From:
[] On Behalf Of Craig Hulbert Sent: Wednesday, October 30, 2002 9:22 AM To: 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


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:

New Message Reply Date view Thread view Subject view Author view
This archive was generated on Wed Oct 30 2002 - 07:24:55 Pacific Standard Time