Posted by brian.j.parker on 08/22/06 14:35

Tom Moreau wrote:
> Have you also tried:
>
> DUMP TRAN master WITH TRUNCATE_ONLY
>
> Also, consider just creating a new device and extend the log onto it.

Thank you, Tom, for replying.

Using "DUMP TRAN master" with any combination of NO_LOG and/or TRUNCATE
ONLY gives me the error "Can't allocate space for object 'Syslogs' in
database 'master' because the 'logsegment' segment is full..."

Trying to create a new device in Enterprise Manager or by using "DISK
INIT" either hangs or returns the same error.

Very frustrating!... if I could just dump the log, it seems, I could
add plenty of space.

[Back to original message]