Specifying Dump Devices

You can specify the dump device as a literal, a local variable, or a parameter to a stored procedure.

When loading from a local device, you can specify the dump device as:
  • An absolute path name

  • A relative path name

  • A logical device name from the sysdevices system table

Backup Server resolves relative path names, using the current working directory in the SAP ASE server.

When loading across the network, specify the absolute path name of the dump device. (You cannot use a relative path name or a logical device name from the sysdevices system table.) The path name must be valid on the machine on which the Backup Server is running. If the name includes any characters other than letters, numbers or the underscore (_), you must enclose it in quotes.

Ownership and permissions problems on the dump device may interfere with use of load commands. sp_addumpdevice adds the device to the system tables, but does not guarantee that you can load from that device or create a file as a dump device.

You can run more than one load (or dump) at the same time, as long as each one uses a different physical device.