当前位置: 代码迷 >> Sybase >> Sybase ASE Master库日记满的处理方法
  详细解决方案

Sybase ASE Master库日记满的处理方法

热度:1849   发布时间:2013-02-26 00:00:00.0
Sybase ASE Master库日志满的处理方法

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
????????关 键 词:?? 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