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.
I have discussed these options in my video SAP Sybase ASE DB Backup And Restoration
Please leave your comment if you liked this post or have any feedback.