Backing up database

[JasonPurdueEE]

Hello everyone. I am trying to come up with the best way to make backups of my database. How do you back up your databases?

Is there something better than manually copying and pasting the db files? I suspose I could come up with a way to run a batch file from code (using a shell command) to copy the files. Does anybody see anything wrong with doing it this way? I figure the migh be problems associated with having users in the BE when trying to copy it, but I can overcome this by having the batch file look for the presence of a lock file and not copying the BE if somebody is in it. Perhaps there is a beter way to backup, any suggestions?

Thanks,
Jason

______________________________
Sleep is a poor substitute for coffee.

 

[smedvid]

Sounds like something I have in place...

I have a scheduled task that runs on my PC that make a daily copy of the mdb at 11:00pm each night. This is an extra backup to the Network tape backup that runs each day.

I have also developed a mdb in that past with an autoexec that call a procedure to make and store dated copies of mdbs. The procedure simply used the File Scripting Object to look for Lock File as u mentioned. If the Lock file is older than 24 hours I delete it. There are occassionally rougue lock files that are created. I then, Compact the database, rename it to a file name with date stamp embedded and place it into a network drive for reference. I also check to see if there are any archive files that are older than 7 days and delete them.

But, your approach is fine... More than one way to accomplish the task. Depends upon needs and amount of time available to devise a solution. htwh,

Steve Medvid
"IT Consultant & Web Master"

http://www.saveourfarm.com

Chester County, PA Residents
Please Show Your Support...