Unanswered: How do I recover database from a detached backup device?
I ran into a problem today where I had to pull a backup file from an older tape. The file was originally is a backup that was stored in a device like :
'c2000_BackupDevice', --logical name
'\\UNCPath\backupFile.bak' --physical location
I put the file from the tape on a File Server and then tried to create a new backup device pointing to the file. That's easy enough, but when I try to restore from it I get an device error saying it's offline.
How can I get that device attached to my server and then extract the backup files stored inside it?
Please advise b/c this is an interesting problem I hadn't anticipated and it argues that I should change my backup strategy .