on 11-20-2017 11:28 AM - last edited on 02-04-2024 1:59 AM by postmig_api_4
Dear All,
I would like to share my knowledge here. Kindly find the following backup configuration and how to take DB+LOG backup for Sybase.
Backup Tool: Putty
Database : Sybase ASE 16.0
First need to login with ''sybsid''
[root@bwdev ~]# su - sybsid
[sybgbd@bwdev ~]$
Sample Command Format:
[sybsid@bddev ~]$ isql -Usapsa -SSID -X
Password: 1> use master
2> go
( SID Transaction Log Database Backup configuration )
1> sp_config_dump @config_name='SIDLOG',
2> @stripe_dir = '/sybase/SID/SIDLOG_BACKUP' ,
3> @compression = '101' ,
4> @verify = 'header'
5> go
The change is completed. The option is dynamic and ASE need not be rebooted for
the change to take effect.
(return status = 0)
1>
( SID Database Backup configuration )
1> sp_config_dump @config_name='SIDDB',
2> @stripe_dir = '/sybase/SID/SIDDB_BACKUP',
3> @compression = '101' ,
4> @verify = 'header'
5> go
The change is completed. The option is dynamic and ASE need not be rebooted for
the change to take effect.
(return status = 0)
DB backup :
1>dump database master using config = SIDDB
2>go 1>dump database model using config = SIDDB
2>go 1>dump database saptempdb using config = SIDDB
2>go 1>dump database saptools using config = SIDDB
2>go 1>dump database NPD using config = SIDDB
2>go
Trans log backup :
1>dump transaction NPD using config = SIDLOG
2>go
Note:
Pre-Requisite for sybase DB and LOG.I was given as per following path.
/sybase/SID/SIDDB_BACKUP
/sybase/SID/SIDLOG_BACKUP
If you are facing any issue, Please follow the below URL...
https://archive.sap.com/discussions/thread/3271685
Thanks,
Jeyaganesh.M
Thanks!
Yes.... I hope clearly mention the full backup scenario for Sybase. It will useful for all.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Excellent Document👍.. I really appreciate..
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Dear Jeyaganesh,
Thanks for this document.. It is very Useful for me!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Jeyaganesh
Nice one, I followed the same steps, & how we can create the automated scripts to take the backup in windows OS with Sybase 15.7
Regards
SS
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
there are two schedulers already available on your machine.
You can either use ASE job scheduler (please check the corresponding manual)
or Windows scheduler.
For Windows scheduler you can put all your sql stuff into a single sql script (e.g. backup.sql).
Then you can create a small batch file (e.g. backup.bat) calling ASE using the backup.sql file. All in all the backup.bat file should contain a like like this:
isql -U backup_user -P password -S ABC -i c:\ASE\scripts\backup.sql -o c:\ASE\log\backup.log
Finally you can call this script / bat file using the Windows scheduler. The script name (fullpath\backup.bat) must provided in the action tab when creating a new task.
Best regards,
Juergen
Hi Juergen.
While executing the command as mention below
isql -U backup_user -P password -S(windwos Failover Cluster virtual Name) -ic:\ASE\scripts\backup.sql-oc:\ASE\log\backup.log
we are getting the following error message in ASE 15.7
"No language handler installed. Language cmd: dump database AFP to 'M:\backups\AFP_Database' with compression = 101"
how we can resolve the issue? Could you help us
Regards
SS
Hi Juergen
Manually backup is getting completed there no issues, with the same command what I was mentioned in the backup.sql file
______________
dump database <database_name> to <device_name>
go
dump tran <database_name> with no_log
go
_________
when we are trying to do automated we are getting error messages what I was shared with you in my previous communications could pls help me.
Regards
SS
Hi,
this is somehow good as backup in general is working. Next, in my step by step approach, I would just put both commands into a small sql script and call it via an input file:
isql .... -i c:\testscript.sql
In the isql line, you pasted above, there is a strange ASE name (windwos Failover Cluster virtual Name). Are you sure that you connect to the correct ASE? Sometimes language handler issues occur because you're connected to the wrong instance that doesn't understand the command (e.g. connected to Backup Server or Replication Server instead of ASE).
Btw.: dump tran ..with no_log is a kind of last resort when the transaction log is completely full. Usually with truncate_only is used when you don't want to store the log content.
Best regards,
Juergen
User | Count |
---|---|
83 | |
24 | |
12 | |
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.