Use dump database and load database to dump to or from an archive device for in-memory and relaxed-durability databases. Dumping and loading in-memory or relaxed-durability databases requires no special parameters for the dump or load commands.
load database into an in-memory database loads the data directly into the in-memory storage cache.
You can:
Dump and load databases across durability levels. For example, you can dump a database with a durability level of full to an in-memory database, which always has a durability level of no_recovery
Perform dumps and loads across platforms.
You cannot:
Perform dump transaction from in-memory or relaxed-durability databases because load transaction cannot perform required tasks using a transaction log that may contain log records that are not ordered.
Load a dump from a database with durability set to no_recovery or at_shutdown into a version of Adaptive Server that does not support in-memory or relaxed-durability databases. However, you can load a database dump from an earlier version of Adaptive Server in to an in-memory or relaxed-durability database.
You must use the version of Backup Server that ships
with the version of Adaptive Server you use to dump and load in-memory
or relaxed-durability databases.
