sybase 备份和恢复

use master
go

dump transaction MBFEWKDB with no_log
go

dump transaction MBFEHISDB with no_log
go

use master
go
dump database MBFEWKDB to 'MBFEWKDB.bak'
go

use master
go
dump database MBFEHISDB to 'MBFEHISDB.bak'
go

use master
go

dump transaction MBFEWKDB with no_log
go

dump transaction MBFEHISDB with no_log
go

quit

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

use master
go

dump transaction DIRWAYSDB with no_log
go

dump transaction DISWAYSDB with no_log
go

use master
go
dump database DIRWAYSDB to 'DIRWAYSDB.bak'
go

use master
go
dump database DISWAYSDB to 'DISWAYSDB.bak'
go

use master
go

dump transaction DIRWAYSDB with no_log
go

dump transaction DISWAYSDB with no_log
go

quit

备份脚本；
DATE=`date "+%Y%m%d"`
. ~/.bash_profile
isql -Usa -P <<!
dump database cddb to '/home/sybase/dbbak/$DATE.cddb.bak'
go
dump database hddb to '/home/sybase/dbbak/$DA