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:
load database dbname from dump_device [ [stripe on stripe_device] ... ] [with [norecovery][, passwd=password]
Where:
dbname – 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 was introduced in Adaptive Server version 12.5.4 and 15.0.2 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 database dump into an archive database.