The compression parameter of the dump command allows you to reduce your space requirements for your archived databases. Earlier versions of dump database using the compression API allowed you only to compress your database dumps to a local file. With Adaptive Server 12.5.2, the compression parameter enables you to compress your dumps to a remote machine.
You need not include the compression level when you load the database dump. However, you can issue load with listonly=full to determine the compression level at which the dump was made.
The partial syntax for dump database is:
dump database database_name to file_name [ with compression = compress_level]
where:
database_name – is the name of the database from which you are copying data. The database name can be specified as a literal, a local variable, or a stored procedure parameter.
file_name – is the name of the dump file. The name cannot exceed 17 characters, and must conform to operating system conventions for file names.
compress_level – is a number between 1 and 9, with 9 providing the highest level of compression. There is no default compression level; if you do not specify a compress_level, Adaptive Server does not compress the dump.
For example, the following dumps the pubs2 database to the remote machine called “remotemachine” and uses a compression level of 4:
dump database pubs2 to “/Syb_backup/mydb.db” at remotemachine with compression = “4”
| Copyright © 2005. Sybase Inc. All rights reserved. |
|
|
