分享一下我老师大神的人工智能教程！零基础，通俗易懂！http://blog.csdn.net/jiangjunshow
也欢迎大家转载本篇文章。分享知识，造福人民，实现我们中华民族伟大复兴！
问题描述：
00:00000:00001:2007/09/15 10:56:14.76 server Completed REDO pass for database 'ge'.
00:00000:00001:2007/09/15 10:56:14.76 server Recovery of database 'ge' will undo incomplete nested top actions.
00:00000:00001:2007/09/15 10:56:14.76 server Started recovery checkpoint for database 'ge'.
00:00000:00001:2007/09/15 10:56:14.79 server Completed recovery checkpoint for database 'ge'.
00:00000:00001:2007/09/15 10:56:14.79 server Started filling free space info for database 'ge'.
00:00000:00001:2007/09/15 10:56:14.80 server Completed filling free space info for database 'ge'.
00:00000:00001:2007/09/15 10:56:14.81 server Started cleaning up the default data cache for database 'ge'.
00:00000:00001:2007/09/15 10:56:14.83 server Completed cleaning up the default data cache for database 'ge'.
00:00000:00001:2007/09/15 10:56:14.83 server Checking external objects.
00:00000:00001:2007/09/15 10:56:14.83 server Space available in the log segment has fallen critically low in database 'ge'. All future modifications to this database will be suspended until the log is successfully dumped and space becomes available.
00:00000:00001:2007/09/15 10:56:14.83 server Error: 1105, Severity: 17, State: 4
00:00000:00001:2007/09/15 10:56:14.83 server Can't allocate space for object 'syslogs' in database 'ge' 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.
00:00000:00010:2007/09/15 10:56:14.84 server Error: 950, Severity: 14, State: 1
00:00000:00010:2007/09/15 10:56:14.84 server Database 'ge' is currently offline. Please wait and try your command again later.
00:00000:00010:2007/09/15 10:56:14.84 server Threshold task could not use database 6, and so cannot execute the threshold procedure for segment 2, free space 153616.
00:00000:00010:2007/09/15 10:56:14.84 server Failed to execute the threshold procedure for database 6, segment 2, free space 153616.
00:00000:00001:2007/09/15 10:56:14.84 server SQL Server could not bring database 'ge' online.
00:00000:00001:2007/09/15 10:56:14.84 server Recovery has restored the value of 'local async prefetch limit' for '16K' pool in 'default data cache' from '80' to 'DEFAULT'.
00:00000:00001:2007/09/15 10:56:14.84 server Recovery has restored the value of 'local async prefetch limit' for '2K' pool in 'default data cache' from '80' to 'DEFAULT'.
00:00000:00001:2007/09/15 10:56:14.88 server Recovery has restored the original size for '16K' pool and '2K' pool in 'default data cache'.
解决方法：
进入isql
1> use master
2> go
1> dump tran ge with no_log
2> go
2> go
日志中信息如下：
00:00000:00011:2007/09/15 10:59:40.13 server WARNING: ***************************
00:00000:00011:2007/09/15 10:59:40.13 server Attempt by user 1 to dump xact on db ge with NO_LOG
sybase@CHQWEB:/sybase/ASE-12_5/install> 00:00000:00011:2007/09/15 11:01:05.62 server Attempt by user 1 to dump xact on db ge with NO_LOG was successful
00:00000:00011:2007/09/15 11:01:05.63 server WARNING: ***************************
sybase@CHQWEB:/sybase/ASE-12_5/install> 00:00000:00011:2007/09/15 11:02:30.00 server SQL Server shutdown by request.
00:00000:00011:2007/09/15 11:02:30.00 kernel ueshutdown: exiting
然后重新启动数据库即可
参考文章：http://hi.baidu.com/woshi123/blog/item/2328c31166b4c2c7a6ef3f37.html
| 系统提示Can"t allocate space for object "syslogs" in database "cwbase?" because the "logsegment" segment is full……该如何处理？ 上面的提示指数据库的日志已满，可用系统管理员按如下方法解决： |
给我老师的人工智能教程打call！http://blog.csdn.net/jiangjunshow
