Re: [Emerald] Transaction log size

Josh Hillman ( (no email) )
Tue, 24 Aug 1999 11:09:58 -0400

Messages sorted by: [ date ][ thread ][ subject ][ author ]
Previous message: Josh Hillman: "Re: [Emerald] printing invoices"
Next message: Steve Civilla: "[Emerald]"
Maybe in reply to: Andrew Stinson: "[Emerald] Transaction log size"
Next in thread: Dale E. Reed Jr.: "Re: [Emerald] Transaction log size"

From: Andrew Stinson <astinson@apex2000.net>
> Would shrinking the DB perform the same task? We ran the script and
instead
> of shrinking the log file down to 200 meg, it took about 2 gig off the
size
> of it....so it's down to about 4 gig.....we're trying to restore it onto a
> win '95 pc, but it keeps telling us we've only got 2 gig free, and we need
a
> little over 5 free. It's on a hdd with 8 gig free...where's this 2 gig
> coming from? Is there anything i'm missing? It should just be a matter of
> restoring the db....could it be that i'm using Win '95 instead of NT?

How did your transaction logs get so big to begin with? Have you tried to
truncate the transaction log? Double-click on the Emerald db, then you'll
see a button that says "Truncate" under "Transaction Log".

Our log device (for the transaction logs) is 35 megs and 99% of the time,
there's 34.8 to 35.0 megs free on it. I also have "Truncate log on
Checkpoint" selected under the Options tab.

Josh

> ----- Original Message -----
> From: Dale E. Reed Jr. <daler@iea-software.com>
> To: <emerald@iea-software.com>
> Sent: Monday, August 23, 1999 1:25 PM
> Subject: Re: [Emerald] Transaction log size
>
>
> > Andrew Stinson wrote:
> > >
> > > how would you use enterprise manager to change it? when we try to make
> it
> > > smaller it says: "the new dbfile size must be larger than the current
> > > size"....
> >
> > Sorry, I was thinking about just shrinking the database, not the actual
> > file itself.
> >
> > --
> >
> > Dale E. Reed Jr. Emerald and RadiusNT
> > __________________________________________
> > IEA Software, Inc. www.iea-software.com
> >
> > For more information about this list (including removal) go to:
> > http://www.iea-software.com/support/maillists/liststart
> >
>
>
>
> For more information about this list (including removal) go to:
> http://www.iea-software.com/support/maillists/liststart

For more information about this list (including removal) go to:
http://www.iea-software.com/support/maillists/liststart

Previous message: Josh Hillman: "Re: [Emerald] printing invoices"
Next message: Steve Civilla: "[Emerald]"
Maybe in reply to: Andrew Stinson: "[Emerald] Transaction log size"
Next in thread: Dale E. Reed Jr.: "Re: [Emerald] Transaction log size"