[AccessD] Automatic backup

[Jim Dettman]

Jim,

  That doesn't give you a true backup either.  The product uses Microsoft
Volume Shadow Service, and there is no VSS writer for JET.

  So you have the same problem...if there's any activity in the database,
then you can have a backup that ends up in an inconsistent state.

 If the database is quiet (say middle of the night), then a simple file copy
achieves the same thing. In a multi-user situation, a JET db file is never
locked.  Only the .LDB file has locks placed against it.

Jim. 

-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim
Lawrence
Sent: Friday, March 18, 2016 02:30 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Automatic backup

Hi Jim:

A "Shadow" backup can do a backup on individual files even when a file is
locked.
https://www.runtime.org/data-recovery-products.htm

Check out the following free app: 
https://www.runtime.org/shadowcopysetup.exe

When I was working I used a "shadow" batch file to do a database backup when
the users forgot to get out of their applications.

Jim

----- Original Message -----
From: "Jim Dettman" <jimdettman at verizon.net>
To: "Access Developers discussion and problem solving"
<accessd at databaseadvisors.com>
Sent: Thursday, March 17, 2016 10:03:06 AM
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