Sybase ASE – Read a dumpfile with headeronly

We can use the “headeronly” qualifier when reading a dumpfile to extract useful information which we can use to work out what is needed to setup a new database to load the given dump file. Using following command to read the dumpfile:- load database headerfrom “compress::<dumpfile_path_and_name>”with headeronlygo This would generate a output something like:- Backup…

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…

Sybase ASE – Rename a Database

In the following article we would rename a Sybase ASE DB named ABC to DEF. In order to rename the database we need to set the database in single user mode, by using the following command:- sp_dboption ‘ABC’,’single user’,truegouse ABCgocheckpointgo Once the DB is set to single user mode, we would call the sp_renamedb procedure…