Discussion:
Sybase backup and restore methods?
(too old to reply)
Selva Kumar K
2013-09-13 01:09:14 UTC
Permalink
Raw Message
Hi ,

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?
zionassedo
2014-01-08 03:41:34 UTC
Permalink
Raw Message
Post by Selva Kumar K
Hi ,
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 :
use master
go
sp_dboption dbname "trunc log on chkpt",false
go
use dbname
go
checkpoint
go
/*
Perform then initial full dump
*/
dump dbname to "/device/dbname.dmp"
go

/*
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.
Loading...