Site5 Q&A » How does backup work with .mdb files which are open?

How does backup work with .mdb files which are open?

In: Advanced Asked By: skermangull [2

]

Hi all,
Recently I was asked to perform a restore of a mdb (microsoft access) file.
According to the client, the file is updated regularly (daily) but when I looked for it in order to start the restore, I couldn’t find the file.
To be more specific:
I found an old file in the Full backup in the location specified by the client.
I couldn’t find the file in none of the incremental backups.
Just one thing to add, all the backups end with status code 1.
This is my first discussion, I hope i accomplish with all the posting rules.

2 Answers Answer this Question Now

Oct 21, 2015

Answer #1

Hello,

I would not be able to provide a specific answer, as we are 100% Linux-based, and do not run Microsoft Access databases. However, like most database systems, while generating the backup it would close everything during the copy, if needed, to prevent corruption.

Answered By: jdavey [359

]

Answer #2

Hi there,
usually I set 2 policies,
I for the files
https://www.reddit.com/r/Database/comments/3end20/opening_access_file/
another for the DB
the MDB file I put at the exclude list from the files policy
by the way MSSQL must be confugured a http://www.mdb.viewertool.com/

Answered By: alowsdoreal [2

]

Answer this Question

You must be Logged In to post an Answer.

Not a member yet? Sign Up Now »