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.
| Author |
Topic |
|
uxpme
Starting Member
5 Posts |
 Posted - 2008-02-05 : 13:16:11
|
| 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? |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-02-05 : 22:27:53
|
| Is it attached to sql server directly? |
 |
|
|
uxpme
Starting Member
5 Posts |
Posted - 2008-02-06 : 06:14:39
|
| Actually, I've got two servers confugured in active-passive windows clustering and not SQL Clustering. The tape drive is conected to these. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-02-07 : 00:18:41
|
| Is sql running on node that has tape drive attached? |
|
|
|
uxpme
Starting Member
5 Posts |
Posted - 2008-02-07 : 11:45:51
|
| Yes. Like I said, I can use 'NTBACKUP' to backup to the tape, but I'm not able to backup directly from SQL Server to the tape. |
|
|
|
beginoffile
Starting Member
1 Post |
Posted - 2008-04-19 : 00:22:17
|
| I had the same problem. Windows 2003 server detect the tape. But SqlServer 2005 not able to backup directly. Help!!Hello |
|
|
|
|
|
|
Tape Drive not detected