Sybase (prior to version 12) has a 2 GB dump file size limitation for most
platforms. Getting around this is easy - simply stripe the dumps across multiple
files or devices. The examples below use file names instead of device names.
dump database hr_db to '/usr2/dumps/remote/db_hr05121318.dmp'
stripe on '/usr2/dumps/remote/db_hr_S1_05121318.dmp'
stripe on '/usr2/dumps/remote/db_hr_S2_05121318.dmp'
go
load database hr_db from '/usr2/dumps/remote/db_hr05121318.dmp'
stripe on '/usr2/dumps/remote/db_hr_S1_05121318.dmp'
stripe on '/usr2/dumps/remote/db_hr_S2_05121318.dmp'
go
online database hr_db
go
|
|
