1 Version 4.0 -- 1/15/89 sp_addumpdevice
______________________________________________________________________
NAME: sp_addumpdevice
FUNCTION:
Adds a dump device to SQL Server.
SYNTAX:
sp_addumpdevice {"tape" | "disk "}, logicalname, physicalname,
cntrltype [, skip | noskip ] [, media_capacity ]
EXAMPLES:
sp_addumpdevice "disk", mydiskdump, "/dev/rmt0", 3
sp_addumpdevice Version 4.0 -- 1/15/89 2
______________________________________________________________________
PARAMETERS:
{"tape" | "disk" } - is the type of dump device. Use "tape" for
adding any kind of tape dump device. Use "disk" for adding a
dump device. The words disk and tape must be enclosed in
quotes.
logicalname - is the logical name of the device, which is used
in the LOAD and DUMP commands.
physicalname - is the physical name of the device.
cntrltype - the controller number of the new device. The same
controller number can be used for more than one dump device-
different numbers are necessary only if you want to use more
than one device simultaneously.
For disk dump devices, the controller number parameter must
be 2. For tape dump devices, the controller number parameter
must be between 3 and 8.
3 Version 4.0 -- 1/15/89 sp_addumpdevice
______________________________________________________________________
[skip | noskip] - this parameter is relevant only when adding a
tape dump device. If no value is supplied, it defaults to
noskip. Including this parameter indicates that ANSI tape
labels should be ignored. It is useful in two cases.
The first case is that the device you are adding is a tape
that has never been written on and that therefore has no ANSI
label. At that point, SQL Server will write a new label.
Using the skip parameter prevents unnecessary retries.
In the second case, the dump device you are adding is a tape
with a warning on its ANSI label saying that (for example)
the tape is not expired, or that you don't have the appropri-
ate permissions to write to it. Using the skip parameter
causes SQL Server to ignore the warning.
In summary, sp_addumpdevice offers you a choice between the
sp_addumpdevice Version 4.0 -- 1/15/89 4
______________________________________________________________________
security of paying attention to ANSI labels and the conveni-
ence of ignoring them. In either case, SQL Server still
writes the labels.
media_capacity - for disk dump devices enter size in kilobytes.
1200K bytes (1.2 megabytes) is the default.
For tape dump devices, the tape capacity is specified in
megabytes. The console program prompts the operator to
change tapes when a database DUMP reaches the specified capa-
city of the tape.
COMMENTS:
o The sp_addumpdevice procedure adds a dump device to the
master.dbo.sysdevices table. It may then be referred to logi-
cally in the DUMP DATABASE, DUMP TRANsaction, LOAD DATABASE,
and LOAD TRANsaction commands.
5 Version 4.0 -- 1/15/89 sp_addumpdevice
______________________________________________________________________
o To add database devices to sysdevices, use the DISK INIT com-
mand.
MESSAGES:
The value supplied for the first parameter isn't a known device
type.
All SQL Server devices must have unique logical names. There is
already a device with the name supplied for the logicalname
parameter.
If the devtype is tape, you can specify that tape labels should
be ignored by using the skip option. Some other value was
supplied.
The disk dump device was added successfully.
When you are adding a disk dump device, the value for the fourth
parameter, cntrltype, must be 2.
When you are adding a tape dump device, the value for the fourth
parameter, cntrltype, must be 5, 6, 7, or 8.
sp_addumpdevice Version 4.0 -- 1/15/89 6
______________________________________________________________________
For disk dump devices enter the size in K bytes. 1200K bytes (1.2
megabytes) is the default. For tape dump devices, the tape
capacity is specified in megabytes. The console program
prompts the operator to change tapes when a database DUMP
reaches the specified capacity of the tape.
The tape dump device was added successfully.
PERMISSIONS:
Execute permission to System Administrator.
TABLES USED:
master.dbo.sysdevices
SEE ALSO:
sp_helpdevice, sp_dropdevice, DISK INIT, DUMP DATABASE, DUMP
TRANsaction, LOAD DATABASE, LOAD TRANsaction