Options

Backup to tape directly

antoniocaldeiraantoniocaldeira Posts: 3
edited October 1, 2005 9:51AM in SQL Backup Previous Versions
Hi,

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

Thanks,

Antonio Caldeira
· Share on Twitter

Comments

  • Options
    Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
    Hello Antonio,

    This version of SQL Backup can only write to disk. It cannot stream directly to tape like native SQL Server backups.
    · Share on Twitter
  • Options
    antoniocaldeiraantoniocaldeira Posts: 3
    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
    · Share on Twitter
  • Options
    JamesknJameskn Posts: 4
    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 ;-)
    · Share on Twitter
  • Options
    Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
    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.
    · Share on Twitter
Sign In or Register to comment.