SQL 2000: Tape drive not recognized trouble

Question

We have a windows 2003 server edition installed on a DELL server and it also runs MS SQL server 2000. 

 

We have a HP LTO 2 tape drive on the dell server and it works as it should. We have run ntbackup is used at the command prompt and it worked fine.

 

Strange part is that, the SQL enterprise manager does not recognize the tape drive. 

 

The tape drive is installed properly as the device manager does not show any error and ntbackup also recognizes it.

 

I can’t seem to figure out why SQL server 2000 cannot recognize the tape drive.

 

Much appreciate your kind help on this, its driving me crazy why it doesn’t recognize the tape.

 

Regards,

Tito Rodriguez

 

Answer 1

Hi Tito,

Try to create a logical backup device for your tape device.
open Query analyzer and run
USE master
EXEC sp_addumpdevice 'tape', 'tapename',
   '\\.\tape'
Where tapedump1 is the logical name for your tape drive, and \\.\tape  is the physical path in your tape drive.
  You should use values for these parameters as appropriate to your case.
And also try this manually
BACKUP DATABASE MyDatabase TO TAPE = '\\.\Tape' WITH FORMAT, NAME = 'My Backup Name';

Then i think you will be able to use the logical device as a destination for your backups.Try these and let us know what's happening here..

 

---

Thanks, Leks