maybe there's just an old transaction left open? Try DBCC OPENTRAN
(Emerald) to check,
then issue
dump transaction Emerald with truncate_only
followed by
dump database Emerald to disk = '<UNC filename>' with init, stats=5
Please let me know if it worked!
cu,
-
Peter A. Sang
SANG Computersysteme GmbH * Kruppstr. 82-100 * 45145 Essen * Germany
T: +49-201-82020-0 * F:-40 * http://sang.net * mailto:pesa@sang.net
* Microsoft Solution Provider * Intel Systems Integrator *
>----------
>Von: will@greennet.net[SMTP:will@greennet.net]
>Gesendet: Donnerstag, 12. Juni 1997 16:07
>An: emerald@emerald.iea.com
>Betreff: Re: Big Problem with SQL Logs
>
>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?
>
>Thanks
>Will
>
>
> ----
>From: Dale E. Reed Jr. <daler@iea.com>
>To: emerald@emerald.iea.com
>Date: Wednesday, June 11, 1997 11:04 PM
>Subject: Re: Big Problem with SQL Logs
>
>>Will LaSala wrote:
>>>
>>> I got a BIG problem here
>>> I have 2 log devices that are totally full.
>>> 400 Megs of nothing but logs.
>>> When I go in and tell it to trunacate the Log
>>> It seems to get bigger not smaller.
>>>
>>> I can't figure out how to Dump the info in the log files
>>> I don't need any of the log info nad I've never used the logs for
>>> SQL so if there is a way to turn off loggin totally please tell
>>> me.
>>>
>>> So right now I can't save or do anything to emerald
>>
>>Go into SEM, double click on the database, and check:
>>
>>Bulk Copy/Into
>>Truncate on Checkpoint
>>No Checkpoint on Recovery
>>
>>Enabling those three should keep your logs pretty small. I wouldn't
>>know why your logs are that big. Do you have them on a seperate
>>device from your database?
>>
>>--
>>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
>>
>
>
> ----------------------------------------------------------
> Emerald Mailing List listserver@emerald.iea.com
>
>