Use this syntax for sp_volchanged:
sp_volchanged session_id, devname, action [ ,fname [, vname ] ]
Use the session_id and devname parameters specified in the volume change request.
action specifies whether to abort, proceed with, or retry the dump or load.
fname specifies the file to load. If you do not specify a file name, Backup Server loads the file = file_name parameter of the load command. If neither sp_volchanged nor the load command specifies which file to load, the Backup Server loads the first file on the tape.
The Backup Server writes the vname in the ANSI tape label when overwriting an existing dump, dumping to a brand new tape, or dumping to a tape whose contents are not recognizable. During loads, the Backup Server uses the vname to confirm that the correct tape has been mounted. If you do not specify a vname, the Backup Server uses the volume name specified in the dump or load command. If neither sp_volchanged nor the command specifies a volume name, the Backup Server does not check this field in the ANSI tape label.
| Copyright © 2005. Sybase Inc. All rights reserved. |
|
|
