Re: Big Problem with SQL Logs

Dale E. Reed Jr. ( (no email) )
Thu, 12 Jun 1997 09:28:43 -0700

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