Restore Database Error

yvonne

I am using Nav 3.7. I tried to restore database backup into new database in Nav Native database and Nav SQL DB (SQL 2000 server), but both restore keep prompt same error while the restore process reached 100%

Error message "File ‘backup file directory\backup.fbk’ was not found."

I followed by click "OK" on the error message, & open again my database, there is no available company for me to select.

Please HELP! :?

Nobody

If your back-up has multiple FBK files that may explain the error. When you do a NAV back-up and it creates multiple FBK files the path where those files were created is hardcoded into the FBK so when you restore and it looks for the second file in the FBK file set it looks to the hardcoded path where the FBK files where first made and and if they have been moved since then you will receive and error that it can not find the FBK file. If you copy all the FBK in the set to the root of a drive like C:\ or \ it will ignore the hardcoded path and restore all the FBK files.

SQL back-up and restores are much faster and do not have this limitation

DenSter

It is certainly not hard coded to look in the original save location, it is hard coded to look in the same folder for consecutive files. You need to make sure that all FBK files are in the same folder when you restore the NAV database. Locate the second file, put it in the same folder as the other and you should be able to pick up the restore right where it left off.

yvonne

I got it. Thank you for solution.