Loading databases and transaction logs dumped with compress option

If you use dump ... compress to dump a database or transaction log, you must load this dump using the load ... compress option.

The partial syntax for load database ... compress and load transaction ... compress is:

load database database_name 
from compress::stripe_device
…[stripe on compress::stripe_device]…

load transaction database_name 
from compress::stripe_device
…[stripe on compress::stripe_device]…

The database_name in the syntax is the database you archived, and compress:: invokes the decompression of the archived database or transaction log. archive_name is the full path to the archived database or transaction log that you are loading. If you did not include a full path when you created your dump file, Adaptive Server created a dump file in the directory in which you started Adaptive Server.

Use the stripe on clause if you compressed the database or transaction log using multiple dump. See “Specifying additional dump devices: the stripe on clause” for more information about the stripe on clause.

Do not use the compression_level variable for the load command.

Example

load database pubs2 from 
	"compress::/opt/bin/Sybase/dumps/dmp090100.dmp"

Backup Server session id is:  19.  Use this value when executing the 'sp_volchanged' system stored procedure after fulfilling any volume change request from the Backup Server.
Backup Server: 4.132.1.1: Attempting to open byte stream device: 'compress::/opt/bin/Sybase/dumps/dmp090100.dmp::00'
Backup Server: 6.28.1.1: Dumpfile name 'pubs2002620A951  ' section number 1 mounted on byte stream 'compress::/opt/bin/Sybase/dumps/dmp090100.dmp::00'
Backup Server: 4.58.1.1: Database pubs2: 1382 kilobytes LOADed.
Backup Server: 4.58.1.1: Database pubs2: 3078 kilobytes LOADed.
Backup Server: 4.58.1.1: Database pubs2: 3086 kilobytes LOADed.
Backup Server: 3.42.1.1: LOAD is complete (database pubs2).
Use the ONLINE DATABASE command to bring this database online; SQL Server will not bring it online automatically.

For complete syntax information about load database and load transaction, see the Reference Manual.