Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2013

    Unanswered: Log space not cleared after sp_dumptrans procedure

    Hi Folks.

    I'm performing a transaction DUMP and it is executed sucessfully but the log filesystem /sybase/EAX/saplog_1 remain full and is not being empty after the sp_dumptrans DBID procedure.

    I'm using ASE, SuSE 11.

    Could you please help me?

  2. #2
    Join Date
    Mar 2008
    As far as I know there is no sp_dumptrans stored procedure provided by Sybase. may be either its a customised procedure of your environment or some sp that sybase internally use while dumping the trans.
    for clearing up the log system, you need to take a transaction dump by using below command

    dump tran <db_name> to 'file name with complete path>

    or set the trunc log on chkpt db option for the database in question.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts