Community
Showing results for 
Search instead for 
Do you mean 
Reply

Trouble restoring database backup copy

Tuned Listener
Posts: 113
Country: USA

Trouble restoring database backup copy

I'm having trouble restoring a backed up database.  I've created the db locally, backed it up and am trying to restore on the server.  I've remoted in to the server, and shortly after selecting the option to restore and move I receive the following error message:
 
Act.Data.ActDb.ActDbException:  Directory lookup for the file "F:\...... .Adf" failed with the operating system error 3 (The system could not find the path specified.)
File 'ACT_Data' cannot be restord to 'F:....... . ADF".  Use with move to identify a valid locaton for the file. 
 
From the message, it looks like it's not able to find the ADF file in the Zip file, but I've created the backup and trying restoring multiple times  Any suggestions?
Platinum Elite Contributor
Posts: 14,384
Country: Australia

Re: Trouble restoring database backup copy

Did you use a CD? The ZIP needs to be on a hard disk as it expands it in the same folder
 
Also, are you restoring to a local volume - not a mapped path
 
Finally, use Restore_As in the Restore dialog
Tuned Listener
Posts: 113
Country: USA

Re: Trouble restoring database backup copy

Thanks, Mike.  I would like to restore to a mapped path.  Do I need to take any extra steps other than what you've described?
Platinum Elite Contributor
Posts: 14,384
Country: Australia

Re: Trouble restoring database backup copy

You can't. SQL databases need to be on a local path.
 
Why would you think you want to?