Tape Libraries and Drives
cancel
Showing results for 
Search instead for 
Did you mean: 

USB Dat Drive not visible in SQL Server

Support User
Occasional Visitor

USB Dat Drive not visible in SQL Server

Hi

We have a windows 2003 server which has an HP USB DAT72 drive attached using version 1.5.3.1 of the driver.

The drive can be backed up to and restored from using windows backup, and is visable in device manager but it is not visable to SQLServer 2005 so I cannot add it as a new backup device.

Any suggestions as to why this may happen or a solution to the problem?

The server has been rebooted since the drive was attached.

Many thanks

Mark
1 REPLY
Jaclyn Rothe
Trusted Contributor

Re: USB Dat Drive not visible in SQL Server

USB Tpae drives are not USB removable devices. You will only ever see them in Device Manager, and need a backup software to backup to the device.

What I understand youa re trying to do, is use SQLServer 2005 to move data to a tape like a floppy disk or USB storage device (jump drive).

If this is the case, it won't work that way.