An archive database is a placeholder that is useful only once it has been loaded with a database dump. The load process does not actually copy pages, however, it materializes the database using page mapping.
Use the load database command to materialize an archive database. The syntax is:
load database <db name> from <dump device> [ [stripe on <stripe device>] ... ] [with [norecovery,][passwd=<password>]
where:
db name – specifies the name of the archive database into which you want to load.
dump device – specifies the name of the disk database dump from which you want to load the dump.
stripe device – specifies additional disk database dump stripes.
norecovery – indicates that the load database command will not run recovery, and that the database is brought online automatically after the load database command has completed. For more information, see “Using load database with norecovery”.
norecovery has been introduced in
Adaptive Server version 12.5.4 for archive database access. You
cannot use norecovery on a traditional database.
passwd =<password> – must be specified if the dump from which you are loading the archive database is password-protected. The password must be between 6 and 30 characters long.
You do not need to have Backup Server running when loading
a dump into an archive database.