I dumped a database to a dlt drive this morning, with a stripe on a second
dlt drive. This is on an 11.5.1 system, Adaptive Server
Enterprise/11.5.1/P/HP9000-800/HP-UX 10.0/SWR 8305 Rollup /opt/Sat Feb 6
19:20:32 PST 1999, migrating to a 12.0 conversion instance.
I tried to perform another dump this afternoon and got an error message:

May 8 08:47:57 2001: Backup Server: 6.45.1.1: Be sure to remove the
tape/floppy from drive /dev/rmt/2mn (server: , session id: 78).
May 8 08:47:57 2001: Backup Server: 6.45.1.1: Be sure to remove the
tape/floppy from drive /dev/rmt/8mn (server: , session id: 78).
May 8 08:47:57 2001: Backup Server: 3.42.1.1: DUMP is complete (database
DBSjepc).
May 8 12:46:35 2001: Backup Server: 4.55.2.1: Device validation error:
couldn't open raw device /dev/rmt/2mn, error: No such device or address
May 8 12:54:30 2001: Backup Server: 4.55.2.1: Device validation error:
couldn't open raw device /dev/rmt/2mn, error: No such device or address

Notice that at 8:47 the drive was seen by the operating system. I was able
to sucessfully recover the database dumped at 8:47 into the 12.0 server
using this command:

isql -Usa -Ssybrpaul -Ppaulquel -o/home/sybrpdq/scott/jepc_load.out <<EOF
load database DBSjepc
from dlttape2 dumpvolume = jepc1,
file = dbsjepc_file1
stripe on dlttape8 dumpvolume = jepc2,
file = dbsjepc_file2 with unload
go
online database DBSjepc
go
EXEC sp_dboption 'DBSjepc','select into/bulkcopy/pllsort',true
go
EXEC sp_dboption 'DBSjepc','trunc log on chkpt',true
go
USE DBSjepc
go
checkpoint
go
EOF

Have I missed something here? Should I issue a dismount command along with
the 'with unload' command? Should I physically remove the tapes and
re-insert them?

TIA
Scott