用ISQL联接时出现如下的提示:
The tansaction log in master is almost full,Your transaction is being suspended until space is made available
isql无法联接master库
处理方法:
1、正常重启数据库后,isql仍然无法联接MASTER
2、备份master.dat
3、在启动批文件中加参数-T3607启动(sybase for win32);
4、将master库的空间加大2M (alter database master on master=2)
5、清除已提交的事务日志(dump tran dbname with truncate_only)
6、去掉-T3607,重启数据库OK
Copyright @ 2007-2012 敏韬网(敏而好学,文韬武略--MinTao.Net)(学习笔记) Inc All Rights Reserved. 闵涛 E_mail:admin@mintao.net(欢迎提供学习资源)
鄂公网安备 42011102001154号
站长:MinTao ICP备案号:鄂ICP备11006601号-18