Re: Big Problem with SQL Log

Mike Davis ( mkdvs@SPARC.NAXS.COM )
Thu, 12 Jun 1997 16:39:07 -0400 (EDT)

There is some way to get rid of the log files periodicly but I can't
remember how. Dumping just doesn't seem to do it.

On Thu, 12 Jun 1997, Dale E. Reed Jr. wrote:

> Will LaSala wrote:
> >
> > I have 2 seperate Log Devices each is 200mb's
> > and they are both full. I checked off those items
> > but now how should I go about clearing out some
> > of the wasted space?
> > I have 632 MBR's and a 250mb Emerald Database
> > with 400 mb's of Log space and Everything is full.
> > So is there a way that I could clear out or make these
> > databases and logs smaller?
>
> You should be able to truncate your logs. I have
> no idea why your logs would be that big. We only have about
> 75mb log space in our 250mb database and thats almost
> always empty. Have you tried to dump your logs?
> If you can't figure it out, let me know and I'll attach
> to your DB and see whats up.
>
> --
> Dale E. Reed Jr. (daler@iea.com)
> _________________________________________________________________
> IEA Software, Inc. | RadiusNT, Emerald, and NT FAQs
> Internet Solutions for Today | http://www.emerald.iea.com
>
> ----------------------------------------------------------
> Emerald Mailing List listserver@emerald.iea.com
>