The dump command includes two options that allow you to compress databases and transaction logs using Backup Server, thereby reducing your space requirements.
Compression levels are 0-9 and 100,101
Below image refers the backup file size depends on the compression level.
level 9 provides the highest compression ratio but also the heaviest CPU usage.
100 – the SAP ASE server uses FastLZ compression. The compression ratio that uses the least CPU usage; generally used for shorter data.
101 – the SAP ASE server uses FastLZ compression. A value of 101 uses slightly more CPU than a value of 100, but uses a better compression ratio than a value of 100.
Let’s use with compression in a single dump file command:
dump database PID to “/sybase/dumps/PID.dmp” with compression = 9
PID = database name
Syntax for striped backup with compression:
Path: local file system path, where you want to store your backup files.
Example : /sybase/dumps/
No comments:
Post a Comment