数据库备份

备份： 使用 isql -Usa -P -SSYBASE 命令连接至数据库，依次备份早教系统edu_cfg和edu_stat两个用户数据库。(前提条件是Backup Server服务要启动)
dump database edu_cfg to '/home/sybase/edu_cfg_jiangsu_20140514.dmp'
go
dump database edu_stat to '/home/sybase/edu_stat_jiangsu_20140514.dmp'
go




1) 使用 isql -Usa -P -SSYBASE 命令连接至数据库，执行下面sql语句恢复edu_stat数据库
use master
go
sp_dboption edu_stat, "single user", true
go
checkpoint
go


load database edu_stat from '/home/sybase_fusion/update/2014-05-14/edu_stat_jiangsu_20140514.dmp'
go
online database edu_stat
go
use master
go
sp_dboption edu_stat, "trunc",true
go


sp_dboption edu_stat, "single user", false
go


2) 使用 isql -Usa -P -SSYBASE 命令连接至数据库，执行下面sql语句恢复edu_cfg数据库
use master
go
sp_dboption edu_cfg, "single user", true
go
checkpoint
go


load database edu_cfg from '/home/sybase/databak/edu_cfg_bak20131125.dmp'
go
online database edu_cfg
go
use master
go
sp_dboption edu_cfg, "trunc",true
go


sp_dboption edu_cfg, "single user", false
go