Link to home
Start Free TrialLog in
Avatar of egovernment
egovernmentFlag for Afghanistan

asked on

Best tool for backup & restore access database

Which is best backup & restore access database ?

How I can taik a backup while access database running ?
Avatar of DatabaseMX (Joe Anderson - Former Microsoft Access MVP)
DatabaseMX (Joe Anderson - Former Microsoft Access MVP)
Flag of United States of America image

Are you aware of the built in Utility - see image.

mx
Capture1.gif
ASKER CERTIFIED SOLUTION
Avatar of DatabaseMX (Joe Anderson - Former Microsoft Access MVP)
DatabaseMX (Joe Anderson - Former Microsoft Access MVP)
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
You could "build your own" in-place backup, but doing so would certainly end up costing you more than the Agent product mentioned above. I've not actually used it, so cannot comment on whether it's suitable for your purpose.
Avatar of egovernment

ASKER

I search a tool can do the backup while use from users and if possible other functions like compact.
Did you review the link posted above? I quote from that site:

"You can even back up data while users are in the database "

It also includes other functionality:

Database compact and repair
Database copy and zip backups
Macro Scheduler: Launch Microsoft Access and run your macro which can do things like print reports, download data, export information, and run your custom VBA code
Data extraction while users are in the database
Collect database statistics like record counts to monitor usage
Run any Windows command line

Generally, when the experts provide you with a link to a page, it's wise to review that page. We're certainly glad to answer questions, but you really can't expect us to do your reading for you :)

Actually the challenge is that Access requires a full lock to perform a compact. Total Visual Agent addresses this problem by providing a feature to perform a data extract. This creates a backup database and grabs the data table by table into the copy. If the data changes during the extraction period, it won't be an exact snapshot. However, if it's performed during a time when people are inactive, the data may be okay. Total Visual Agent can be scheduled to do this at very short intervals so you can get as close as consistent a copy as practical.

If anyone has a better suggestion to address this in Access, I'd be happy to know about it. For really mission critical 24/7 operations, the data should be in a client server environment like SQL Server.
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Also look to your tape software.  Many, such as Backup Exec have an open file option, which allows you to accurately backup an open file.

 Backup Exec has three different ways of implementing that, one of which is the VSS (Volume Shadow Copy) built into windows that gustav mentioned.  It also has it's own agent that you can use, which hooks the OS's I/O to a volume.

  With that, if it encounters an open file, it paues I/O to that file, then takes a snapshot of it, and resumes file I/O.  In this way you get a consistent view of a file at a given point in time.

  Without that, you really don't have a backup of a file.

JimD

I will check all answers
Has this question been resolved?  Can we close the question ?

thx.mx