From: "Doug Harpster" <dharpster@kans.com> Subject: RE: [Emerald] SQL Help.. Date: Wed, 30 Oct 2002 09:31:32 -0600 Message-ID: <241FD0B346141047953B9D4AEDC8C044028FCA@mail.carrollsweb.net>
AFAIK, you should be able to run the following SQL commands:
BACKUP LOG <Emerald Database Name> WITH TRUNCATE_ONLY
or
BACKUP LOG <Emerald Database Name> WITH NO_LOG
This should clear out the unused portion of the transaction logs.
Doug
> -----Original Message-----
> From: emerald-request@iea-software.com
> [mailto:emerald-request@iea-software.com] On Behalf Of Craig Hulbert
> Sent: Wednesday, October 30, 2002 9:22 AM
> To: emerald@iea-software.com
> Subject: [Emerald] SQL Help..
>
>
>
>
> I posted this before and got no answer.. I can't be the only
> person that has concern over the SQL Server emerald.ldf file
> size.. its at 5GB now and I would like to prune it... any cluse..
> besided the MS Method that doesn't work...
>
> MDF 56MB
> LDF 5GB
>
> Help..
>
>
>
>
> ________________________________________________________________
> Sent via the WebMail system at daytondigital.net
>
>
>
>
> ------------
>
> This is a user supported list. If you require assistance from
> IEA Software's Support Engineers, please check out our
> Support resources at http://www.iea-software.com/support.
>
> For more information about this list (including removal) go
> to: http://www.iea-software.com/support/maillists/liststart
>
>