Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 backup device for tape not possible

Author  Topic 

kriki
Starting Member

14 Posts

Posted - 2007-05-17 : 08:34:07
I want to create a backup device for the tape drive.
So I go in "Server Objects"=>"Backup Devices" and create a new device. Problem is: In "Destination" I can't select "Tape:".

The ntbackup.exe program recognizes the tape drive, but SQL2005 not.

I have this:
-SQL2005 Enterprise edition 64bit.
-Tape drive HP StorageWorks Ultrium 960.

Someone knows how I can create a backupdevice for the tape?

Thanks

IF Debugging = removing bugs from program THEN programming := putting bugs in program;

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-05-17 : 09:50:54
Does tape drive attach to sql server?
Go to Top of Page

kriki
Starting Member

14 Posts

Posted - 2007-05-17 : 10:44:20
It is attached to the computer, but SQL2005 doesn't recognize it. NTbackup sees the tape.

IF Debugging = removing bugs from program THEN programming := putting bugs in program;
Go to Top of Page

kriki
Starting Member

14 Posts

Posted - 2007-05-24 : 07:42:24
We used a TSQL-statement to restore the DB but SQL2005 still doesn't recognize the tape.

IF Debugging = removing bugs from program THEN programming := putting bugs in program;
Go to Top of Page

nheidorn
Starting Member

28 Posts

Posted - 2007-05-24 : 11:02:10
Is your tape drive USB? This article explains how to manually register a tape drive:

[url]http://support.microsoft.com/kb/927797/en-us[/url]
Go to Top of Page
   

- Advertisement -