Sybase 大数据切分备份和恢复

最这几天的测试,采用分片备份的方式进行,我把,60G的设备文件,分成20个文件,备份的速度只用了2个多小时的样子,快了几倍。。。。。呵呵,谢谢,前辈的指点。。。
后来,担心备份的不能恢复,用了半天的时间,进行了数据的恢复,成功了!
语法如下:
dump database test to 'g:\dmp1\test.dmp0' at BACKUP_BS
stripe on 'g:\dmp1\test.dmp1' at BACKUP_BS
stripe on 'g:\dmp1\test.dmp2' at BACKUP_BS
stripe on 'g:\dmp1\test.dmp3' at BACKUP_BS
stripe on 'g:\dmp1\test.dmp4' at BACKUP_BS
stripe on 'g:\dmp1\test.dmp5' at BACKUP_BS
stripe on 'g:\dmp1\test.dmp6' at BACKUP_BS
stripe on 'g:\dmp1\test.dmp7' at BACKUP_BS
stripe on 'g:\dmp1\test.dmp8' at BACKUP_BS
stripe on 'g:\dmp1\test.dmp9' at BACKUP_BS
stripe on 'g:\dmp1\test.dmp10' at BACKUP_BS
stripe on 'g:\dmp1\test.dmp11' at BACKUP_BS
stripe on 'g:\dmp1\test.dmp12' at BACKUP_BS
stripe on 'g:\dmp1\test.dmp13' at BACKUP_BS
stripe on 'g:\dmp1\test.dmp14' at BACKUP_BS
stripe on 'g:\dmp1\test.dmp15' at BACKUP_BS
stripe on 'g:\dmp1\test.dmp16' at BACKUP_BS
stripe on 'g:\dmp1\test.dmp17' at BACKUP_BS
stripe on 'g:\dmp1\test.dmp18' at BACKUP_BS
stripe on 'g:\dmp1\test.dmp19' at BACKUP_BS
go

恢复用:
load  database test from 'g:\dmp1\test.dmp0' at BACKUP_BS
stripe on 'g:\dmp1\test.dmp1' at BACKUP_BS
stripe on 'g:\dmp1\test.dmp2' at BACKUP_BS
stripe on 'g:\dmp1\test.dmp3' at BACKUP_BS
stripe on 'g:\dmp1\test.dmp4' at BACKUP_BS
stripe on 'g:\dmp1\test.dmp5' at BACKUP_BS
stripe on 'g:\dmp1\test.dmp6' at BACKUP_BS
stripe on 'g:\dmp1\test.dmp7' at BACKUP_BS
stripe on 'g:\dmp1\test.dmp8' at BACKUP_BS
stripe on 'g:\dmp1\test.dmp9' at BACKUP_BS
stripe on 'g:\dmp1\test.dmp10' at BACKUP_BS
stripe on 'g:\dmp1\test.dmp11' at BACKUP_BS
stripe on 'g:\dmp1\test.dmp12' at BACKUP_BS
stripe on 'g:\dmp1\test.dmp13' at BACKUP_BS
stripe on 'g:\dmp1\test.dmp14' at BACKUP_BS
stripe on 'g:\dmp1\test.dmp15' at BACKUP_BS
stripe on 'g:\dmp1\test.dmp16' at BACKUP_BS
stripe on 'g:\dmp1\test.dmp17' at BACKUP_BS
stripe on 'g:\dmp1\test.dmp18' at BACKUP_BS
stripe on 'g:\dmp1\test.dmp19' at BACKUP_BS

go
  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值