Posted by Erland Sommarskog on 03/01/07 11:31

Leszekwl (Leszekwl@gazeta.pl) writes:
> My company buys new server( HP Proliant ML 570 with
> HP LTO ULTRIUM 232 Tape Drive. OS (Windows 2003 Enterprise - SP1) see it
> correctly (nt backup works, diagnostic tools
> don't report problems) But SQL Server 2005 - SP1 don't see this tape
> drive ( MS SQL Server Management Studio > Backup Devices is empty and
> I can't add new Tape Backup Device (this option is unavaible). Also
> sys.backup_devices and sys.dm_io_backup_tapes show nothing.
> Have You any advices how to resolve this problem ??

You add a backup device with sp_addumpdevice.

But it should work also if you say

BACKUP DATABASE db TO TAPE = 'windowsnameoftapedevice'

I don't think it's very common these days to backup databases directly to
tape. I am under the impression that most people back up the database to
disk, and the uses NT Backup to get that file on tape if needed.

--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[Back to original message]