Backing up to a Tape Drive

I am setting up a new SQL Server that has an external HP 920 SAS Ultrium tape drive attached to it via a p400 sas card.

I am running 2003 R2 x64 with 2005 SQL Server x64, and I am trying to set up my DB backup plan but for some reason I can't get SQL to recognize my tape drive, alhough it is listed in device manager.

Anyone have any thoughts? I'm kind of stumped.

Thanks in advance,

Mark.

What do you mean SQL Server doesn't recognise it?

It's not listed in the dropdown when you try to create a new backup device in SQL Server Management Studio.|||

Sorry ... Yes when trying to add it as a new backup device in Management Studio.

Also I have SP2 installed.

|||

Not sure - maybe there's a problem with the compatibility of the drive. I don't know if there might be a problem if the drive wasn't attached and switched on when SQL Server started up.

It is worth trying to run the SQL

EXEC sp_addumpdevice 'tape', 'DumpToTape', '\\.\tape0'

Assuming that it is the first tape device in the machine.

Sorry you are running off the limit of my knowledge.

|||

I did that before I started the thread, but i must have done it incorrectly because when i ran it just now it created the device under backup devices and I am now all set.

Thanks for the help.

|||

Sorry , I have already added to DumpDevice. but The Error is represent.

would u tell me what to do ? it is SQL Server 2005 X64 Bug ?

thanks