Copy database to another server while open

[Thomas Kroljic]

All,

Does anyone have any suggestions on how to copy Access mdb files from
one server to another on an hourly basis? Besides our routine nightly
backups to tape using Veritas, I'd like to create copies of the databases on
a hourly basis and store them on another server in case our main server goes
down so we can quickly be running on the second server with very little lost
of data (and without having to restore from our backup tape).



Is this possible?



I posted this earlier in a much long winded form. Sorry for the double
posting.



Thank you,

Thomas J. Kroljic

 

[Douglas J. Steele]

While it may be possible,it's certainly not advisable.

Copying an open database can leave the database in an inconsistent state.

 

[Thomas Kroljic]

Doug,
Thanks for the reply. I was thinking the same thing. Any suggestions on
how I can copy the database to another server during working hours without
disrupting users? Our system is not that heavily used. very small number of
transactions. I was even thinking that maybe I should use some extra VBA to
write data to a second database when users enter data into the main
database.

Thomas j. Kroljic

 

[Douglas J. Steele]

I've never actually tried, but it might be possible to export the tables
one-by-one.

On the other hand, if you have a strong need for this, perhaps your backend
should be in SQL Server, or some other DBMS with better backup and recovery
capabilities.

 

[Thomas Kroljic]

Doug,
thanks for your advice. I going to start to do some research on a more
"robust" database.

thomas j. kroljic