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/$DATE.hddb.bak'
go
dump transaction cddb with no_log
go
dump transaction hddb with no_log
go
!


清理日志脚本；
$ cat /sybase/sbin/logclear
#!/bin/ksh

SYBASE=/sybase
DSQUERY=SYBASE
PATH=$SYBASE:$SYBASE/bin:$SYBASE/install:$PATH:.
LD_LIBRARY_PATH=/sybase/lib:$LD_LIBRARY_PATH
export SYBASE DSQUERY PATH LD_LIBRARY_PATH

EDITOR=vi;export EDITOR
cat $HOME/sbin/logclear.sql |isql -Usa -P
$ cat $HOME/sbin/logclear.sql
use master
go

dump transaction MBFEWKDB with no_log
go

dump transaction MBFEHISDB with no_log
go

dump transaction DIRWAYSDB with no_log
go

dump transaction DISWAYSDB with no_log
go


恢复SYBASE:
isql -Usa -P <<!
load database cddb from '/home/sybase/dbbak/$DATE.cddb.bak'
go
online database cddb
go
load database hddb from '/home/sybase/dbbak/$DATE.hddb.bak'
go
online database hddb
go
shutdown SYB_BACKUP
go
shutdown
go
!