Post by Selva Kumar K
Can anyone tell me different types of backup and restore methods in sybase ase 15.7?i have find full,incremental only two backup methods in sybase?is there any other types is there?
you can can perform a dull dump, keep the dump file and then perform dump transactions to files but before you must set your database option "trunc log on chkpt" to false.
Here is the sequence :
sp_dboption dbname "trunc log on chkpt",false
Perform then initial full dump
dump dbname to "/device/dbname.dmp"
Then at a frequence that you set depending on how your transaction log segment gets full
dump transaction dbname to "/device/dbname_'$chrono_number'.trn"
you will have to set your chrono_number to a new value (unique) so you dont risk to override any transaction file
For example select datediff(ss,'1970',getdate()) will supply a unique number
My advice : do not trust all transaction files and perform at least 1 full dump a day.
For restore, you load the last full dump and load all transaction files in the proper order.