Re: [ADSM-L] open Access files
Yeah, but unless the Access application opens the database with exclusive use,
you can get a backup of an open Access database. And
even Microsoft says that's a no-no. I use to have a link to a KB article at
Microsoft that said even doing a COPY of an open MDB
file would leave the copy corrupt and unusable. Retrying 3-times (SHRSTATIC) is
OK, but if the file doesn't change and is just open
during the backup, you got a backup that might not be any good.
That is unless Microsoft has changed the way Access operates in later releases.
That KB article was a couple years old.
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Sent: Friday, August 17, 2007 4:06 PM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: open Access files
we just have TSM set to retry three times then pass on open files.
better no backup then false sense of security.
>>> GEOFFREY.L.GILL AT SAIC DOT COM 08/17/2007 5:00 PM >>>
I sent this the other day and saw no responses so I'm trying again in case it
did not get through. If anyone has any info on this I
would appreciate feedback.
From: Gill, Geoffrey L.
Sent: Thu 8/16/2007 6:35 PM
To: ADSM (ADSM-L AT VM.MARIST DOT EDU)
Subject: open Access files
Hello again all,
I was wondering if anyone can tell me how they deal with Microsoft Access
(.mdb) files. If these files remain in an open state when
the backup runs are there any issues? Will they get backed up? Will they be in
a usable state when restored if they do get backed up
while open? We know from past experience open Oracle files are not, which is
why tools are available to back these up, but I'd like
to hear from anyone who has experience the .mdb's.
Thanks for the help.
The information contained in this electronic message and any attachments to
this message are intended for the exclusive use of the
addressee(s) and may contain information that is confidential, privileged,
and/or otherwise exempt from disclosure under applicable
law. If this electronic message is from an attorney or someone in the Legal
Department, it may also contain confidential
attorney-client communications which may be privileged and protected from
disclosure. If you are not the intended recipient, be
advised that you have received this message in error and that any use,
dissemination, forwarding, printing, or copying is strictly
prohibited. Please notify the New York State Thruway Authority immediately by
either responding to this e-mail or calling (518)
436-2700, and destroy all copies of this message and any attachments.