How safe is it to back up a single user mdb when it is opened. No tables are
opened at the time of the backup. The only object that is open is the form
from which the backup code is being run.
Thanks in advance,
john
16  3939 
"No tables are opened"
should be
"No tables are open"
"john" <jo**@test.comschreef in bericht
news:7J********************@casema.nl...
How safe is it to back up a single user mdb when it is opened. No tables
are opened at the time of the backup. The only object that is open is the
form from which the backup code is being run.
Thanks in advance,
john
john wrote:
"No tables are opened"
should be
"No tables are open"
As long as your backup software doesn't skip files that are open it
should be fine.
I have read stories in the past about people backing up data for a year
and the backup software, in the entire time, skipped the file(s) because
it was open. Then they deleted all of the records to reset for the new
year and then ask "Can I get my deleted tables back?
I've seen backup software that looks like it's backing up the files but
in reality its simply scanning the files to see what to backup. So the
user needs to restore a backuped up file and verify the tape's not blank.
Best thing to do is attempt to save it. Next, after the save attempt to
restore to another folder. Also, ensure you don't set your medium to
"no write" after a backup and you want to reuse the medium at a later time.
>
"john" <jo**@test.comschreef in bericht
news:7J********************@casema.nl...
>>How safe is it to back up a single user mdb when it is opened. No tables
are opened at the time of the backup. The only object that is open is the
form from which the backup code is being run.
Thanks in advance,
john
On Sat, 16 Sep 2006 23:53:02 +0200, "john" <jo**@test.comwrote:
That seems pretty safe. The danger with backing up Access databases is
that at the moment of backup they could be written to, creating an
inconsistent backup. A very small chance, but would you want to take
it?
If you are SURE no activity is going on, you have my blessing FWIW.
-Tom.
>How safe is it to back up a single user mdb when it is opened. No tables are
opened at the time of the backup. The only object that is open is the form
from which the backup code is being run.
Thanks in advance,
john
On Sat, 16 Sep 2006 23:53:02 +0200, "john" <jo**@test.comwrote:
>How safe is it to back up a single user mdb when it is opened. No tables are
opened at the time of the backup. The only object that is open is the form
from which the backup code is being run.
Thanks in advance,
john
You've seen the other posts. Why take chances. Write a simple batch file
independent of the database that does the backup while the database is closed.
Chuck
--
Chuck <li*****@schoollink.netwrote in
news:nk********************************@4ax.com:
On Sat, 16 Sep 2006 23:53:02 +0200, "john" <jo**@test.comwrote:
>>How safe is it to back up a single user mdb when it is opened. No
tables are opened at the time of the backup. The only object that
is open is the form from which the backup code is being run.
Thanks in advance,
john
You've seen the other posts. Why take chances. Write a simple
batch file independent of the database that does the backup while
the database is closed.
How does Lyle's SaveAsText trick do? Has anyone tested it in the
edit condition to see what it backs up?
--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/
On Sun, 17 Sep 2006 19:01:18 -0500, "David W. Fenton"
<XX*******@dfenton.com.invalidwrote:
SaveAsText does not backup tables.
-Tom.
>Chuck <li*****@schoollink.netwrote in
news:nk********************************@4ax.com :
>On Sat, 16 Sep 2006 23:53:02 +0200, "john" <jo**@test.comwrote:
>>>How safe is it to back up a single user mdb when it is opened. No
tables are opened at the time of the backup. The only object that
is open is the form from which the backup code is being run.
Thanks in advance,
john
You've seen the other posts. Why take chances. Write a simple
batch file independent of the database that does the backup while
the database is closed.
How does Lyle's SaveAsText trick do? Has anyone tested it in the
edit condition to see what it backs up?
Tom van Stiphout wrote:
SaveAsText does not backup tables.
Yes, it does.
Try:
SaveAsText 6, "", FileName http://www.mvps.org/access/downloads/wzbackup.zip
Just tried it by putting a record into edit mode, it still saved the table
but (fairly obviously) with the original value for the field I was editing.
--
Terry Kreft
"David W. Fenton" <XX*******@dfenton.com.invalidwrote in message
news:Xn**********************************@127.0.0. 1...
Chuck <li*****@schoollink.netwrote in
news:nk********************************@4ax.com:
On Sat, 16 Sep 2006 23:53:02 +0200, "john" <jo**@test.comwrote:
>How safe is it to back up a single user mdb when it is opened. No
tables are opened at the time of the backup. The only object that
is open is the form from which the backup code is being run.
Thanks in advance,
john
You've seen the other posts. Why take chances. Write a simple
batch file independent of the database that does the backup while
the database is closed.
How does Lyle's SaveAsText trick do? Has anyone tested it in the
edit condition to see what it backs up?
--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/
Tom van Stiphout <no*************@cox.netwrote in
news:f8********************************@4ax.com:
On Sun, 17 Sep 2006 19:01:18 -0500, "David W. Fenton"
<XX*******@dfenton.com.invalidwrote:
>>Chuck <li*****@schoollink.netwrote in
news:nk********************************@4ax.co m:
>>On Sat, 16 Sep 2006 23:53:02 +0200, "john" <jo**@test.com>
wrote:
How safe is it to back up a single user mdb when it is opened.
No tables are opened at the time of the backup. The only object
that is open is the form from which the backup code is being
run. Thanks in advance,
john
You've seen the other posts. Why take chances. Write a simple
batch file independent of the database that does the backup
while the database is closed.
How does Lyle's SaveAsText trick do? Has anyone tested it in the
edit condition to see what it backs up?
SaveAsText does not backup tables.
Um, have you tried SaveAsText 6, the trick that Lyle came up with?
--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/
"Terry Kreft" <te*********@mps.co.ukwrote in
news:FN******************************@eclipse.net. uk:
"David W. Fenton" <XX*******@dfenton.com.invalidwrote in message
news:Xn**********************************@127.0.0. 1...
>Chuck <li*****@schoollink.netwrote in
news:nk********************************@4ax.com :
On Sat, 16 Sep 2006 23:53:02 +0200, "john" <jo**@test.com>
wrote:
How safe is it to back up a single user mdb when it is opened.
No tables are opened at the time of the backup. The only object
that is open is the form from which the backup code is being
run. Thanks in advance,
john
You've seen the other posts. Why take chances. Write a simple
batch file independent of the database that does the backup
while the database is closed.
How does Lyle's SaveAsText trick do? Has anyone tested it in the
edit condition to see what it backs up?
http://www.mvps.org/access/downloads/wzbackup.zip
Just tried it by putting a record into edit mode, it still saved
the table but (fairly obviously) with the original value for the
field I was editing.
I don't consider that problematic, myself, as you have a consistent
state of the database. It's only the file system copy that could
possibly get an inconsistent state, I think, so anything that you do
through code ought to work.
Although, actually, I guess it would be possible to violate
referential integrity if you copied the child tables after the
parent tables.
--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/
Yes, That was what I thought you were getting at and there appears to be no
problm.
The referential integrity problem is a posibility.
--
Terry Kreft
"David W. Fenton" <XX*******@dfenton.com.invalidwrote in message
news:Xn**********************************@127.0.0. 1...
"Terry Kreft" <te*********@mps.co.ukwrote in
news:FN******************************@eclipse.net. uk:
"David W. Fenton" <XX*******@dfenton.com.invalidwrote in message
news:Xn**********************************@127.0.0. 1...
Chuck <li*****@schoollink.netwrote in
news:nk********************************@4ax.com:
On Sat, 16 Sep 2006 23:53:02 +0200, "john" <jo**@test.com>
wrote:
How safe is it to back up a single user mdb when it is opened.
No tables are opened at the time of the backup. The only object
that is open is the form from which the backup code is being
run. Thanks in advance,
john
You've seen the other posts. Why take chances. Write a simple
batch file independent of the database that does the backup
while the database is closed.
How does Lyle's SaveAsText trick do? Has anyone tested it in the
edit condition to see what it backs up?
http://www.mvps.org/access/downloads/wzbackup.zip
Just tried it by putting a record into edit mode, it still saved
the table but (fairly obviously) with the original value for the
field I was editing.
I don't consider that problematic, myself, as you have a consistent
state of the database. It's only the file system copy that could
possibly get an inconsistent state, I think, so anything that you do
through code ought to work.
Although, actually, I guess it would be possible to violate
referential integrity if you copied the child tables after the
parent tables.
--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/
"Terry Kreft" <te*********@mps.co.ukwrote in
news:UO******************************@eclipse.net. uk:
"David W. Fenton" <XX*******@dfenton.com.invalidwrote in message
news:Xn**********************************@127.0.0. 1...
>"Terry Kreft" <te*********@mps.co.ukwrote in
news:FN******************************@eclipse.net .uk:
"David W. Fenton" <XX*******@dfenton.com.invalidwrote in
message news:Xn**********************************@127.0.0. 1...
Chuck <li*****@schoollink.netwrote in
news:nk********************************@4ax.com :
On Sat, 16 Sep 2006 23:53:02 +0200, "john" <jo**@test.com>
wrote:
How safe is it to back up a single user mdb when it is
opened. No tables are opened at the time of the backup. The
only object that is open is the form from which the backup
code is being run. Thanks in advance,
john
You've seen the other posts. Why take chances. Write a
simple batch file independent of the database that does the
backup while the database is closed.
How does Lyle's SaveAsText trick do? Has anyone tested it in
the edit condition to see what it backs up?
http://www.mvps.org/access/downloads/wzbackup.zip
Just tried it by putting a record into edit mode, it still
saved the table but (fairly obviously) with the original value
for the field I was editing.
I don't consider that problematic, myself, as you have a
consistent state of the database. It's only the file system copy
that could possibly get an inconsistent state, I think, so
anything that you do through code ought to work.
Although, actually, I guess it would be possible to violate
referential integrity if you copied the child tables after the
parent tables.
Yes, That was what I thought you were getting at and there appears
to be no problm.
That's what I've been getting at in all my replies on this thread,
but the point seems to have been missed by most people. Perhaps I
could have made it clearer.
The referential integrity problem is a posibility.
This suggests that not relying on a black box like SaveAsText 6
might be preferable, i.e., doing your own backup in DAO, and copying
the child tables first, and the parent tables last. Dunno what you'd
do for circular relationships.
--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/
Agreed.
The only way you can ensure data integrity is to wait for a consistent state
and then lock all relevant tables in order to back them up.
--
Terry Kreft
"David W. Fenton" <XX*******@dfenton.com.invalidwrote in message
news:Xn**********************************@127.0.0. 1...
"Terry Kreft" <te*********@mps.co.ukwrote in
news:UO******************************@eclipse.net. uk:
"David W. Fenton" <XX*******@dfenton.com.invalidwrote in message
news:Xn**********************************@127.0.0. 1...
"Terry Kreft" <te*********@mps.co.ukwrote in
news:FN******************************@eclipse.net. uk:
"David W. Fenton" <XX*******@dfenton.com.invalidwrote in
message news:Xn**********************************@127.0.0. 1...
Chuck <li*****@schoollink.netwrote in
news:nk********************************@4ax.com:
On Sat, 16 Sep 2006 23:53:02 +0200, "john" <jo**@test.com>
wrote:
How safe is it to back up a single user mdb when it is
opened. No tables are opened at the time of the backup. The
only object that is open is the form from which the backup
code is being run. Thanks in advance,
john
You've seen the other posts. Why take chances. Write a
simple batch file independent of the database that does the
backup while the database is closed.
How does Lyle's SaveAsText trick do? Has anyone tested it in
the edit condition to see what it backs up?
http://www.mvps.org/access/downloads/wzbackup.zip
Just tried it by putting a record into edit mode, it still
saved the table but (fairly obviously) with the original value
for the field I was editing.
I don't consider that problematic, myself, as you have a
consistent state of the database. It's only the file system copy
that could possibly get an inconsistent state, I think, so
anything that you do through code ought to work.
Although, actually, I guess it would be possible to violate
referential integrity if you copied the child tables after the
parent tables.
Yes, That was what I thought you were getting at and there appears
to be no problm.
That's what I've been getting at in all my replies on this thread,
but the point seems to have been missed by most people. Perhaps I
could have made it clearer.
The referential integrity problem is a posibility.
This suggests that not relying on a black box like SaveAsText 6
might be preferable, i.e., doing your own backup in DAO, and copying
the child tables first, and the parent tables last. Dunno what you'd
do for circular relationships.
--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/
"Terry Kreft" <te*********@mps.co.ukwrote in
news:G8********************@eclipse.net.uk:
The only way you can ensure data integrity is to wait for a
consistent state and then lock all relevant tables in order to
back them up.
I actually disagree with that. All you need is a snapshot that has
data integrity at the time it's created. Copying the child tables
first insures that you won't have any orphaned records, so you'd end
up with a consistent state of the database. Your backup might not be
identical to what you would have gotten if you'd waited 1 second or
1 minute or 1 hour or 1 day, but that doesn't really seem to me to
be a reasonable objection.
--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/
Sorry my answer was misleading, I was referring to your comment about cyclic
dependencies.
--
Terry Kreft
"David W. Fenton" <XX*******@dfenton.com.invalidwrote in message
news:Xn**********************************@127.0.0. 1...
"Terry Kreft" <te*********@mps.co.ukwrote in
news:G8********************@eclipse.net.uk:
The only way you can ensure data integrity is to wait for a
consistent state and then lock all relevant tables in order to
back them up.
I actually disagree with that. All you need is a snapshot that has
data integrity at the time it's created. Copying the child tables
first insures that you won't have any orphaned records, so you'd end
up with a consistent state of the database. Your backup might not be
identical to what you would have gotten if you'd waited 1 second or
1 minute or 1 hour or 1 day, but that doesn't really seem to me to
be a reasonable objection.
--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/
"Terry Kreft" <te*********@mps.co.ukwrote in
news:F4******************************@eclipse.net. uk:
"David W. Fenton" <XX*******@dfenton.com.invalidwrote in message
news:Xn**********************************@127.0.0. 1...
>"Terry Kreft" <te*********@mps.co.ukwrote in
news:G8********************@eclipse.net.uk:
The only way you can ensure data integrity is to wait for a
consistent state and then lock all relevant tables in order to
back them up.
I actually disagree with that. All you need is a snapshot that
has data integrity at the time it's created. Copying the child
tables first insures that you won't have any orphaned records, so
you'd end up with a consistent state of the database. Your backup
might not be identical to what you would have gotten if you'd
waited 1 second or 1 minute or 1 hour or 1 day, but that doesn't
really seem to me to be a reasonable objection.
Sorry my answer was misleading, I was referring to your comment
about cyclic dependencies.
I consider circular relationships to be an indicator of a possible
schema error. Most of them are due to use a 1:N in place of an N:N
join table, which almost always removes the problem (since it breaks
the circle).
--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/ This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Tim Gahnstrom |
last post by:
rdiff-backup is aperently written in Python and when I run it in a
special way I get some funy Python errors. Does anyone know if linux
python have some issues with working with fat32 or usb...
|
by: Tam |
last post by:
Hi,
I am new to Win2k and SQL server and need to back up everything each night.
I used the supplied NT backup utility to schedule a backup but this missed
some files that were open or in use.
I...
|
by: TThai |
last post by:
Hi,
Appreciated anyone who can help us with our problem. Our backup job
for ROUTT database has been failing for the last 4 days. It was
working fine for almost a year now. The only thing...
|
by: Spieg |
last post by:
I've a program with VB6 working with SQLServer 2000.
I have a Central Station with the program runnin with full prvileges and
that can perform all the actions on the DB.
There are also some...
|
by: Uthuras |
last post by:
Greetings,
We have DB2 V 8.1 with FP 4 on AIX 5.2. Our database backup is done
using TSM v
4.1.2. However, we notice TSM make use of only one session even though
we defined 4 sessions for...
|
by: Charles Morrall |
last post by:
I have no experience with DB2 as such, but I've been tasked with configuring
backup of a server running DB2 v8 on Windows Server 2003. I do have some
experience with backups in general though. The...
|
by: rdemyan via AccessMonster.com |
last post by:
I'm thinking about providing a relatively easy method for users to restore
the front end from a backup. The purpose is to allow for restoring if the
front end becomes corrupt.
Here are some...
|
by: m19peters |
last post by:
We have a script that I had to rework a little bit for 2005 that does
a full backup for every database on the server... For some reason on
some nights the script does not backup all databases......
|
by: Roger |
last post by:
backup log testdb with truncate_only
DBCC SHRINKFILE (testdb_log, 100) WITH NO_INFOMSGS
backup database testdb to disk = '\\DC01\Backups\DB01\testdb.bak' with
init
and does the shrinkfile...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
| |
