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 Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

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