[AccessD] Automatic backup

[James Button]

And - 
Maybe robocopy will be appropriate - I believe it requires exclusive access to a
file in order to copy it - but there are options such as /B
And maybe more to the point - 
/R:n Number of Retries on failed copies: default 1 million. 
/W:n Wait time between retries: default is 30 seconds.

/MOT:n MONitor source; run again when more than n changes seen. - 

As well as, by default, using the API that is not limited to 256 byte filenames
- 

again - the tee.exe program is useful for creating a logfile!

JimB



-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of James
Button
Sent: Thursday, March 17, 2016 7:07 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Automatic backup

Yup!

But the number of times I was complained to about a backup not working - 
As in the backup had been taken while the multi-user app was still open - 
Someone had just gone home without closing down their login, or their connection


And FileHistory (part of win 7 through win 10) - currently being proffered as
the backup facility to rely on 
 will take backup copies of files while the apps are using them!


JimB
 

-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim
Dettman
Sent: Thursday, March 17, 2016 6:38 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Automatic backup


 I wasn't being clear.

 "can't" in that you should not, not that you can't do it.  "Backup" in the
sense that your going to use a file copy.

 To get a valid backup by any means, you need all the users out, which means
you can't do a backup from within the app itself.

Jim.

  

-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
James Button
Sent: Thursday, March 17, 2016 01:14 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Automatic backup

Technically that's Wrong 

- you can back it up while open - 
Just the App (DBMS) will probably decline to open the backup - that being on
the
basis that the copy shows it is already open - and in use.

You don't discover that until you actually need to open the backup with the
DBMS
... ... ...

JimB
 

-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim
Dettman
Sent: Thursday, March 17, 2016 5:03 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Automatic backup


 You can't backup a currently opened DB.

 There's no locks held on a DB so you can do the file copy.   But if another
user is in, or even in your own process if any background tasks are
processing, you might end up with an inconsistent DB.

 Of course you could do that in a small utility DB.

Jim. 

-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
Bill Benson
Sent: Thursday, March 17, 2016 12:11 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Automatic backup

What is wrong with

Set FSO =CreateObject ("Scripting.FilesystemObject)
On Error Resume Next
Kill strPathtoBackupFile
On Error Goto 0
FSO.GetFile (currentDb.Name).Copy strPathtoBackupFile
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com