Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2003
    Posts
    46

    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 :
    Code:
    EXEC sp_addumpdevice 
    	'disk', 		   --type
    	'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 .

    Thanks for any advice/experience you can provide,

    alex8675

  2. #2
    Join Date
    Nov 2003
    Location
    London
    Posts
    169
    have you checked the permissions on the file server?

  3. #3
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,799
    Provided Answers: 11
    Can the SQL Server service account get to that UNC path? Perhaps you should move the backup file to the local machine, and just restore it from there.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •