cancel
Showing results for 
Search instead for 
Did you mean: 

SAP ASE log has only 2 % free space what we do for this

t_ashok_reddy_t
Explorer
0 Kudos

SAP ASE log has only 2 % free space what we do for this

Accepted Solutions (0)

Answers (3)

Answers (3)

Johan_sapbasis
Active Contributor
0 Kudos

Hi Ashok,

These are the backup notes for sybase that is valid.

1585981 - SYB: Ensuring Recoverability for SAP ASE

1588316 - SYB: Configure automatic database and log backups

1611715 - SYB: How to restore an SAP ASE database server (Windows)

1618817 - SYB: How to restore an SAP ASE database server (UNIX)

1801984 - SYB: Automated management of long running transactions

1887068 - SYB: Using external backup and restore with SAP Sybase

For you to be able to do a transaction log dump from isql the command is:

dump transaction SID using config ='SIDLOG'

go

for this to work you would have to configured the dump config first. To check if it is existing.

In ISQL:

use master

go

sp_config_dump

go

If you get a return you will see something like:

sidlog

to see the config of this go

sp_config_dump SIDLOG

go

> go

optionname

        optionvalue

---------------------------------

        -------------------------

stripe_dir

        D:\Backup\log_archives

compression

        101

verify

        header

Your fix:

1. Create dump configuration as per note 1588316

2. Set parameter sybase trunc. log on chkpt false using command:

use master

go

sp_dboption 'SID', 'trunc. log on chkpt', 'false'

go

SyBooks Online

3. Then you need to run database dumpo first.

dump database SID to "d:\yourfolder\SID.dmp" with compression = 2

go

4. Once you have run the complete database dump then you can dump transaction log

dump transaction SID using config ='SIDLOG'

go

Please work through the notes.

Kind Regards,

Johan

Former Member
0 Kudos

Hello Ashok,

Please check following discussion:-

Backup - Sybase ASE | SCN

1588316 - SYB: Configure automatic database and log backups

Regards

Anand

Former Member
0 Kudos

Good info in existing thread: Shrink Log file +sybase ASE | SCN