Backup to tape directly

antoniocaldeira

Hi,

It's possible execute sql backup command to tape directly?

Thanks,

Antonio Caldeira

Brian Donahue

Hello Antonio,

This version of SQL Backup can only write to disk. It cannot stream directly to tape like native SQL Server backups.

antoniocaldeira

Brian Donahue wrote:

Hello Antonio,

This version of SQL Backup can only write to disk. It cannot stream directly to tape like native SQL Server backups.

Hello Brian,

Thanks for Information

Jameskn

I use a rev drive .. works like a dream ;-) Have been using now for a couple of weeks... Can swap rev drives in and out. ;-) So exactly like tape system. If you are wondering what to buy that fits with the software.

HTHS ?

James

Rev drive link
http://www.iomega-europe.com/eu/en/prod ... ly_en.aspx

P.S I dont work for Iomega either ;-)

Brian Donahue

Thanks James!

Certainly tape drives are not the only viable backup solution. Removable disk, DVD-R, and SANs are also good alternatives.

The thing that sets tape apart from these is that tape drives are sequential block-writing devices unlike hard disks, which support random block access. For this version of SQL Backup at least, it would be impossible for the software to support sequential devices, although I believe we are working on some support for them.