Sybase ASE – Dump/Load a database to/from multiple stripes

Following command can be used to dump a Sybase ASE database into multiple stripes:-

dump database  to 'compress::<dumpfile_path_and_filename>_01.dmp'
stripe on 'compress::<dumpfile_path_and_filename>_02.dmp'
stripe on 'compress::<dumpfile_path_and_filename>_03.dmp'
stripe on 'compress::<dumpfile_path_and_filename>_04.dmp'
stripe on 'compress::<dumpfile_path_and_filename>_05.dmp'
stripe on 'compress::<dumpfile_path_and_filename>_06.dmp'
stripe on 'compress::<dumpfile_path_and_filename>_07.dmp'
stripe on 'compress::<dumpfile_path_and_filename>_08.dmp'
stripe on 'compress::<dumpfile_path_and_filename>_09.dmp'
stripe on 'compress::<dumpfile_path_and_filename>_10.dmp'
go

Following command can be used to load a Sybase ASE database from multiple stripes:-

load database  from 'compress::<dumpfile_path_and_filename>_01.dmp'
stripe on 'compress::<dumpfile_path_and_filename>_02.dmp'
stripe on 'compress::<dumpfile_path_and_filename>_03.dmp'
stripe on 'compress::<dumpfile_path_and_filename>_04.dmp'
stripe on 'compress::<dumpfile_path_and_filename>_05.dmp'
stripe on 'compress::<dumpfile_path_and_filename>_06.dmp'
stripe on 'compress::<dumpfile_path_and_filename>_07.dmp'
stripe on 'compress::<dumpfile_path_and_filename>_08.dmp'
stripe on 'compress::<dumpfile_path_and_filename>_09.dmp'
stripe on 'compress::<dumpfile_path_and_filename>_10.dmp'
go


One thought on “Sybase ASE – Dump/Load a database to/from multiple stripes

  1. Pingback: Sybase ASE | Oracle Database Internal Mechanism

Leave a comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.