Unable to access backup file. Error msg

Undo for SQL Server.

Moderator: eddie davis

Unable to access backup file. Error msg

Postby BitPail » Wed Oct 31, 2007 5:28 pm

When trying to choose backup files, I get a list of table entries but beside each one of them I get "Unable to access backup file" and the message: "Backups from the database may be specified using path names that are inaccessible from this host. Manually update these paths if the backups are required."

The problem is I have no idea where these files are. The file names look like this:

DATABASENAME_00_88ebb5d4_4440_433a_a3b8_f9688f2af9b8_

But I have no idea where that file is, I only know where the ldf files are.

I'm using a SQL Server 2000 db on a remote machine. I've even tried installing the software on the same server as the remote machine with the admin account, but I get the same error.

Can anyone help me on this matter?
BitPail
 
Posts: 1
Joined: Wed Oct 31, 2007 5:12 pm

Postby Chris Auckland » Mon Nov 05, 2007 11:27 pm

Thanks for your post.

The most likely reason you are getting this problem is because the backup files are no longer in the same place as they were when the backup was originally taken. The location reported when querying the backup history will only show you where SQL Server believes the files to be, not necessarily where they actually are now.

Assuming that the backups haven't also been renamed, you could try doing a search on the server for the file names you know and see if that can find them for you.

I hope this is helpful.
Chris
Chris Auckland
 
Posts: 757
Joined: Tue Oct 24, 2006 2:12 pm
Location: Red Gate Software Ltd.


Return to SQL Log Rescue

Who is online

Users browsing this forum: No registered users and 1 guest