Re: Pruning the log file

Josh Hillman ( (no email) )
Mon, 12 May 1997 16:45:29 -0400

You may need to truncate the transaction log from within SQL Enterprise
Manager:
Databases
Emerald
double-click on Emerald and you'll see the [truncate] button there. That
should do the trick.

Josh Hillman
hillman@talstar.com

----------
From: Mike Davis <mdavis@naxs.com>
To: 'emerald@emerald.iea.com'
Subject: Pruning the log file
Date: Monday, May 12, 1997 4:27 PM

SQL 6.0 running Emerald. I have tried "dump tran emerald to diskdump with
no_log" but the database does not show any more free space? Now, I
understand that sql logs every transaction but with just over 2,000
customers in Emerald, how could it need 250mb of disk space to not
complain? I could accept 70 or 80mb. Is there some concept I'm missing
here?

----------------------------------------------------------
Emerald Mailing List listserver@emerald.iea.com
----------