Dump DB with compression level
Sybase ASE  

Dump DB with compression level

We have covered dump database to a single file and multiple files in the post Improve performance of DB Backup timing by more than 50% and also witnessed how we can save storage by more than 85% in the post Backup compression – save storage 85%(up to) without compromising duration. As we had discussed in this post regarding compress option while taking backup and since this has been deprecated by SAP, there is a different syntax for the same configuration.

Lets use with compression in a single dump file command:

dump database db_name to “/path/db_name_dump.bak” with compression = 5

Alternatively, this can also be used within double quotes as below”

dump database db_name to “/path/db_name_dump.bak” with compression = “5”

Now, We shall use with compression in the striped backup. Command for striped backup with compression will be as follows:

dump database db_name to
“/path/db_name_dump_comp_1.bak” stripe on
“/path/db_name_dump_comp_2.bak” stripe on
“/path/db_name_dump_comp_3.bak” stripe on
“/path/db_name_dump_comp_4.bak” with compression = 5

Alternatively same can be written within double quotes as below:

dump database db_name to
“/path/db_name_dump_comp_1.bak” stripe on
“/path/db_name_dump_comp_2.bak” stripe on
“/path/db_name_dump_comp_3.bak” stripe on
“/path/db_name_dump_comp_4.bak” with compression = “5”

We shall do a detailed post on compression level and their impact on backup timing as well as storage.

Please leave your comment if you liked this post or have any feedback.

Leave A Comment