Windows下配置Sybase发生tempdb日志以满问题，急！

winboys

免费乐捐，感谢支持

Sybase12_5 for Windows2000 安装成功后， 配置Sybase发生tempdb日志以满问题，急！

00:00000:00012:2005/11/10 09:16:01.04 server Configuration file 'F:\sybase\SYBASEDB.cfg' has been written and the previous version has been renamed to 'F:\sybase/SYBASEDB.003'.
00:00000:00012:2005/11/10 09:16:01.04 server The configuration option 'allow updates to system tables' has been changed by 'sa' from '0' to '1'.
00:00000:00012:2005/11/10 09:16:01.15 server Space available in the log segment has fallen critically low in database 'tempdb'. All future modifications to this database will be suspended until the log is successfully dumped and space becomes available.
00:00000:00013:2005/11/10 09:16:01.15 server Error: 2812, Severity: 16, State: 5
00:00000:00013:2005/11/10 09:16:01.15 server Stored procedure 'sp_thresholdaction' not found. Specify owner.objectname or use sp_help to check whether the object exists (sp_help may produce lots of output).
00:00000:00008:2005/11/10 09:17:36.06 server 1 task(s) are sleeping waiting for space to become available in the log segment for database tempdb.
00:00000:00008:2005/11/10 09:17:53.87 server 1 task(s) are sleeping waiting for space to become available in the log segment for database tempdb.
00:00000:00008:2005/11/10 09:18:53.81 server 1 task(s) are sleeping waiting for space to become available in the log segment for database tempdb.
00:00000:00008:2005/11/10 09:19:53.87 server 1 task(s) are sleeping waiting for space to become available in the log segment for database tempdb.

......

还有好多，请教如何解决？

ehxz

默认的tempdb肯定不够用的

要加大它要先建设备，然后绑定到tempdb库上。

codo

默认好象才3M,要扩一下。

flybean

默认安装是2M，装完之后第一件是就应是加大tempdb

wfcjz

先建立一个tempdb的数据库设备文件，然后在tempdb库中将建好的这个设备挂上就行了