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

  • 来源: 互联网 作者: 若水   2008-03-19/10:26
  • 用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


    评论 {{userinfo.comments}}

    {{money}}

    {{question.question}}

    A {{question.A}}
    B {{question.B}}
    C {{question.C}}
    D {{question.D}}
    提交

    驱动号 更多