SQL 2005 NOT recognize the tape drive

[Former Member]

I have a SQL 2005 Server (SP1) running on Windows 2003 server machine. Now windows can detect the tape drive attached to the system as 'HP StorageWorks DLT VS160'. Even 'ntbackup' detects it and is able to backup data to the tape drive. However, SQL Server is unable to detect the tape drive. The tape does not show up in the Backup Devices in Server Objects and hence I'm unable to take backups directly to the tape via SQL Server. How do I get SQL 2005 to recognize the tape drive

[Former Member]

Hello

just followed this steps and tape diver

goto

MS SQL Server/sQL Server management studio

connect

through Enterprise manager

and add tape drive with value 0

Edited by: Jayesh Patil on Jul 9, 2008 12:52 PM

[JPReyes]

This is harly a SAP question and more a MSSQL issue... anyhow as far as i remember you need to add backup device via Enterprise manager in order to be able to use it....

Regards

Juan