Chapter 12: Backing Up and Restoring User Databases

Volume change prompts for loads

Following are the volume change prompts and possible operator actions during loads:

Dumpfile 'fname' section vname found instead of 'fname' section vname.

The Backup Server issues this message if it cannot find the specified file on a single-file medium.

The operator can	By replying
Abort the load	`sp_volchanged session_id, session_id, abort`
Mount another volume and try to load it	`sp_volchanged session_id, session_id, retry[, session_id[, session_id]]`
Load the file on the currently mounted volume, even though it is not the specified file (not recommended)	`sp_volchanged session_id, session_id, proceed[, session_id[, session_id]]`

Mount the next volume to read.

The Backup Server issues this message when it is ready to read the next section of the dump file from a multivolume dump.

The operator can	By replying
Abort the load	`sp_volchanged session_id, session_id, abort`
Mount the next volume and proceed with the load	`sp_volchanged session_id, session_id, proceed[, session_id[, session_id]]`

Mount the next volume to search.

The Backup Server issues this message if it cannot find the specified file on multifile medium.

The operator can	By replying
Abort the load	`sp_volchanged session_id, session_id, abort`
Mount another volume and proceed with the load	`sp_volchanged session_id, session_id, proceed[, session_id[, session_id]]`