Re: [Emerald] Transaction log size

Andrew Stinson ( (no email) )
Mon, 23 Aug 1999 13:08:46 -0500

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"....
----------------------------------------------------------------------------
------------------------------------------
Andrew Stinson Apex 2000 Internet Services
Corporation
mailto:astinson@apex2000.net http://www.apex2000.net (915) 570-1676
----------------------------------------------------------------------------
------------------------------------------

----- Original Message -----
From: Dale E. Reed Jr. <daler@iea-software.com>
To: <emerald@iea-software.com>
Sent: Monday, August 23, 1999 12:46 PM
Subject: Re: [Emerald] Transaction log size

> Andrew Stinson wrote:
> >
> > We have a really large allocation setup for our Emerald Transaction log.
> > (currently almost 6 gig). The actual size of the transaction log file is
64
> > meg right now. Our question is this: we're wanting to run the following
> > script to make is smaller:
> >
> > DBCC SHRINKFILE (Emerald_log , 200 , TRUNCATEONLY)
> >
> > could this possibly cause any problems? This would be run on our
production
> > server and don't want to cause any problems....(if I wrote it right, it
> > should make the Emerald_log allocated space 200 meg when we truncate
it.)
> > Do you (anyone) foresee any problems this could cause?
>
> SHould be fine. I think you have to be in signle user mode to
> do it. You can just use the Enterprise Manager to change it as
> well.
>
> --
>
> 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