What are the challenges you face when working across database platforms? Take the survey
Options

backing up to logical device

DBA72DBA72 Posts: 19
edited August 4, 2006 6:32AM in SQL Backup Previous Versions
I have one additional question about SQL Backup. Is it possible to back up to a logical backup device as you would with a native backup command? I don't see this talked abou in the documentation but want to be sure...

Comments

  • Options
    peteypetey Posts: 2,358 New member
    What do you mean by logical device? SQL Backup only supports backing up to disks.
    Peter Yeoh
    SQL Backup Consultant Developer
    Associate, Yohz Software
    Beyond compression - SQL Backup goodies under the hood, updated for version 8
  • Options
    Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
    I'm assuming you're talking about a virtual device? For instance a single disk file that can hold many database backups...

    SQL Backup doesn't allow you to backup to a virtual device because it is already implemented that way: it creates a temporary virtual device and backs up to it, then destroys the virtual device. For this reason, a group of SQL Backups couldn't be done into one virtual device.

    I hope this answers your question!
  • Options
    for a description of what a logical backup device is. It is under Backup Devices > Overview.

    But thanks to you both, I think you've answered my question: It is not possible.
Sign In or Register to comment.