[Webinar] Streamline your web hosting managementRegister Today

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 656
  • Last Modified:

access 2003 auto backup

Recently saw a DB system that seemed to automatically backup, however there was always only one backup in the drive, so i am assuming it always overwrites the previous backup.  This was done on an automatic basis, I don't know if it was everytime the system was closed by a user or on a daily basis when the system was closed.  Anybody have any idea how to set this up?
  • 2
1 Solution
There are many ways to backup a database. Depending upon how critical your database data is, you can as many of the techniques below that you want.  

This is what I do to back up our database.  It may seem excessive but the data is critical to our business and I am very paranoid having been a system's engineer through the 70's and 80's when hard drive crashes were common.

The backend is stored on a raid 7 disk pack.  The server will email me if there is a problem.

Every half hour that the frontend is running, the frontend copies the backend to a raid 0 disk pack by shelling to the DOS copy command.  The DOS copy command will copy an open file.  The only time the copy is corrupted is when someone writes to the backend during the 30 seconds the copy is being made.  The database deletes copies that are more than two hours old so I always have the last 4 copies.  The database will email me if it runs into a problem.  (These copies are very useful for things like a user saying, "I just accidental deleted everything in a memo field.")

Every night, a workstation runs MS backup zipping a copy of the BE to its harddrive.  I keep all these backups for the last four months.

Every night, another workstation runs Second Copy (www.centered.com) zipping a copy to a ftp site on our hosted www.nosuffering.com site.  Second Copy will email me if it runs into a problem.  The data center is in California.

Every night, a third workstation runs Handy Backup which compacts and repairs and then zips the file to a ftp site on my hosted www.thenelson.name site.  Handy Backup will email me if it runs into a problem.  The data center is in Pennsylvania.

I also look in on all the backups a couple of times a week.  This way, I am not relying on one computer or one piece of software for the backups.  I have automatic offsite backups at opposite ends of the country.  All of this has cost me $50 for Second Copy and Handy Backup and $9 a month for two hosted websites (which includes my websites www.nosuffering..com and www.thenelson.name).
LadyHagoodAuthor Commented:
Cool. i will look at those web sites this morning if i get a chance, second copy and handyback up.  Thanks.

Also, thenelson, you have answered a few of my questions and  have looked at your site andi was just wondering if you would have advice on some classes to take to reach "expert" level for access and sql server? Looking to do some formal online class.  Do you have any to recommend?
"advice on some classes to take to reach "expert" level for access and sql server"
It would be better to post this as a separate question. You could also do an EE  search on this subject as if has been asked many times.

Featured Post

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now