Use the load database command to load the backup created with dump database. You can load the dump into a preexisting database or create a new database with the for load option. When you create a new database, allocate at least as much space as was allocated to the original database.
WARNING! You cannot load a dump that was made on a different platform or generated on pre-version 10.0 SQL Server. If the database you are loading includes tables that contain the primary keys for tables in other databases, you must load the dump into a database with the same database name as the one dumped.
The load database command sets the database status to “offline.” This means you do not have to use the no chkpt on recovery, dbo use only, and read only options of sp_dboption before you load a database. However, no one can use a database during the database load and subsequent transaction log loads. To make the database accessible to users, issue the online database command.
After the database is loaded, Adaptive Server may need to:
“Zero” all unused pages, if the database being loaded into is larger than the dumped database.
Complete recovery, applying transaction log changes to the data.
Depending on the number of unallocated pages or long transactions, this can take a few seconds or many hours for a very large database. Adaptive Server issues messages that it is “zero-ing” pages or has begun recovery. These messages are normally buffered; to see them, issue:
set flushmessage on
