[Emerald] Transaction log size

Andrew Stinson ( (no email) )
Mon, 23 Aug 1999 12:37:06 -0500

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?

Thanks

----------------------------------------------------------------------------
------------------------------------------
Andrew Stinson Apex 2000 Internet Services
Corporation
mailto:astinson@apex2000.net http://www.apex2000.net (915) 570-1676
----------------------------------------------------------------------------
------------------------------------------

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