SQL Serwer 2005 + HP LTO Ultrium

[Leszekwl]

Hi
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 ??

Regards

Leszek

[Erland Sommarskog]

Leszekwl (Le******@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, es****@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx