Re: [Emerald] Transaction log size

Dale E. Reed Jr. ( (no email) )
Mon, 23 Aug 1999 10:46:30 -0700

Messages sorted by: [ date ][ thread ][ subject ][ author ]
Previous message: Andrew Stinson: "[Emerald] Transaction log size"
Next message: Ted Beckwith: "[Emerald] E-mail notification of new MBR"
Maybe in reply to: Andrew Stinson: "[Emerald] Transaction log size"
Next in thread: Andrew Stinson: "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

Previous message: Andrew Stinson: "[Emerald] Transaction log size"
Next message: Ted Beckwith: "[Emerald] E-mail notification of new MBR"
Maybe in reply to: Andrew Stinson: "[Emerald] Transaction log size"
Next in thread: Andrew Stinson: "Re: [Emerald] Transaction log size"