Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Sybase websie went down due to tempdb is full.
72 views
Skip to first unread message
allenzh...@gmail.com
Feb 3, 2013, 4:42:55 AM2/3/13
to
[ServletException in:/nav.do?nav=header&external=false] Can't allocate space for object 'syslogs' in database 'tempdb' because 'logsegment' segment is full/has no free extents. If you ran out of space in syslogs, dump the transaction log. Otherwise, use ALTER DATABASE to increase the size of the segment. '
That's interesting to see.
Abhishek Goyal
Feb 2, 2015, 4:28:43 AM2/2/15
to
On Sunday, February 3, 2013 at 3:12:55 PM UTC+5:30, allenzh...@gmail.com wrote:
> [ServletException in:/nav.do?nav=header&external=false] Can't allocate space for object 'syslogs' in database 'tempdb' because 'logsegment' segment is full/has no free extents. If you ran out of space in syslogs, dump the transaction log. Otherwise, use ALTER DATABASE to increase the size of the segment. '
>
> That's interesting to see.
HI
> [ServletException in:/nav.do?nav=header&external=false] Can't allocate space for object 'syslogs' in database 'tempdb' because 'logsegment' segment is full/has no free extents. If you ran out of space in syslogs, dump the transaction log. Otherwise, use ALTER DATABASE to increase the size of the segment. '
>
> That's interesting to see.
You have two options for this
1. either you can dump tempdb with no logs
dump database tempdb with no_logs
2. or you can add DB space to tempdb in log device
alter database tempdb log on logdevice with size
Hope you will resolve this issue using above two menthods
0 new messages