Windows下配置Sybase发生tempdb日志以满问题，急！
<P>Sybase12_5 for Windows2000 安装成功后， 配置Sybase发生tempdb日志以满问题，急！</P><P>00:00000:00012:2005/11/10 09:16:01.04 serverConfiguration file 'F:\sybase\SYBASEDB.cfg' has been written and the previous version has been renamed to 'F:\sybase/SYBASEDB.003'.<BR>00:00000:00012:2005/11/10 09:16:01.04 serverThe configuration option 'allow updates to system tables' has been changed by 'sa' from '0' to '1'.<BR>00:00000:00012:2005/11/10 09:16:01.15 serverSpace 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.<BR>00:00000:00013:2005/11/10 09:16:01.15 serverError: 2812, Severity: 16, State: 5<BR>00:00000:00013:2005/11/10 09:16:01.15 serverStored 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).<BR>00:00000:00008:2005/11/10 09:17:36.06 server1 task(s) are sleeping waiting for space to become available in the log segment for database tempdb.<BR>00:00000:00008:2005/11/10 09:17:53.87 server1 task(s) are sleeping waiting for space to become available in the log segment for database tempdb.<BR>00:00000:00008:2005/11/10 09:18:53.81 server1 task(s) are sleeping waiting for space to become available in the log segment for database tempdb.<BR>00:00000:00008:2005/11/10 09:19:53.87 server1 task(s) are sleeping waiting for space to become available in the log segment for database tempdb.</P>
<P>......</P>
<P>还有好多，请教如何解决？</P> <P>默认的tempdb肯定不够用的</P>
<P>要加大它要先建设备，然后绑定到tempdb库上。</P> <P>默认好象才3M,要扩一下。</P> 默认安装是2M，装完之后第一件是就应是加大tempdb <P>先建立一个tempdb的数据库设备文件，然后在tempdb库中将建好的这个设备挂上就行了</P>
页:
[1]