ADSM-L

Re: [ADSM-L] open Access files

2007-08-18 08:58:17
Subject: Re: [ADSM-L] open Access files
From: "Gill, Geoffrey L." <GEOFFREY.L.GILL AT SAIC DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Sat, 18 Aug 2007 05:56:15 -0700
Thanks all for the responses. As I suspected it seems nothing has changed as it 
relates to Access databases, so now all I need to deal with is folks that just 
don't understand why "everything" isn't "always" backed up. 

________________________________

From: owner-adsm-l AT VM.MARIST DOT EDU on behalf of Richard Sims
Sent: Fri 8/17/2007 4:15 PM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: open Access files



On Aug 17, 2007, at 5:54 PM, William Boyer wrote:

> 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.

Amen.
As List participants have tried to point out in the past, backing up
the physical files constituting a database while the database
facility is running is shooting in the dark.  Even if you can get a
good backup of the files, that by no means assures that you have
consistent data, given that so many pieces of the database may be in
memory.  Database systems provide access APIs and IBM provides TDPs
based upon them because that's the right way to perform backups on
these dynamic systems.

    Richard Sims

<Prev in Thread] Current Thread [Next in Thread>