- 论坛徽章:
- 0
|
平台1:安腾64位小机,安装了SYBASE 1253 64位 FOR 安腾64,
平台2:因特尔64位HP380,安装了SYBASE 1253 64 FOR inter X86
在平台1上:
isql -Usa -P -SSYBASE
dbcc checkdb("ksqhdb")
go
use master
go
sp_dboption ksqhdb,"single user",true
go
use ksqhdb
go
sp_flushstats
go
checkpoint
go
use master
go
dump database ksqhdb to 'compress::6::/backup/ksqhdb_at_part1.c6dmp' stripe on 'compress::6::/backup/ksqhdb_at_part2.c6dmp' stripe on 'compress::6::/backup/ksqhdb_at_part3.c6dmp' stripe on 'compress::6::/backup/ksqhdb_at_part4.c6dmp'
go
sp_dboption ksqhdb,"single user",false
go
然后把备份文件拿到平台2上去
load database ksqhdb from 'compress::6::/backup/ksqhdb_at_part1.c6dmp' stripe on 'compress::6::/backup/ksqhdb_at_part2.c6dmp' stripe on 'compress::6::/backup/ksqhdb_at_part3.c6dmp' stripe on 'compress::6::/backup/ksqhdb_at_part4.c6dmp'
go
online database ksqhdb
go
sp_post_xpload
go
这样做行吗?恳请大侠们给意见 |
|