we are trying to restore one of our datebase from tape using the T-Sql commands. Using the GUI results in an timeout.
The command we are using to start the restore is:
RESTORE DATABASE RECOV FROM Tape = '\\.\tape0' WITH FILE=2, RECOVERY, NOUNLOAD, STATS=5,
MOVE 'xxx_OPL_xxxx_ZEELAND' TO 'K:\RECOVER\data\RECOV.mdf',
MOVE 'xxx_OPL_xxxx_ZEELAND' TO 'K:\RECOVER\log\RECOV_log.ldf',
the restore proces start without any problem, only ending with this:
Processed 2598808 pages for database 'xxx_OPL_xxxx_ZEELAND', file 'xxxx_PROD_Data' on file 2.
Processed 3 pages for database 'xxxx_OPL_xxxx_ZEELAND', file 'xxxx_PROD_Log' on file 2.
Msg 3229, Level 16, State 2, Line 1
Request for device '\\.\tape1' timed out.
Msg 3213, Level 16, State 1, Line 1
Unable to unload one or more tapes. See the error log for details.
Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.
In the eventlog, the following is recorded:
BackupTapeFile::UnloadTape: PrepareTape(UNLOCK) failure on backup device '\\.\tape0'. Operating system error 21(The device is not ready.).
For as far we can judge, the tapedrive is functioning without problems.
Using the same tape in an other tapedrive on an different server results in the same error.
HP Proliant Server (DL580) with additional SCSI interface card
HP StorageWorks LTO 4 tapedriv
View Complete Post