-
在Linux 6上安装并创建Sybase 15.7数据库备份与恢复服务
资源介绍
数据库备份与恢复
BCP语句
bcp tdhportal..TU_SSO_CLIENT_KEY out c:\bcp\TU_SSO_CLIENT_KEY.out -m100 -n -b10 -T10240000 -Usa -Pqwe123 -Sxzxp
bcp tdhportal..TU_SSO_CLIENT_KEY in c:\bcp\TU_SSO_CLIENT_KEY.out -m100 -n -b10 -T10240000 -Usa -Pqwe123 -Sxzxp
生成BCP语句
out
select 'bcp cdoa..' + name + ' out e:\temp\cdoa\' + name + '.bcp ' + '-Usa -P -SYXZY -c' from sysobjects where type= 'U' and name not like '#%';
in
select 'bcp cdoa..' + name + ' in e:\temp\cdoa\' + name + '.bcp ' + '-Usa -Ptdhmaster -Syxspdb -c -T40960000 -m1000' from sysobjects where type= 'U' and name not like '#%';
01
单表备份与恢复BCP
备份数据库：dump database 数据库名 to 路径
dump database ecourt to '/dump/135/ecourtA.dmp‘
stripe on "/dump/135/ecourtB.dmp"
go
02
整个数据库的备份与恢复
还原数据库：load database 数据库名 from 路径
load database ecourt from '/dump/135/ecourtA.dmp‘
stripe on "/dump/135/ecourtB.dmp"
go
online database ecourt
go
03
整个数据库的恢复