Sybase ASE Master库日志满的处理方法
新闻简介: 用ISQL联接时出现如下的提示:
The tansaction log in master is almost full,Your transaction is being suspended until space is made available
用ISQL联接时出现如下的提示:
The tansaction log in master is almost full,Your tran
The tansaction log in master is almost full,Your transaction is being suspended until space is made available
用ISQL联接时出现如下的提示:
The tansaction log in master is almost full,Your tran
关 键 词:
Sybase
用ISQL联接时出现如下的提示:
The tansaction log in master is almost full,Your transaction is being suspended until space is made available
用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