Problems restoring access database
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?