When you use a universal serial bus (USB)-based tape drive as a
backup device on a computer that is running Microsoft SQL Server 2000 or Microsoft
SQL Server 2005, you cannot specify the USB-based tape drive as a backup device in SQL Enterprise Manager or in SQL Server Management Studio.
This issue occurs because the
xp_get_tape_devices stored procedure does not
recognize the registry key of the USB device. The
xp_get_tape_devices stored procedure checks for usable tape devices.
The
xp_get_tape_devices stored procedure accesses the following backup device registry
subkey:
HKEY_LOCAL_MACHINE\HARDWARE\DEVICEMAP\Scsi
The USB backup device is stored under the following registry subkey:
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Enum\USB
To work around this issue, follow these steps:
| 1. | Use the following Transact-SQL statement to register the
USB-based tape device:USE master
go
EXEC sp_addumpdevice 'tape', 'tapedump1','\\.\Tape0'
|
| 2. | Use a Backup Database Transact-SQL statement to back up a database. For example, use a Backup Database Transact-SQL statement such as the following: USE <myDatabase>
go
Backup Database <myDatabase>
TO tapedump1
|
Microsoft
has confirmed that this is a problem in the Microsoft products that are listed
in the "Applies to" section.
Steps to reproduce the problem
SQL Server 2005
| 1. | In SQL Server Management Studio, expand Server
Objects. |
| 2. | Right-click Backup Devices, and then click
New Backup Device.
|
Notice that you cannot select the
Tape option under
Destination.
SQL Server 2000
| 1. | In SQL Server Enterprise Manager, expand
Management. |
| 2. | Right-click Backup, and then click
New Backup Device. |
Notice that you cannot select
Tape drive
name in the
Backup Device Properties dialog
box.
