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
3 comments
-
What do you mean by logical device? SQL Backup only supports backing up to disks.
-
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! -
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.
Add comment
Please sign in to leave a comment.