Video Screencast Help

Problems restoring access database

Created: 09 Apr 2013 • Updated: 17 Apr 2013 | 4 comments
This issue has been solved. See solution.

I was out in the field today so I can only go off of what my coworkers explained to me...  We have an access database that occassional gets corrupted, so we run incremental backups of it every hour on the hour throughout the work day.  Sure enough while I was out of the office today it got curropted.  Our DBA created a restore job to restore the database files, he set it to overwrite the existing file...  The job ran successfully without any exceptions.  He then went to log back into the database and it was still curropted..  He tried it multiple times from different restore points, same results, job successful no exceptions however the database was still curropted.  Finally our other Network tech restored the lastest backup to the desktop and then copied and pasted the files over the existing files and it worked.  Why?  Why did it report that the restore was successful and would not overwrite the existing files?

Operating Systems:

Comments 4 CommentsJump to latest comment

pkh's picture

Did you select the "Restore over existing files" option?  See below.

BE 2012 - restore how.png

prs246191's picture

They said they tried all 3...  I'll confirm tomorrow.  Thanks

prs246191's picture

So I conferred with my co-workers and yes they tried all 3...  However I think I figuered out the problem...   They were unchecking the "Recreate the directory structure from the backup when the data is restored; otherwise, all data is restored without any directory structure".  With that boxed checked it overwrote the file...  Without it unchecked it did not.... I agree with my co-workers logic, why would you need to recreate the directory structure for one file?

pkh's picture

Without the directory structure, I think the file is restored to the root of the directory structure.  If the structure is C;\a\b\c, I think the file will end up in C:\.  Check the directory structure and see whether you find the restored file in the structure.

I know that if you do a redirected restore to C:\a and do not preserve the directory structure, the file will end up at C:\a