You are here: Re: SQL Serwer 2005 + HP LTO Ultrium « MsSQL Server « IT news, forums, messages
Re: SQL Serwer 2005 + HP LTO Ultrium

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

 

Navigation:

[Reply to this message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация