on 07-24-2015 6:16 AM
SAP ASE log has only 2 % free space what we do for this
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Ashok,
Please check following discussion:-
1588316 - SYB: Configure automatic database and log backups
Regards
Anand
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Good info in existing thread: Shrink Log file +sybase ASE | SCN
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.