sybase 关于定时备份

1) 关于定时备份
http://www.chinaunix.net/cgi-bin/bbs/topic.cgi?forum=10&topic=1233&show=390
crontab 中可以这样写：
00 23 * * * /sybase/ASE-12_0/bin/DUMPDB.sh >;>;/sybase/ASE-12_0/install/DUMPDB.out

放那里都无所谓，一个dumpdb.sh的例子：
#SUN Solaris 8
#!/bin/ksh
export SYBASE=/sybase
export SYBASE_FTS=FTS-12_0
export PATH=/sybase/ASE-12_0/bin:/sybase/OCS-12_0/binPATH:/sybase/ASE-12_0/install:/usr/sbin
export SYBASE_OCS=OCS-12_0
export SYBASE_ASE=ASE-12_0
export LM_LICENSE_FILE=/sybase/SYSAM-1_0/licenses/license.datLM_LICENSE_FILE
export LD_LIBRARY_PATH=/sybase/ASE-12_0/lib:/usr/local/openwin/lib:/sybase/FTS-12_0/lib:/sybase/OCS-12_0/lib:/usr/local/openwin/lib:/usr/lib:/sybase/SQLRemote/libLD_LIBRARY_PATH
export SYBASE_SYSAM=SYSAM-1_0
export HOME=$SYBASE
$SYBASE_OCS/bin/isql -Usa -SSYBASE -P <;$LOG/backup.log
echo "\n11*************************" >;>;$LOG/backup.log
echo "Check database $bk_db..." >;>;$LOG/backup.log
d1=`date`
su - sybase -c "isql -SSYB_HP -Usa -P****** <;$LOG/dbcc-$ymd.log 2>;&1
dbcc traceon(3604)
go
dbcc checkdb($bk_db)
go
dbcc traceoff(3604)
go
DBCC
echo $d1,`date` >;>;$LOG/backup.log
echo "\n22*************************" >;>;$LOG/backup.log
d1=`date`
dump_file="/sybase/backup/$dump-unb-full-$ymd.dat"
echo "Dump database $bk_db to " $dump_file >;>;$LOG/backup.log
su - sybase -c "isql -SSYB_HP -Usa -P****** <;$LOG/dump-$ymd.log 2>;&1
dump database $bk_db to "$dump_file"
go
DUMP
echo $d1,`date` >;>;$LOG/backup.log
echo "\n33*************************" >;>;$LOG/backup.log
请根据自身系统，调试后再使用！
至于备份日志的脚本与此类似，自己根据sybase的相关语法，稍加变动即可！