Specifying Dump Devices

Usage information for specifying dump devices.

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

  • You cannot dump to the null device (on UNIX, /dev/null ).

  • Dumping to multiple stripes is supported for tape and disk devices. Placing multiple dumps on a device is supported only for tape devices.

  • You can specify a local dump device as:
    • A logical device name from the sysdevices system table

    • An absolute path name

    • A relative path name

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

  • When dumping across the network, you must specify the absolute path name of the dump device. The path name must be valid on the machine on which Backup Server is running. If the name includes any characters except letters, numbers, or the underscore (_), you must enclose it in quotes.

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

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