Re: [Emerald] HELP ASAP!!!!!

PowerNet ( (no email) )
Thu, 30 Sep 1999 11:10:08 -0400

What does truncate log do?
Will I see problems down the road?

John

*********** REPLY SEPARATOR ***********

On 9/30/99, at 10:49 AM, Josh Hillman wrote:

>From: PowerNet <psc5@powersupply.net>
>Msg 1105, Level 17, State 2
>Can't allocate space for object 'Syslogs' in database 'Emerald' because=
the
>'logsegment' segment is full. If you ran out of space in Syslogs, dump the
>transaction log. Otherwise, use ALTER DATABASE or sp_extendsegment to
>increase the size of the segment.
>Msg 1105, Level 17, State 2
>Can't allocate space for object 'Syslogs' in database 'Emerald' because=
the
>'logsegment' segment is full. If you ran out of space in Syslogs, dump the
>transaction log. Otherwise, use ALTER DATABASE or sp_extendsegment to
>increase the size of the segment.
>
>
>Go into SQL enterprise manager
>find the Emerald database and double-click on it.
>Click on Truncate Log.
>
>I'll send other suggestions for what to do after this in a few minutes.
>
>Josh
>
>
>For more information about this list (including removal) go to:
>http://www.iea-software.com/support/maillists/liststart

For more information about this list (including removal) go to:
http://www.iea-software.com/support/maillists/liststart