471,108 Members | 1,695 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,108 software developers and data experts.

SQL Serwer 2005 + HP LTO Ultrium

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
Mar 1 '07 #1
1 3233
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
Mar 1 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.